Forms - choice eliminator

[KuboS]

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? 

[Sistema_Aotearo]

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...

[KuboS]

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

[Sistema_Aotearo]

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?

[KuboS]

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 ?

[Sistema_Aotearo]

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?