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 254
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