I’m looking for some help and guidance in regards to matching dates and then providing relevant emails that are associated with it.
Here’s the situation:
- A user fills out a form on my website that lists dates and times that they are available (up to 7 dates) I have it zapped into a table.
- In the backend, I’m manually finding events and uploading it to a different table in the same base. I outline information such as the link to the event, and the date/time it starts.
As soon as I put the start date of the event, I want it so that the email of the user that says their available during that time to show up and match, or some sort of organization system that gives me the people that are available for that event at that time.
Is there a way to do this? Should I create another table? I added two screenshots for reference. This would be so helpful - thank you.
One thing to keep in mind is that there are 7 dates that a user can select, so it would have to scan all of the dates!