Explore

Processes and workflow design

Course Material

⁠

Workflow-Logic.pdf

3 MB

⁠

🟢 Level 1 ( Warming up)

Model the process workflow for a country that sells pears and apples to other countries.

Orders are received via email.

The information about available stocks is stored in a spreadsheet.

The invoice is sent via email.

Pay attention to :

The start event

The tasks

The Gateway(s)

🟠 Level 2 Hotel Chain workflow logic

💪 Core

1️⃣ Design, represent ( using Whimsical or any other tool), and implement a workflow that allows you to automatically create bookings:

Receive a booking request via Slack or Email,

Verify a room’s availability,

Book a room

Send a relevant email to the client who requested the booking.

If the requested room is unavailable, an email will be sent suggesting the client book another room or on another date.

If the booking has been successfully created, send the booking details, including room, services, staff, individual items, and total price, and the payment’s due date.

Send a Slack message to the team if any necessary information is missing about the client or the booking.

⚠️ To simplify, the rooms can only be booked daily and not on an hourly basis.

2️⃣ Design ( using Whimsical or any other tool) and implement a workflow that allows you to monitor the prices of competitors at your different locations.

The prices are posted on a website every day.

Your system calculates the variation percentage relative to the previous day.

All the relevant prices are adjusted accordingly at your locations.

To simplify, only 3 locations are reported on the page and prices are updated every time you open the page. You can start with one location and one space type for more efficiency.

Page url :

Event Spaces Pricing Monitor⁠

⁠

🎉 Bonus

1️⃣ Design, represent ( using Whimsical or any other tool) and implement workflows to centralize the data from the different sources in the Airtable base you created. ⚠️ Data contained in these sources may require you to change your database structure

2️⃣ Create a workflow and/or make the database optimisations that :

Bonus Workflow 1: Allow you to automatically reply to frequently asked questions sent via Slack or Email. The request must be routed to the relevant workflow :

Booking

FAQ if FAQ

Slack if the request is received via email and the answer is unknown.

Bonus Workflow 2: Allow you to assign staff members to events and check their availability based on Email or Slack requests. If a booking contains a service requiring the presence of a specific type of staff member and they’re not available, the booking can’t be finalized.

Bonus Workflow 3: Allow you to manage support material, both disposable and durable.

Report any damages to support material and indicate whether repairs OR replacements are needed.

Notify the team via a Slack message every time the stock of eco-friendly tableware runs low at any location.

Bonus Workflow 4: Allow you to request positive testimony from former clients in exchange for a 20% discount Code. Every time a client sends a positive testimony via email or a form, they receive a discount code via email. For their next booking of any room, they will benefit from a 20% discount on the total price. If the booking is part of a multi-location or multi-room event, the discount will be applied to that individual room booking only.

Bonus Workflow 5: Create or manage multi-room and/or multi-location events: when a multi-room or multi-location email is canceled, all the related bookings are canceled, and only one recap email is sent to the client for all cancellations. You must be able to view all the bookings related to an event in a calendar view, no matter the location.

Bonus Workflow 6: Generate a ticket based on event information with a scannable QR Code that updates the attendance status of guests of a specific event. ⚠️ To simplify, you do not need to check the attendance for each booking, but only for the whole event.

All done? Submit your assignment! 👇

Share the link to your Google Doc containing all the Loom videos showing your end-to-end workflows, as well as Make scenario links, screenshots, and an email to test them.

⁠

Want to print your doc?
This is not the way.

Try clicking the ··· in the right corner or using a keyboard shortcut (

CtrlP

) instead.