Hi @Melanie_Teh , thanks for your time and help.
I guess, I would really like to let my users be able to say “9am in US Central on March 20, 2025”, and not have to think about it. I use Fantastical / iCal and it just does this for me. I don’t have to personally think about daylight savings. Similarly, I can in Google Calendar specify the same. I tested it: I made an event in Google Calendar “9am in US Central on March 20, 2025”, and it shows up in Coda correctly in Berlin time with an offset of 6 hours (cuz we’re in the period when Europe and US are out of sync), instead of 7. Similarly, an event on July 1, 2025 at 9am in US Central comes in at 4pm Berlin, correctly.
I guess, with what’s provided, my users MUST know what time in the Coda Doc timezone the event occurs when they make the Coda row. in which case I don’t need to do anything about time zones, a human does it all. It’s just a lot to ask of my entire team to have to deal with daylight savings and always convert to one time zone, regardless of what it is, as it requires perfect memory.
I agree that the other thread I’ve been writing in is now more on-topic – but I maintain that a problem would be solved if I could make events in gcal from Coda and specify the time zone. The GCal API allows it… And it would be even more solved if time zones and time zone conversions were natively supported in Coda.
Thanks again for your time and help.
~silviana