I want to limit the number of entries in a drop down option.
For example a column[Fruits] have an values of "Apple", "Orange" but once the "Apple" has reached 10 entries or form submission, the dropdown doesnt show or invalid the option "Apple" but the "Orange" is still available.
Please help me with this, I been stuck figuring out for days. Thank you
Check form input validity (Valid_If) - AppSheet Help
COUNT(SELECT(Table[ID], [Fruit] = [_THIS])) <= 10
This works but what if Orange have a limit of 15? Sorry i didnt add that in the question.
Replace 10
with an expression that returns the appropriate number. That could be a reference to look up the value in another table, or it could be hardcode like the following example:
SWITCH([_THIS], "Apple", 10, "Orange", 15, 20)
User | Count |
---|---|
37 | |
31 | |
28 | |
22 | |
18 |