Having issue while Creating Dropdown

Hi Everyone,

I’m new to AppSheet trying to learn and create. I’m having difficulty for after saving each time system keep changing to default value.

Error Message : “Column Name ‘Vendor 1’ in Schema ‘SunSet Deli_Schema’ of Column Type ‘Enum’ should have a list of allowed values or allow the user to add other values.”

While configuring the setting for ENUM type details section keep changing back to base type to “Text” and auto selecting “Allow other value” and “Auto complete other values”

Also attached the screenshot along with error message.


Thank you for help in advance.

0 3 250
3 REPLIES 3

An ENUM column shall have a base type. Provided you do not explicitly specify a base type, during save, AppSheet Editor defaults it to base type of text, that’s a normal behavior.

Regarding the ENUM values;

  • Provided you are not hardcoding those values thru the ADD button but specifying them thru a Valid_If expression, then you need to set the Allow other values parameter to TRUE.
  • Provided you are using Suggested Values property with Input mode as Dropdown then you need to set the Auto-complete other values parameter to TRUE because with Suggested Values, you give the user a flexibility of adding missing items to the dropdown

These are all normal behaviors, not a bug in the system.

I have a similar issue (but with ENUM LIST) using the 2nd option of suggested values. I am doing exactly as you suggested but still can't add custom values

Please start a new topic for help with this.

Top Labels in this Space