Hi, everyone! It's my first post, and I'm relatively new to Airtable and to databases more broadly. Hoping for some help.
I'm using a base to organize staff for a conference. Volunteers are attending some sessions and working other sessions. I have a field for each volunteer's Attendance Time Slots, another field for Work Time Slots, and a third field called Conflict?. There are several (up to five) time slots listed in the Attendance column and in the Work column. I'd like to check to see if ANY one or more of the time slots in the Attendance column matches ANY one or more of the time slots in the corresponding Work column for that volunteer. If so, then I'd like the output in the Conflict? field to be "YES" (otherwise, "no").
In other words, I need the Conflict column to alert us if we've assigned a volunteer to work during a time when that volunteer is signed up to attend another session, so no one is double-booked. Can anyone help me accomplish this?
Thanks in advance! And remember, I'm very new. So, super-clear, extra explicit instructions would be most appreciated. Thanks again, and please wish me luck! 🙂
