How to bulk add values for Enum field

[alepalmieri]

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!

[Steve · Accepted solution]

Create a separate table prepopulated with the countries. Use Valid If or Suggested values to generate the dropdown from the values in that table.

[alepalmieri]

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!

[Steve]

Why is the Base type set to Ref? Should probably be Text.

[finkployd]

Hi sir, may I know the working steps for this? I just wanna add my Enum fields in bulk. Tq

[SkrOYC]

Drop-down from Valid_If - AppSheet Help
Configure suggested values for a column - AppSheet Help

[finkployd]

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?

[finkployd]

What am I doing wrong here?

[alepalmieri]

You are right, it works now. Thank you so much for your help!

[SkrOYC]

---

@finkployd wrote:

error

---

Nah, just a warning

[SkrOYC]

---

@finkployd wrote:

What am I doing wrong here?

---

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