I have been adding many tables from a Google sheet. Many of them have columns with dropdown values. Appsheet recognized these fields as enum type and added all values automatically.
I have just created a new table/tab in my Google sheet with many columns with dropdown values but Appsheet sees them as text fields and do not import the values.
What could have missed to break the import of dropdown/enum values?
I guess I am lazy and do not want to enter all these values manually. ๐
I'm only guessing (I've never faced this particular issue) but I wonder if checking to make sure that every cell in each column is formatted in the same way (same dropdown values) before import might not fix the issue. I might be that AppSheet doesn't know how to handle situations where cells toward the bottom of your sheet are formatted differently.
Hey @Kirk_Masden,
Thanks for the idea. Unfortunately, it does not seem to be the issue.
Values are already the same as shown here in the dropdown definition.
Here an example where it works even when the dropdown definition does not go all the way down.
Sorry I couldn't help. I hope someone else has a good idea.
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |