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:
Any idea what this is, and how to fix it? Thank you!