Enum list choices disappearing

[Hank_Austin]

My original app had several choices in enum dropdowns. Over time I added more choices however the new ones keep disappearing. Thoughts?

Thanks,

Hank

[Steve]

How dd you add the new choices? Do you have a Valid If column constraint that might be affecting the displayed values?

[Hank_Austin]

Hi Steve,

I added them through the column editor. No If statement.

Thanks for you assist!

Hank

[Steve]

Where are the values disappearing from? From the value list in the column editor? From the drop-down menu the app user sees? From the spreadsheet?

[Hank_Austin]

Hi Steve,

I know they are going from the dropdown but I will need to check the others a bit later. I will post what I find.

Thanks!

Hank

[Hank_Austin]

Steve,

They are gone from the value list and the drop down menu.

[Steve]

Are you using a spreadsheet as your backend? If so, does the spreadsheet column have data validation rules applied to it?

help.appsheet.com

Dropdown from Worksheet Data Validation Rules

How to create a dropdown from data validation rules that you have in your worksheet.

[Hank_Austin]

Yes Google sheets. No, no rules. What is interesting is that the drop down choices will be there for several days then disappear. I cannot align this with any occurrence.

[Steve]

That’s very odd, and beyond my ability to troubleshoot, I think. I recommend you reach out to support@appsheet.com directly for assistance.

[Hank_Austin]

The other thing is that the original items stay and the new ones disappear.

[Steve]

Yeah, I’m at a complete loss on this one. When you work it out, please update us here on the fix.

[Hank_Austin]

Thanks

[soldesk]

I am having a similar issue, where only on value from the spreadsheet column is displayed. There should be 6 values. I am using the valid if function to validate instead of manually adding the values. I can not find any literature on this anywhere. I'd appreciate an update in this issue or some assistance. Thanks.

[soldesk]

OK, I seemed to solve my problem.  My enum values were coming from the spreadsheet using the validate if function. The table where those values resided had one of those columns set as the key. In this case the key needed to be the row number.