I realize another option may be for a script button where I hand enter Class 1 start and Class 1 End dates+times, then script a copy record for ‘x number of weeks’.
Welcome to the community, @Todd_Grier! :grinning_face_with_big_eyes:
Yes they can. I’ve got a couple of calendars (also for classes that I teach) where I do this exact thing, and it works fine. (In fact, both the start and end fields in my case are formulas.)
One thing that you didn’t mention is the field type where you’re storing the class duration. If it’s a number field, then this should work to calculate the end time (changing the field names as needed for your table, of course):
DATEADD({Start Time}, {Duration}, "minutes")
However, if you’re using a Duration field type, it’s important to know that this field will give you the value in seconds, even though you might have entered it in an hh:mm format. In that case, the formula would be the same as above, but changing “minutes” to “seconds”.
If that doesn’t get you on the right track, then we can dig deeper.
Welcome to the community, @Todd_Grier! :grinning_face_with_big_eyes:
Yes they can. I’ve got a couple of calendars (also for classes that I teach) where I do this exact thing, and it works fine. (In fact, both the start and end fields in my case are formulas.)
One thing that you didn’t mention is the field type where you’re storing the class duration. If it’s a number field, then this should work to calculate the end time (changing the field names as needed for your table, of course):
DATEADD({Start Time}, {Duration}, "minutes")
However, if you’re using a Duration field type, it’s important to know that this field will give you the value in seconds, even though you might have entered it in an hh:mm format. In that case, the formula would be the same as above, but changing “minutes” to “seconds”.
If that doesn’t get you on the right track, then we can dig deeper.
I didn’t try this, but maybe the issue was {Start Time} is set as a type of Date/Time, the {End Time} was set as a formula. In setting up the calendar view, when I used a start time + end time an error popped up.
I went ahead and hand entered these for now, but I’ll tinker with the future events as I plan them.
Thanks for the clarification
I didn’t try this, but maybe the issue was {Start Time} is set as a type of Date/Time, the {End Time} was set as a formula. In setting up the calendar view, when I used a start time + end time an error popped up.
I went ahead and hand entered these for now, but I’ll tinker with the future events as I plan them.
Thanks for the clarification
A formula will work for either as long as the formula outputs a valid datetime item. If you run into another issue, share the formula you’re using and we can help.
A formula will work for either as long as the formula outputs a valid datetime item. If you run into another issue, share the formula you’re using and we can help.
This still open? Anyway, reading this last post reminded me that twice- and more mirrored formulas don’t really behave too well when it comes to automations.
Like the OP suggested, Airtable can’t read them reliably or at all, depending on the implementation. But this is probably due to the way Airtable’s own infrastructure works and/or offloads work.
While it’s not immediately relevant here, anyone from the future reading this who isn’t aware of DATETIME_PARSE() should check it out if they’re after complex datation mechanisms but don’t want to risk a one-way ticket to migraine express and coding is out of the question.