Can Pack create "no sync" table?

Hello !

I’ve successfully create a Pack with 2 sync tables, and a relation between them.

Now, I need to link one of those sync table to another table, “not sync”, BUT, I don’t want the user to create it, to avoid mistakes.

The goal is to populate this table with data I will get from a Make’s scenario, launch with a pack button.

Do you know how I can create a “no sync” table with a pack, or an other solution, which avoid the user to do it himself ?

Thanks.
Alexandre

A workaround I’ve experimented with is using a two-way sync table where the executeUpdate function is a no-op that simply returns the data that was passed in, but there are two issues with this solution:

  1. There’s no way to add new rows to the table, so you would have to know how many rows you’ll need up front & return empty rows from the execute function.
  2. If the user ever presses the “sync” button after making their changes, all their data will be overwritten with whatever is returned from the execute function.

You might try using something like Supabase as a backing store for the data to overcome these obstacles, but that would add a fair amount of complexity.

A much simpler solution would be to publish a doc with the desired table schema in it, then instruct your pack users on how to copy the containing page to their own doc.