I’m trying to design a calendar & job scheduling functionality into our existing airtable base. Our small company currently uses google calendar to schedule customer installations. I’m not clear on how to set up the functionality we need and hope maybe someone here can steer me in the right direction. Or show me a base that does what I’m looking to do.
We have a base with contracts that include a variety of related information, with the unique customer contact information in a related table: Customers and Work Orders
When we schedule a work order for installation, there are 3 possibilities:
Scheduled for a single day; job is completed same day
Scheduled for multiple consecutive days; example: Start work Monday, finish Wednesday - 3 day installation
Scheduled for multiple non-consecutive days: Start work Monday, work Tuesday, return to finish following Wednesday.
#3 is the scenario where I’m stumped. Each work order is a single record, so a Start Date and an End Date does not account for scenario 3 or variations of multiple disparate days.
I have considered maybe a related table that creates a record for each installation date, but I’m unclear on how that would work on the calendar side.
Any suggestions or directions would be incredibly helpful! Thanks in advance,