Is there anyway to only select items ONCE?
I have a single select field type with A, B, C and D, if I pick B on a row, I only want to be able to select A, C and D afterwards.
When I select an item in a single select list, I want it to be not available anymore.
IE: I’m going away with my entire company, I want to dispatch people in hotel rooms. If I select the Room42 for John, when selecting Kim’s room afterwards, I do not want Room42 to be available in my single select list.
Not exactly what you need, but you can put the single select list in a separate table and link them rather than having them in a drop-down in the same table.
Put your Room list in a separate table, then on the form the user will select which room they want. Room 42 will still be on the list of options to choose, but John’s name will be listed right there so they can see it’s already reserved.
Haven’t explored if you can use a filter to only display the options that are empty, i.e. have not been linked to another record, but maybe that could be the next step.