Oct 29, 2023 10:30 AM
It is not about Formulas, but Form was not an option for a label.
I need to put a form, where I let people to pick a product. I want to create a dropdown menu to select product.
After submitting I need to remove that product from options.
So there is only one product for each who submitted.
Plus ! Because it is obvious !
When they change their mind I advice them to file new form with remaining choices and just remove their first form entry.
But cant avoid the manula data editing upon request so each time a new form si filed it takes the actual data from the sheet in airtable options.
Please can you help me with that?
Oct 29, 2023 05:22 PM
Hi and welcome!
This can be done with a "Link to another record" type field instead of a Single/Multi Select type field.
You'll have to create each product as its own record on a separate table. From there you can create a view that filters out records that have been linked. Then "limit the record selection to a view" from the form.
There are a few library systems on the Airtable Universe that might be useful to play around with.
Here's one: https://www.airtable.com/universe/expTVMUneqdQQrtTF/checkmeout-a-libraryresource-checkoutcheckin-sys...
Oct 30, 2023 04:38 AM
Probelm is I run to your link I coppied base ... but than " cant figure where are the automations or submission form or filter vew to use it in my table/base
Oct 31, 2023 05:41 PM
Hi hi,
Just did a test base to see if I could do what you're looking for.
https://www.airtable.com/universe/expgj9DNrH0vPkp5U/for-kubos
You'll have to manually remove the responses when you want to make an option available again. Or you could make yet another table with return information and match those up haha
Is this what you're looking for?
Nov 01, 2023 01:34 PM
Ok I have that "Show if field is empty" - choice elimination show only empty fields - ok that works, thx.
Can I have one more question?
Table 1 (Attendee A,B,C,D,E,.....Z)
A - room1
B - room1 (Lin to view - free spot)
C - ? Where is free spot
Table 2
Room1 capacity-3, attendees A B, freespot (Formula Capacity - (Count attendees <A,B> 2)) = 1
Table 1
In selection for attendee C, I still see Room1 as available. Not fully booked.
Can you help me how to cound Non value entries in one cell ?
Nov 01, 2023 03:36 PM - edited Nov 01, 2023 03:36 PM
I've just updated the base I uploaded.
I created a few new fields where you can input capacity as well as a count field, and a couple of formulas to calculate whether the rooms are FULL and how many spaces are left.
https://www.airtable.com/universe/expgj9DNrH0vPkp5U/for-kubos
Is this what you're looking for?