What Airtable functions can I use to create fields that allow you to select from a list of records, but only allow you to select records that haven’t been selected by other fields on the same Table?
Use: I am a meeting planner. I would like to input the names of meeting rooms that are available. I would like to be able to assign a meeting room to a record. In order to not double-book a meeting room, I would only like rooms that have not already been selected (booked) to be selectable options within a record.
My initial thinking is that I would create a Table, wherein each meeting room has its own record and that those records are referenced from another table as selectable. Perhaps a second table and links are not appropriate and it is better to create some sort of single select or multi select fields. I should mention that ideally, a single record would be able to select multiple rooms, since some of our rooms can be physically joined to create larger rooms. For example:
If Record = Meeting 1, can it have an option to Room A or both Room A and B?
If Record 2 = Meeting 2, can it have the option to select Room C, but not A or B, because those were previously selected by Meeting 1?