EnumList not displaying data

AppSheet AppSheet Q&A
,
1

I have a simple EnumList but the data isn’t appearing.

Here is the field information below:

  • I have no validations and no suggested expressions in place to affect the ref values.
  • When I switch it to a simple Enum it displays the data as expected.
  • The table has Add/Update capability
  • I have the same field in another table as an EnumList and it displays just fine.
  • I’ve regenerated the table several times
  • Logged out and back in

What could I be missing? Thanks everyone

Daisy_Ramirez_1-1650071641485.png
Daisy_Ramirez_1-1650071641485.png568×954 18.3 KB

Daisy_Ramirez_0-1650071607013.png
Daisy_Ramirez_0-1650071607013.png1169×1776 112 KB

2

Please try again by refreshing the browser page itself, i am facing almost the same situation since yesterday.

i hope it works

3

Thanks Hani but no luck still an issue. Have you reported it to support already?

4

Unfortunately, i didn’t. i think they might be doing updates or changes. i really hope you did find a way from this situation

5

You have to pass expression (which returns list) to Valid If field. (or suggested values)

3 Likes
6

Hello, I don’t believe an EnumList required a ValidIf statement. I have an EnumList in other tables and those did not require a validif statement. Will standby. I have submitted this into support but no response as of yet

7

Enumlist/Enum with base type ref needs either valid if or suggested values. If you turn on "auto complete other value, while you have the existing data value on that column, then you willl see the dropdown based on exising values.

3 Likes
8

This is not an ISSUE, like @Koichi_Tsuji said, in ENUMLIST Ref type you need to provide a VALID IF expression of LIST TYPE, For example: MEALS[ID]

1 Like
9

Ok but here is the other EnumList on another table and it currently does not have a ValidIf in place but displays the information from the Ref table. I’ve used EnumLists many times and have never had to insert a ValidIf. What could be the difference in these 2 scenarios?

Daisy_Ramirez_1-1650373986121.png
Daisy_Ramirez_1-1650373986121.png1178×1794 114 KB

Daisy_Ramirez_0-1650373902513.png
Daisy_Ramirez_0-1650373902513.png564×982 50.6 KB

10

Probably because you have the “auto-complete other values” option turned on, so it is displaying what is already in that column in other records.

You always have to set a valid_if for Enum(List) base Ref. This has been the case for years. I suspect you’ve just got lucky on previous occasions because you already had data in the table. It’s possible that you may have not been displaying all possible options in previous cases this whole time, I’d highly suggest going back and reviewing them.

5 Likes
11

This photos correspond to different columns, not the same, first one is refered to CLIENTS, and the second shows MEALS :thinking:

12

Totally agree

1 Like
13

Sorry wrong image but understood, I will use a validif with all ENUMLIST’s

1 Like