Settings
PST Offset From Your Timezone: Add Highlights To My Google Calendar:
// Keeping the Google Calendar button separate to avoid clutter
1️⃣ To make all future highlights appear in your Google Calendar, select the Add Highlights To My Google Calendar option above.
2️⃣ Connect your Google Calendar using the Packs panel in the menu above ( the puzzle piece )
3️⃣ Go to the Automation panel in the menu above ( 🤖) and select the existing rule to add to Google Calendar
4️⃣ Duplicate the rule in the vertical menu ( 🚦)
5️⃣ Select the option at the bottom of the automation to Take actions as Some calculations to create events properly in Coda
Coda uses PST to show calendar events If you are not in PST, you'll need to offset the start time so the calendar shows you events that span one day properly
// Get Timezone
{"Timezone":"America/Los_Angeles","CurrentOffset":-7}
// Let's figure out what your CurrentOffset is (in my case, -4 for EST) using some parsing
{"Timezone"America/Los_Angeles","CurrentOffset-7}
// The PST Offset is your CurrentOffset (-4 in my case) + 7 (the GMT Offset from PST when not in Daylight Savings Time)
// For multiple highlights completed, show the statement:
You've had 0 highlights so far!