Hi all, I’m trying to modify the Google Calendar template and I haven’t been able to figure out how to use a secondary calendar with the table.
In the example document, the button to pull events into a table (called “All My Pulled Events”) has a formula that looks like this:
FormulaMap(GoogleCalendar::Events([email@example.com], “firstname.lastname@example.org”, Today(), Today() + rangeofdays), CurrentValue.Id).FormulaMap(AddOrModifyRows([All My Pulled Events], CurrentValue = Id, Event, CurrentValue))
It dumps the eventID from the Google Calendar into a Google Calendar column (named “Event”) in the target table and the remaining columns use formulae to pull in other attributes like the start, end and description of the event. Good so far – when the data from my primary Google Calendar is put into the example table, everything works as expected.
But if I change the value of the calendar (bolded in the example formula above) from my primary calendar to a secondary calendar, the Google Calendar column in the table recoils in horror, per the screenshot below:
To be clear, the issue appears to be when the data is being pulled into the table. I suppose I’m not formatting the secondary calendar’s identifier (URL, ID or name, according to the Coda Help function document) in a way that works with the Google Calendar column type.
Any suggestions? Thanks in advance…