Creating a Timeline with Computed Calendar Data

I work for a photography company so all of my order data is imported from the photographers calendar, it then needs to be edited by our production team. I bring in the data manually from our calendar program as a .csv each day. I am trying to create a calendar for each of our retouchers so they are not overloaded.

I have created a new table with each of our products and an estimate for editing time. The issue is the calendar doesn’t like computed dates. As I am using the photographers calendar the date is from yesterday and also the end time is for the photo shoot, therefore will be longer than editing time. I currently have the “date created” field (batch import same time each day), then a field for “local time zone”, a lookup field for “editing time” and a DATEADD calculation to get the “end time”.

My question is, how do I then show these on a calendar or timeline so I can visually see when someones day is full. Ideally they would be stacked in the order they are listed under each retoucher in my grid view.

If not able to do it visually, is it possible to have it calculate a completion time, based on how many orders are in the queue for each retoucher above it?

Thanks so much for any insights :sunny:

EDIT: I have manually made a date field and can paste the date over to my other fields very quickly each day, this means I can move things around in the calendar view very easily. The issue is just not being able to adjust the appointment duration time.

EDIT: I have tried to do the calculations in ‘numbers’ on a mac but when I copy and paste into airtable, it leaves the computed date cells blank.

My guess is that there’s an issue with your DATEADD formula. I’ve got a calendar for one of my side jobs that is almost nothing but calculated dates—it’s an 11-week course that I teach, and all class dates are calculated based on a single start date for the term—and they all appear without any issues. Could you please share the formula you’re using, and any relevant details about the data being used in the formula, including the data types of referenced fields?

If your base is in a free Airtable workspace, durations can’t be set in a calendar view. That’s a Pro plan feature. However, if you’re in a Pro plan workspace and are still having duration issues, I’m guessing it’s in the formula I asked about above.

Thanks for your response, I really appreciate it.

To be clear, the calendar does show the calculated end time, but I’m unable to drag and drop the records to rearrange the order and change the start/end times that way. I was hoping to find a way to import each record with the same start time, and calculated end time, and manually arrange them in the calendar to figure out an order as I understand airtable is unable to calculate based on the end time of the record above it.

I have a pro plan at the moment.

As a compromise I’m thinking I’ll just calculate the total number of hours in duration for each editor and highlight it when over a max hours for each person depending on their schedule. Calendar would have been ideal as I can give client a predicted time of completion.

That’s because the end time is driven by a formula. Formula fields don’t create data that can be manually edited. The end result is always driven by the formula. The only way to change the output is to change the data driving the formula’s calculation(s). If you want a calendar entry that you can drag around, you’ll either need to copy the calculated end time into a regular date field, or use a third-party tool—either custom API code, or something like Zapier or Integromat—to do the end-time calculation and update a regular date field.

Thanks Justin, this is the type of workaround I was hoping for :slight_smile: Thank you very much!