I have an app to manage inventory gear with a table called All Gear and another called Gear Categories.
The table All Gear includes the following columns:
The table Gear Categories includes the following columns:
I wrote this expression so when the department is selected, the category field only shows gear used in that department:
UNIQUE(SELECT(Gear Categories[Category], CONTAINS([Departments],[_THISROW].[Department])))
When the category is selected, the sub-category field only contains gear in that category:
UNIQUE(SELECT(Gear Categories[Sub-category], AND(CONTAINS([Departments],[_THISROW].[Department]),[Category]=[_THISROW].[Category])))
The item field is self-referencing to the table and only shows items used in that department,
UNIQUE(SELECT(All Gear[Item], AND([Department]=[_THISROW].[Department],[Facility]=[_THISROW].[Facility],[Category-Sub-category]=[_THISROW].[Category-Sub-category]), TRUE))
All these expressions work properly and show the correct values.
When I try and add fields to this table I get the error message:
Unable to add row to table 'All Gear'. โ Value 'Ropes' in field 'Category' cannot be converted to type 'Enum'.
I can do the following to technically solve the problem and allow the form to save but these options don't work for our processes and needs:
I really don't understand why this isn't working because I have a similar setup on other tables (of fields, suggested values, and expressions) and they work, so I'm at a loss.
I talked to customer service and their suggestions didn't work to solve this.
Can anyone please help??
Solved! Go to Solution.
@beckythecoolest wrote:
Selecting the checkmark to "Allow other values"
Did you un-select the "auto-complete other values" option?
Are those expressions you mentioned in valid_if?
@beckythecoolest wrote:
Selecting the checkmark to "Allow other values"
Did you un-select the "auto-complete other values" option?
Are those expressions you mentioned in valid_if?
"auto complete other values" adds all existing values in that column, from all other records in the table, to the dropdown. So basically it assumes that all existing values are also valid options.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |