Help

Creating a quantity that reflects how many times it's been selected

554 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Juliana_Goode
4 - Data Explorer
4 - Data Explorer

I’ll try to describe this as best as I can- I have a table set up for signage requests our staff can make for our event. One field asks the size. Since we have specific sign holders in house I want this field to reflect our inventory of sizes. So if someone selects 1 of 5 sign holders that is 22" x 28", can I make it so only 4 more records can choose that size after?
Is this or something similar possible?

1 Reply 1

Hi,

make such limited-resource items be chosen as miltilinks, put field ‘available’ as formula, = quantity - count(links),
make view, where available >0 and limit record selection by it