I tried different formulas but i have a problem selecting the specific calendar name (look, in “Calendar.Calendar”) , so I’m not really able to filter properly
Calendars from the GCal pack have a “Summary” property which seems to be the name of the calendar (as a text value) so you would just need to add a column in the table Today with a formula gathering the summary property from the Calendar (in this case, this should be as simple as thisRow.Calendar.Summary)
And then, instead of trying to use directly the Calendar column in the Filter(), you can use this brand new column …
(Coda will suggest values from the Calendar Summary column for you to choose from and use in your Filter() and of course, you can hide that column if it’s in the way)
Me neither … But I had a similar intuition as yours and was pretty sure the ToText() could probably be avoid here (as it’s generally the case) so I tried …