Hello to everyone. This is a very easy question but i am entering into a stupid loop. I would like to filter the possible values of a ref field when i selecting it from a input form.
In particular i want that if a value is been already used in other rows , it don't have to appare on the dropdown list on the screen. I am thinking to use the "suggested values" tab on the "auto compute" data form. How can i do it?
Thank you to everyone
Drop-down from Valid_If - AppSheet Help
Subtract values from a list - AppSheet Help
For example:
(expression returning master list) // All the values
- ThisTable[ThisColumn] // Subtract all the values already selected
+ [_THISROW].[ThisColumn] // Add back in the current row's saved value
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |