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:
Any idea what this is, and how to fix it? Thank you!
Solved! Go to 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.
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |