Add multiple rows to table using Glide workflows

[Informium_Labs]

Hi everyone,

I have a situation where I have n number of participants for a transaction in a row.
eg:
Row number-Participants
1-UserA,UserB,UserC
2-UserA,UserD

The number of participants in a particular row can vary.

I want to have some way either via workflows or some other method to add as many rows to a separate table as there are participants in a row.
eg: Since in the 2 rows we have 5 participants(Duplicates are allowed), there should be 5 rows in the separate table, one for each participant of each row.

I am sure there is a way to achieve this. I would love to hear your thoughts.

[MaximeBaker]

I have a solution for you but it needs a paid plan. Do you got one?

[MaximeBaker]

If you do, I made a thread explaining how to play with Glide API and Call API to bulk edit rows.

Bulk Edit Column Values Across Multiple Rows in Glide with User-Specific Column Compatibility

I implemented a feature that allows you to edit values across an entire column, similar to the solution discussed here, but using the official Glide API in a compliant manner. For this example, I configured a choice component that enables you to select the rows you wish to edit. There’s a button that allows you to select all rows or clear your selections. This flexibility lets you choose whichever rows you need to update. Once you’ve made your selections, you can set a new value for a specific …

You can do the same thing for add row.

🎓 Glide Tutorial - Add, Edit or Delete Multiple Rows (Glide API)

[Informium_Labs]

Not on a paid plan. I am on the free plan currently.

[MaximeBaker]

If you want to stay on a free plan, you could try to store data as JSON and use Custom AI Component to make a list.

[ThinhDinh]

At the moment, I think the cheapest way to do what you want is using Make, on the Maker plan.

Conditional Add Rows

If you want to keep it solely in Glide, I would suggest using Glide’s JSON template/JSON columns, or JavaScript to construct a HTTP call body that fits with Glide’s API. Then, upon a button click, use the value above to add multiple rows. However, you must have access to the Call API action to do this. An alternative is like Robert said, constructing a JSON of info for all rows you want to add (and ideally it should be the same as the HTTP call body above), then use a Trigger Webhook action to…