[Tips] Let Users setup their daily availabilities

Hey guys

It seems like quite a few of us are wondering how to let Users setup their daily availabilities. This is useful if your app involves appointment scheduling or business opening/closing hours for example.

I wasn’t sure if there was a similar topic out there so here is a demo of how I got it to work:
Demo: https://calendar-schedule.bubbleapps.io/version-test/create-user?debug_mode=true
Editor: https://bubble.io/page?type=page&name=create-user&id=calendar-schedule&tab=tabs-1

A few things to keep in mind:

  • This demo is not on a paid plan therefore the loading time when ‘Start’ is clicked is very long. You can make this seamless by creating the availabilities in an API workflow instead
  • This is certainly not the only way to do it, so if anyone has suggestions to make it better please feel free to share

Here are a few extra guidelines:

  1. You need to create a data type Availabilities with the following fields:
  • Available (of type yes/no)
  • Day (of type text)
  • DayNumber (of type number)
  • OpeningHour (of type date)
  • ClosingHour (of type date)
  1. Add a field Availabilities (list of Availabilities ) to your User data type
  2. When User is created, create 7 new Availabilities (one for each day) and add them to User’s Availabilities
  • Day: Sunday; Monday; Tuesday and so on
  • DayNumber: 0; 1; 2; 3; 4; 5; 6 (Sunday = 0; Monday = 1, Tuesday= 2 and so on)
  1. To let the User define his availabilities, create a RG (7 rows, 1 column) and set the data source to Current User’s Availabilities . Each row is one day. Include the following elements in the first cell, from left to right:
  • 1 checkbox (set to Dynamic: Current cell’s Availabilities’ Available )
  • 1 text (set to Current cell’s Day )
  • 2 date/time pickers, one for the OpeningHour and the other for the ClosingHour - I recommend using this plugin by @seanhoots
  1. Create following workflows:
  • When checkbox’s value is changed and checkbox is checked > Make changes to Current cell’s Availabilities: Available = yes
  • In the same way, when checkbox’s value is changed and checkbox is unchecked > Make changes to Current cell’s Availabilities: Available = no
  • When AirDate/TimePicker A’s value is changed > Make changes to Current cell’s Availabilities: OpeningHour = This AirDate/TimePicker’s value
  • In the same way, when AirDate/TimePicker B’s value is changed > Make changes to Current cell’s Availabilities: ClosingHour = This AirDate/TimePicker’s value

Hope this helps and happy to answer any questions you might have

28 Likes

Thank you!

When the availability is changed, does it automatically update the data (so no need for a ‘‘Save’’ button for changes)?

Thanks again :slight_smile:

Yes that’s right @mauraduquette

Awesome! Thanks again :slight_smile:

Hey @ambroisedlg, thanks for the post! I’m doing what you’re using temporarily, but it seems a bit problematic when it gets to 12am of the next day.

@Boost what is the problem exactly?

How would you set up the end time, if it overlaps at 12am of the next day?

@Boost do you mean if the User is available from say monday 8pm to tuesday 2am for example? That’s a good point. With that current configuration the User would have to pick 11:59pm for monday’s closing hour and tuesday 12:00am for tuesday’s opening hour so there is no interruption on his calendar

Just curious @ambroisedlg, how would you set it up if someone wanted to create multiple chunks of time within a day? (So that users can take breaks)

For ex. Monday 8am-11am, 1pm-5pm, etc

Edit: I guess that part would be easy, the hard part is allowing users to book out certain chunks of time, while taking that out of the available times.

I tried using the plugin you recommended, but from I remember, there were some limitations on date ranges and filtering out times, since it only had a minimum and maximum date

2 Likes

@Boost One way to do it is to create an Event from 11am to 1pm for example. In the user’s calendar, do a search for Events overlapping with the timeslot. If the count >0, make the time slot not clickable, therefore not bookable

3 Likes

@ambroisedlg thanks for this tip! Works really well and a simple way to handle availability. You rock!

1 Like

Hi!

I am currently building the same thing. I was wondering how can I create multiple chunks of time within a day ? Thank you :slight_smile:

Define the start time and end time of the day, or of each day if the week (opening hours) then setup a backend workflow to split your day’s hours in time slots. You can also add the timeslots duration as a parameter of the workflow (15 min, 30 min, 1 hour,…)

1 Like

Perfect! And do you know how can I display it on the app so the user can select different times? When the user clicks on ADD I would like a new line to appear to select different hours within the same day! Thank you. Messages Image(203513258)|537x500

Hi @Christophe_HK - would you be able to explain how to set up the backend workflow to split the days into timeslots? Thank you

@ambroisedlg love this mate. Is there a way when the user has selected the times to have that repeat every week?

@pattokane glad it helps!

With the demo above, availabilities are set for the user for all Mondays, Tuesdays etc so these should already repeat week after week

Hope this helps!
Ambroise

Ok, I must be doing something wrong when trying to view it in a calendar then. I’ll keep fiddling around with it, cheers man

1 Like

Ok, I am lost. It does not seem to work for me LOL