Refer to a column for packconnection

#1

Hi everyone,

I’m trying to perform an action on a set of different google Calendars. Currently I have to edit the button for every google calendar I’m trying to perform the action on, which is a hassle I’d like to prevent.

Ideally:

  1. I’d have a button to put out all the connected google calendar packs to a table
  2. They’d each have a checkbox
    3 So I can perform an action on all of them depending on the checkbox.

Something like this:

Two questions:

  1. Is there a formula to list all the pack connections?
  2. If I know the pack connection, and it is the input of a cell, can I link to that column to use the connection. It seems to error there for me.

Thanks for the help in advance