If it’s a production grade app, then I’d design this from the user’s POV and think through what will work best for them. Bubble can get this done in a whole variety of ways so it shouldn’t be all that limiting. If it’s just a prototype, then perhaps go with whichever approach is easiest to build in Bubble.
If production grade, then I’d consider:
- Displaying the visuals as a box or shape that had a condition that changes the background color (and perhaps border, etc.). You could enable the user to click the box and have it trigger a workflow that toggles a custom state between yes/no to turn background color on/off for each 1 hour time slot.
- I’d keep the database simple to make it easier to query later. You likely want a User Availability Table, a Staff Availability Table, and perhaps a Pending Requests Table. These tables could be simpl e like this:1) day of week, 2) time of day, 3) isAvailable
- Displaying matches in repeating groups likely works. They key here is to try to structure the RG data source queries so that it doesn’t need a search within a search (or else it’ll start to get quite slow).
I’d go a much quicker/easier route if it’s just a prototype or MVP. Can always add more later.
Hope this helps.