I am trying to generate multiple rows dynamically upon form submission. Does anyone have an idea for a workaround? Here is my situation: I am manufacturing a product. To make the product I need multiple components. I’d like to fill out a form with the quantity of the final product I would like to…

[image] ThinhDinh: I had the same use case a while ago and built a structure to use with the Sheets API, I assume you use it as well. No! I wasn’t aware that it behaved that way, will definitely check it out.

[image] Tobias: @Darren_Murphy this sounds pretty complex and likely to break and difficult to change or update with the JSON structure. What makes you think it would be likely to break? It hasn’t broken yet :wink:

Sorry, I should have been more clear. I may not be the only one working on the project. So unless the other person also completely understands how it works and keeps it in mind while adding more functionality it may break. But I guess all currently suggested solutions have that issue since they b…

[image] Tobias: @Roldy I did find it actually, but not in Glide Pages, but in Glide Apps. Glide Templates | Simple BOM | Create a No Code App Thanks @Tobias Please @SantiagoPerez can you check what happened? This template is for Glide Pages not Glide App.

[image] Tobias: @VVerhille I was also thinking about using Apps Script. I’m very familiar with it. Would you mind sharing the code of how you have set that up? If you’re familiar with apps script, then this is fairly straight forward. All you really need to do is write a single row to a worki…

We haven’t launch the app yet should be within few weeks. All testing were successful so far and Darren’s script works great so far but when mass users start we’ll be smarter

Uuufff… amazing work @Roldy :trophy: Reading the term “BOM” at the beginning I was confused, I knew that I had seen something like this and remembered my days working with SCADA systems. We called it a Recipe but it was something basic and each Recipe was saved as a text file. Any time we wanted …

[image] Method: spreadsheets.values.append | Sheets API | ... I use this, specifically. [image] [image] Built my value structure through my app and pass it via the webhook.

Thanks, everyone for so much input. I came up with a solution that would work with any solution that allows to loop over a table. I used App Script. I restructured the data to the following: Products & Components (id, name, type) Assembly (id, product id, component id, quantity) Production List…

Creation of multiple rows dynamically

Ask for Help

SantiagoPerez January 18, 2022, 12:26am 32

You do not need to resubmit it.

I meant, next Page that you submit, type your name in the description so it gets posted on the Template store.

1 Like

Topic		Replies	Views
How to make loops of rows and repeat them dynamic number of times Community Resources tutorial	26	3177	July 14, 2023
Is it possible to create multiple records from one entry? Ask for Help	27	2079	October 20, 2022
Multi-select items with number of items to create bulk order form that adds row for each Ask for Help	22	1052	July 11, 2024
Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations Feature Requests	55	3412	July 21, 2025
Add Row from ChatGPT Table Ask for Help	12	834	March 19, 2024

Creation of multiple rows dynamically

Related topics