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?
