Prevent Overlapping Room Booking Dates in AppSheet. PRO Development. Loops and Bots.
Become a member of this channel to enjoy exclusive benefits:
/ @fabiopalacios
00:00 Demo of the created app
01:11 Creating the structure in Google Sheets
06:49 Linking with AppSheet
08:01 Adding tables, adjusting columns, adding virtual columns
19:50 Creating a Calendar view
21:50 Recording information
26:00 Creating 4 actions that will enable the necessary loop Recursive Actions
34:44 Creating BOT1 to trigger action 1
38:36 Testing automatic record generation with recursive actions
43:05 Creating BOT2
48:00 Adjusting data validity in the Reservation_Start_Date column
51:09 Adjusting data validity in the Reservation_End_Date column
58:42 Creating a second calendar view of type Ref from the Generator table
59:55 Creating an action with a deep link, linktofilteredview
1:00:06 Final tests