We need a 'Conditional Select' type field to add to forms. This type of single select and multi select question would conditionally disable and 'grey-out' specific options in select questions on forms. It doesn't seem currently possible to do this. There would be many use cases for this. My particular one is that I have a form for view only users to update certain fields in a database for a not for profit or charity music school recording students and musical instruments loaned to them. We need to prevent students resigning but not handing instruments back. The first single select question on the form is "What do you want to do?" which hides/shows various fields on the same form. One of the options is to resign a student. If that student is still holding an instrument, (ie. {instrument ID} is not blank) It should not be selectable, but should still be visible, greyed out so that the user can see they are in the right place and its clear they cannot select that option. An important feature of the proposed conditional select field would be the option to include a warning message when the disabled option is clicked or hovered over, which should allow the inclusion of variables from the source field causing the restriction. ie. in my use case, I would want to say, "{First name} cannot be resigned at this time because records show they are still holding the instrument {Instrument ID}. I think this feature would be of great benefit to a lot of Airtable users.
... View more