I am creating a form in my app and I am collecting information like country. I would like my user to have a dropdown with the list of countries. Is there a way to bulk add them? It would take me ages to add 196 countries one by one. Thank you!
Create a separate table prepopulated with the countries. Use Valid If or Suggested values to generate the dropdown from the values in that table.
1 Like
Thanks, Steve! This worked well for the Enum type.
I also looked into a work-around for EnumList and found the following:
- Type: EnumList
- Base type: Ref
- Reference table name: {table with validation values}
- Item separator: “,”
- Suggested validation: Table_name[Column_name]
This process works but I get warning signs ( 
) in the dropdown UI.
Why do I get them and how can I remove them?
Thank you!
You are right, it works now. Thank you so much for your help!
1 Like
Hi sir, may I know the working steps for this? I just wanna add my Enum fields in bulk. Tq
1 Like
Hi sir, I used this formula: SORT(Glossary[ERS Category])
and gave me the error: Column Name ‘Category’ in Schema ‘ERS Inventory_Schema’ of Column Type ‘Enum’ should have a list of allowed values or allow the user to add other values
But i Dont want the field to allow other values. How do I fix this?
Nah, just a warning
1 Like
Nothing. As long as the values inside of the list are of the same type of the ones you want in your enum, it works
1 Like