Hello. Please I want to know something about Enum.
Iโve a large list to add in my app, to allow user to choose quickly their choice.
Is there a way to insert a large list from a CSV file in Appsheet? Or am I forced to enter the data one by one?
Thank you
Solved! Go to Solution.
Maybe this might help?
You can add the Large list as a table Adding a Key column.
Then in your Main table add a reference to the new Table.
When your users Open a form to add an entry this will show a drop down (or buttons if you selected) to be show
Your method is what I do. It seems like a much better choice from a database design perspective. That way, when a value is changed, you still have the proper reference to it. Plus, you can give certain users, in my case, ADMIN, the ability to add/edit/archive values. I donโt allow deletions of REF data.
Maybe this might help?
Itโs okay, thank you @Steve
Best way is to maintain one table named โConfigurationsโ for our Application. This configurations table contains all the enum values that we will be used in Application.
Now for column we can put a valid_if formula and pull the enum values from that configuration table.
Ex: Valid_if : configurations[Priority] - Results Priority column values.
Also we can use Action - โImport a csv fileโ feature to Import Enum values.
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |