Skip to main content

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

  • September 15, 2022
  • 1 reply
  • 8 views

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

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1261 replies
  • September 16, 2022

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