Hi,
I am attempting to build an automation that will help assign a student to the specified time slot.
I have 2 tables, 1 of which is for trial arrangement, and another for enrolled students.
Both these tables have the following fields:
Day, Timeslot, Coach, Location.
I have another table for the available slots.
There are 6 records with the exact same Day, Timeslot, Coach, Location. (each timeslot can have up to 6 students (regardless of trial or enrolled))
When a child is about to enroll for example, a button will be pressed, triggering a webhook to integromat/make.com, which will get information of the record.
How can I make integromat/make.com find this slot if it is available, to assign the student to?
I've tried doing a search, but it seems my formula might be incorrect, as it returns with a 0 bundle