I have a table that is generated from a Google Sheet. In the “Work Order sheet” there is a “Part No.” column that uses data validation to pick from a list of parts in the “Parts Inventory Sheet”. As I add parts to the “Parts Inventory Sheet”, my selection in the “Work Order Sheet” is updated via the data validation rule in Google Sheets.
Now the problem is that AppSheet defines the “Part No” column in the “Work Order” table as Enum and builds the list of available choices at the time the table is defined/generated. However, as I add new parts to inventory (i.e. new entry in Parts Inventory Sheet), the Enum list is NOT updated automatically without manually regenerating the table in AppSheet.
Is there anyway around this so my Enum selection is updated automatically???