Hi I cannot access the application. I am getting this error:
Error:Unable to cast object of type โTextMetaDataโ to type โEnumMetaDataโ./n
Please your help to solve it.
Thanks
This typically happens when you try to set the value of a column of type Enum
or EnumList
to a value that the column isnโt configured to allow.
In the configuration for o column of type Enum
or EnumList
, go to the Type Details section. The Values setting should include all acceptable values. If youโd like to allow values that arenโt explicitly configured here, make sure the Allow other values option is enabled.
@Steve Iโm having this problem for the first time when Iโm trying to add/edit/delete a record to a table that has no Enum or EnumList columns.
I have no idea where is the problem
Unable to add/edit/delete row in table โDIM_RECIBIDORโ. โ Unable to cast object of type โTextMetaDataโ to type โEnumMetaDataโ.
Seems like itโs related to a recent change I made around Table config.
On Are updates available? Iโve made an expression:
IFS(
INDEX(DIM_CURRENTUSER[SERVICIO], 1)=(0<>0),
"READ_ONLY",
INDEX(DIM_CURRENTUSER[ROL], 1)="Superuser",
"ALL_CHANGES",
INDEX(DIM_CURRENTUSER[ROL], 1)="Operador",
"ALL_CHANGES",
INDEX(DIM_CURRENTUSER[ROL], 1)="Observador",
"READ_ONLY"
)
Iโm trying to fix it
Thanks! I made the changes and I can now enter the app.
I had to change [ROL] to โAllow other valuesโ
Hate the fact that we have no info why this is needed, it makes no sense. Itโs an Enum basetype Text and the options that I have are all Text
If your Enum
(or EnumList
) column has explicit values defined in the columnโs Type Details section, only those values may occur in that column unless Allow other values is enabled. I agree that the error message is lacking.
Yeah, but there is no other value inside that Enum that is not inside the options I already typed.
Itโs the UserSettings โtableโ
@Steve wrote this "typically happens when you try to set the value of a column of type Enum or EnumList to a value that the column isnโt configured to allow." I experienced it when transitioning an app from "legacy " to "consistent" handling of blank values and I don't think the presence of unallowed values was the cause:
When I changed the setting from "Legacy" to "Consistent" I suddenly got the following error:
โThe solution involved changing the setting to "Allow other values" as you indicated, but I didn't have any "other" values in my spreadsheet and I didn't really want to allow other values. The way I worked around this was to duplicate all of the values that I have in the enum in the "valid if" formula. This works but it was a lot of extra work and I wonder why it's necessary.
Escalated.
Does anyone have an update on this? When I delete a parent record with child records, I get this Error Message:
Unable to delete row from table 'Angebote'. โ Unable to cast object of type 'TableRefMetaData' to type 'EnumMetaData'.
Please contact AppSheet Support for help with this.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |