Hello,
I am making a manufacturing resource planner app. One of the necessary features is to track assemblies of individual components. Each assembly may have a different number of components. The way this would normally be done in a database would be to have a many-to-many table with both the Assembly ID and Component ID as keys, and every time a new assembly is added, several rows are added to the table. I am trying to replicate this structure in google sheets.
As far as I'm aware, AppSheets only allows adding a single row at a time to this table. I saw this example of adding multiple rows at once using a grouped action, but it seems to only work for a fixed number of rows. In this case I would like the user to be able to add any number of components and their respective quantities in the same form that creates the assembly. Is there any way to do this in AppSheets? Or am I going to have to move to a different platform?
I appreciate any help on this issue. Thank you in advance.
-Sam
LinkedIn
Twitter
