Set Marketplace Seller schedule/Hours of operation

Hey @gokulmadan2

  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

Your User can therefore define the days they are available by checking the checkbox, and set the opening and closing hours for those days. You can also have a condition to hide the date/time pickers when Current cell’s Availabilities’ Available = no

Hope that helps!

3 Likes