How to limit the number of entries of each options in a drop down?

AppSheet AppSheet Q&A
1

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

2

Check form input validity (Valid_If) - AppSheet Help

[COUNT](AppSheet function list - AppSheet Help

[SELECT](AppSheet function list - AppSheet Help

COUNT(SELECT(Table[ID], [Fruit] = [_THIS])) <= 10
3

This works but what if Orange have a limit of 15? Sorry i didnt add that in the question.

4

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](https://support.google.com/appsheet/table/10104782?hl=en#query=switch)([_THIS], "Apple", 10, "Orange", 15, 20)
1 Like