If I’m reading your description correctly, the view shared with security only shows the newly-linked records from the second table. If that’s correct, it sounds like what you need is a view that’s the opposite of the one that you’re sharing with security, only displaying the homerooms that are not linked.
With that view created, you can set the form to only allow records to be selected from that new view. Read more about this here:
That would give you a shrinking list to choose from as you select more homerooms.
FWIW, you don’t need a form to do this. You can set this up directly in a grid view. Submitting and refreshing the form feels like overkill for a situation like this.
Thanks I will look into it.
If I’m reading your description correctly, the view shared with security only shows the newly-linked records from the second table. If that’s correct, it sounds like what you need is a view that’s the opposite of the one that you’re sharing with security, only displaying the homerooms that are not linked.
With that view created, you can set the form to only allow records to be selected from that new view. Read more about this here:
That would give you a shrinking list to choose from as you select more homerooms.
FWIW, you don’t need a form to do this. You can set this up directly in a grid view. Submitting and refreshing the form feels like overkill for a situation like this.
The reason why I need a form is because I want my teachers to be the one when walking out to select their homeroom but i don’t want to give access to the air table database directly.
The reason why I need a form is because I want my teachers to be the one when walking out to select their homeroom but i don’t want to give access to the air table database directly.
Thanks for the clarification. In that case, the form behavior will work. When the teacher submits the form, their homeroom will appear on the list for security, and won’t appear on the list when other teachers open the same form.
Note that if a teacher leaves the form open for a while before using it, the list that they see will still include homerooms for teachers who have already submitted. The form view isn’t a live look at the data, so that view-based filter will only be based on submissions that took place up to the time that the form was opened, but not after that. In that light, I suggest pointing this out to the teachers, and encouraging them to wait to open the form until they’re ready to submit for dismissal.
