Intro
Thank you for your interest in the Scheduler app! This guide will help you prepare and connect your data to the app. The main purpose of the Scheduler app is to allow for a broad variety of scheduling use cases, as opposed to other offerings in the market which are targeted towards very specific business needs. Follow the steps below to prepare your data for the app and how to set up the app in the Admin set-up section. The app will need to be connected to DataSets output by the Scheduler, as well as the Form Builder app.ExternalAppointments DataSet
The ExternalAppointments DataSet, output by the Scheduler app, is a list of end-users that should be allowed to use the app to book a follow-up appointment using their customer ID. This DataSet is not utilized for initial appointments, but even if a Scheduler only offers initial appointments this DataSet mapping should still be configured. The ExternalAppointments DataSet includes the following column IDs:- customerId
- questionnaireSessionId
- startDateTime
- endDateTime
- serviceId
- serviceName
- locationId
- locationName
- resourceId
- resourceName
MaskedCustomerInfo DataSet
This DataSet is a companion to the ExternalAppointments DataSet and will return the masked first and last name of the customer Id entered into the Scheduler. The MaskedCustomerInfo DataSet is taken from the ExternalAppointments DataSet and then put into a Beast Mode to mask the first and last name, an example of this Beast Mode will be shown below. The MaskedCustomerInfo DataSet should include the following column IDs:- customerId
- firstName
- lastName
firstName, 1), left(REGEXP_REPLACE(firstName,’.’,’*’),LENGTH(firstName)-1))
lastName:
CONCAT(left(lastName, 1), left(REGEXP_REPLACE(lastName,’.’,’*’),LENGTH(lastName)-1))
InviteCodes DataSet
This DataSet maps the invite codes, which allows only invited end-users to schedule their appointments. This applies to initial appointments only and is enabled through the Admin set-up.- inviteCode
Wire Your Data to the App
After the data is ready for the app, you can now deploy the app from the Appstore and connect your data. If you have access to the app asset, deploy the asset from the Asset Library to the desired page in Domo. If the app has been deployed for you with sample data, navigate to the app, click on the wrench icon in the top right corner of the app, and select Edit Card. On the Edit Card screen, that you will get to from one of the two methods explained above, you can re-name the app at the top of the screen. Scroll down below the app and you should see a series of tabs that represent each of the DataSets the app needs in order to run. The first tab EXPORTCOLUMNS will come from your output Form Builder DataSet, be sure to match up all of the correct column IDs from the DataSet. Repeat this same step for the EXPORTFILTERS, EXPORTSFORMS, EXPORTGROUPS, EXPORTITEMS, EXPORTSECTIONS, EXPORTSUBMITTEDUSERS, and EXPORTTAGS tabs, being sure to match up all of the correct columns IDs from the DataSets. The following DataSets will be output from the Scheduler and mapped to the app: ExternalAppointments, MaskedCustomerInfo, and InviteCodes. Each of these should have corresponding tabs in the Edit Card screen, while setting these up be sure to match up all of the correct column IDs from the DataSets. Scroll up to the top and click Save & Finish and your app should now be ready to set up.Embed the Scheduler App
Follow these steps to set up the Scheduler app in embed:-
Create a new Role in the Domo instance called Embed User with only the following three grants enabled:
- Embed Content
- Use AppDB
- View DomoApps
-
Create an account in Domo and assign it to the ‘Embed User’ role.
- Remove grants from this user for everything except for the Scheduler app.
- Log in as the Embed User.
- Enable the Domo Everywhere link on the asset using the Embed User.
Domo Groups and Permissions
A list of groups and the permissions needed will be outlined below. Each of these groups will need to be added to your Domo instance.-
_FB_CreateForms_
- For Form Builder creation access.
-
_FB_CreateTemplate_
- For Form Builder Template creation access.
-
_Scheduler_Admin
- For accessing the Admin section of the Scheduler.
-
_SMS_ADMIN_
- Campaigns Admin.
-
_SMS_USER_
- Campaigns user.
-
Embed User Group
- Add the Embed User to this group, the Embed User is used to create the public embed links.
- Only the Embed User should be in this group.
- Share the Schedulers that need public embed links with this group.