It seemed to me that you have a solution in the Simple BOM project https://www.youtube.com/watch?v=um6Z-DMFOvQ
No?
If you think globally, it is possible that the presence of such a solution could create a large computational load (not in such a task, but in other implementations). Therefore, in order to stabilize the level of performance, the creators of Glide deliberately did not provide such an opportunity?
This approach might be okay if the maximum number of rows you want to add is very small - say less than 10. But it obviously won’t scale.
But if you want a general solution that will work for an arbitrary number of rows, then the best approach is to use an external tool such as Integromat/Make.
The general approach is:
Build a JSON object in Glide containing a collection of key/value pairs - one for each row to be added.
Send that object to Integromat via a webhook
Use an iterator and HTTP module to insert the rows back into Glide
If you have a Pro app, you can insert directly back into Glide via the API, otherwise you can add the rows to the backend Google Spreadsheet.
With the above approach, you can insert any number or rows with a single action.
Thank you, Darren! I keep this method in mind. But the use of integromat introduces a delay, the use of google also slows down the work, a large number of visibiliti IF also interferes with the application. And all these services are overseas, if you really use a glide, then you want everything to work inside one service.
About using PRO subscriptions: I am a novice developer and using paid subscriptions is very wasteful for learning. If it were possible to use several applications within one subscription, then it might still be tolerable, but paying $40 per month for each application just to be able to train in application development is very wasteful. Of course, it is possible to enable and disable the subscription, but still…
With the same Intrgromat, I have a lot of application prototypes, but Integromat allows you to have only two working scripts at the same time, the rest is paid. You have to name several accounts in Integromat. All this accumulates like a snowball. Therefore, there is such a strong desire to realize the maximum inside the same platform.
Thank you for your response
Unfortunately in simple bom the scenario is very different from what you ask for. In simple bom when you produce, no rows are added for every material used for the production of the end product; the progressives of loading (of the end product) and unloading of raw materials and components, are increased / decreased, in the items, thanks to the Increment function which acts through a relation.
The table that appears on the screen is built in html (it is not an inline list that draws the rows from some datatable).
Your case is different, you want to add multirows to data tables only when necessary. That’s correct, but at the moment I don’t have a smart way to do this with the actions we have available in Glide. I am looking for a workaround but it is really difficult because we cannot exploit a relation to add new rows of data, we can only use it to update the row linked with the relation.
I hope I have explained.
And yes. I also believe that the lack of a function for this is due to the fact that it would generate too many computations.
For my idea with BOM. Can we make BOM table that relate with products. When we add required qty for any product, the BOM table will be responsed. Does this work?