Fixing Yellow Exclamation points for Enum/Refs

Hello!

I am working on an application with multiple dropdowns that are pulled from a large table, with different items pulled from different sections of the table via a slice.

For instance, I have a state dropdown. The table I am pulling from has a rows like this:
ID | CATEGORY | KEY| VALUE (this row is the header)
|<General | State | Alabama>|General|State|Alabama|
|<General | State | Alaska>|General|State|Alaska|

Where the ID column is the key, as those will be unique

So, I create a slice, called GeneralState. It chooses from this table as the Source Table, and the row filter condition is: AND([CATEGORY] = โ€œGeneralโ€,[KEY] = โ€œStateโ€). I choose all columns, make it read only.

In my table, I make column type Enum, base type Ref, set the Referenced Table Name to GeneralState, set Data Validity Valid If: GeneralStates[VALUE]

When I see the preview of the app, there are yellow exclamation points, however: 2X_a_a5287bc6472022ed86c32b309351470e48748575.jpeg

Any idea what this is, and how to fix it? Thank you!

Solved Solved
0 11 3,077
1 ACCEPTED SOLUTION

This should be:

GeneralStates[ID]

A ref type column holds key-column values, though if you have [Value] set as the label-column, then youโ€™ll still see the state name in the app.

View solution in original post

11 REPLIES 11
Top Labels in this Space