Hi everyone !
I’m trying to build a tool to book classes between 1 student and 1 teacher.
each student fills a form to say which day of the week he / she is available.
the teacher does the same.
I then generate a record for each class and assign a student first.
once I have done that, via a lookup field, I am able to pull down the list of all the teachers that have the same day of availability.
I then link a “chosen teacher” field with one name that is in the list.
the teacher I have chosen might not be available every same day as the student.
is there a formula, or another table logic that I can use to tell me which days work for both the student and the teacher. That means comparing a list in two fields and pulling out the items in common ?
and because a base is worth a thousand word. here is a demo of what I mean
Thank you in advance for your tips !