Hi All,
I’m working on an app that lets businesses manage their own individual calendars (Full Calendar). Customers can also go on the app and schedule appointments with these businesses based on real-time availability.
I’m trying to show only available time slots to customers, but I end up showing all time slots .
First I have a RG that shows search results of businesses (users). Then within this I have a RG to show the time slots each has available.
Here are the previous threads I used to get to this point - they focus on creating time slot #s and corresponding times as text.
I feel like I’m 85% of the way there, I just can’t figure out what I’m doing wrong! Agh!
-
I have a data type Time Slot with 2 fields, Time Slot # (number) and time (text). I used 15 minute increments. 1 has a time of 12:00 am, 2 has a time of 12:15 am, etc.
-
I have a data type Appointment. This has a Time Slots Taken field (list, number). When someone books an appointment the time slots this takes up save to the Appointment. For ex. an appointment from 12:00 am - 12:15 am would save 1 in Time Slots Taken field. No connection to a specific date yet.
-
In Appointment, I decided to try creating a Text Date field. When someone schedules an appointment, I have an input element that is not visible, that reads the date (date) and displays it as text, formatted as a date (ex. 4/25/18). This text version of the date is saved in the Text Date field in every Appointment.
-
Each provider has a “master email” (separate field (text) from their user email) that saves in every Appointment to link it back to the business.
-
On the customer’s search results page there is again a hidden element that reads a date (date) and displays as text formatted as date (ex. 4/25/18).
This is what I have in the time slots RG:
In the Time Slots RG I created a text box to show the Time field associated with each Time Slot # from the Time Slot data type.
What am I missing? I also tried to do the Time Slot # as text instead of number and tried to use the <, > etc signs but this didn’t work either.
Thanks in advance!