I am looking to assign checklist items from one table to a “daily list” inside another table via a form. I’ve created multiple actions to attempt this with no such luck. Help!
So you want to add multiple rows to the “Daily list” with a form? What plan are you on?
Yes. I am on the starter plan. I am looking to add all of the items selected in the checklist (sourced from another table) into a column inside my Daily checklist (a different table). Thank you for responding!
Assuming you use Glide Tables, the best way to do this would be to use Call API action (available on Business plan) with a specific JSON in your request body, that you can build dynamically in Glide, to call Glide Tables API (available on Pro plan) to add multiple rows with a single mutation. On Pro plan, you can alternatively use Make or Zapier to call Glide Tables API.
If switching plans doesn’t work for you, you can redesign your app to use arrays of arrays (multiple files column). By array of arrays I mean an array of elements like “abc;def;123;2023-11-26T00:00:00:000Z;true” where each element represents a “row” with values separated by a delimeter of your choice. With a helper table you can make those arrays look like an ordinary table. Use row number logic and a bunch of single value columns for that.
This approach is much more complex and has its downsides, but you can try it out.
2 Likes