Calendar Views based on two separate Date/Time fields (like Airtable)
Jon Darbyshire
Great to hear your perspective, Dave Hyndman! I have a few more questions for you:
- What specific challenges are you facing with the current Date Range field setup?
- How do you envision the interaction between the two separate Date/Time fields in the Calendar View?
- Are there any specific use cases or scenarios where this feature would be particularly beneficial?
D
Dave Hyndman
Hi Jon Darbyshire.
I own a tour company on the East coast of Canada. I'm in the process of moving my company "operating system" from Airtable to Smartsuite.
We deliver approx. 1000 tours/summer. We manage each one as a record in our "Tour Schedule" table. Each tour is based on a "Product" with a set duration. We set the "Tour Start Time" manually (or via import) using a Date/Time field. We then add Duration (via a Lookup) in a Formula field to set Tour End Time.
Date Range doesn't work:
- no ability to import into Date Range field; we start each season by importing about 500 tours from a spreadsheet
- clumsy data entry to set Start Date, Start Time, End Date, End Time
- no ability to achieve Date Ranges formulaically; but I can create Date/Time fields with formulas (that's how I create my End Date/Times):
[Tour End] = DATEADD([Tour Departure],NUMBER([Tour Duration (from SKUs)]),"minutes")
To have a working calendar view (like your personal Google Calendar), the calendar should show each event reflecting its start, duration and end. Using a date/time field Smartsuite only positions events properly based on their start, but the calendar has no sense of duration/end.
See attached screenshots comparing same day in Airtable and Smartsuite.