Refresh pack tables with formula / automation?

1

The only way I found to refresh a pack table (eg. a Google Calendar event list) is if I click the “refresh” button on the associated table.

Would it be possible to refresh a synced pack table via a formula or automation?

Example use case:

  1. Have a filter table with dates to and from → this is used in the Google Calendar table to determine the sync range (the date range for the events pulled into the table)
  2. User changes the from date in the filter table
  3. Automation is set up to refresh the Google Calendar table
  4. Since the date range is now different in the filter table, this would refresh the Google Calendar table to the appropriate date range without the user having to press a “refresh” button
4

G’day @Zsolt_Marcsev !

not sure if this approach is suitable for your use case but a different take could be to have your google calendar sync all dates. then use the filter table as a date control to set a filtered view of your google calendar table?

hope this makes sense :slightly_smiling_face:

Cheers!
Mel

5

Have you tried using the RefreshTable() formula?

6

This works as intended. I added the formula with the reference to a button and upon click it will refresh the Google Calendar connection.

I ended up using this option with a date range filter instead by adding references to the dates in the Google Calendar connection settings. I was unaware there was an option to keep un-synced rows before but that worked better for my use case:
image

Thanks everyone for the help.