Hello
Need help for my app!
In my source data (sheets), I have a column based on a data validation. This is updated regularly (it’s a staff list).
In my app, the column is of type “Enum” but the data list is not updated automatically when my source data is updated.
Can you help me?
Hello, how are you? I think the issue might be that your column is of the “enum” type (a dropdown list). However, you can solve this by creating a table, perhaps named “Personnel,” where you store records with your staff’s data. In that table, you’ll have an ID field, a name field, and other details. Make sure the name field is set as the label.
In your other table, you’ll have a column, but it should be of the “ref” type instead of “enum.” When it asks which table it should reference, select the “Personnel” table.
Now, every time you add an entry in the Personnel table, this list will automatically update
1 Like
Thanks, it’s perfect
Your app will only become aware of changes to the data validation rules in your spreadsheet when you regenerate columns of the table in the app editor, as noted in the help doc:
2 Likes