Auto insert rows depending on type of form chosen

Hi All,

I badly and urgently need help...i work in a packaging company and my boss need an app to track the progress of the packing for the machines. Each Machine (WBS Element) is dismantled into different parts and then crated up for shipment.

The first table below is the reference table, where the users will choose the WBS Element they want to start packing. The No. of Crates will depend on what type of Platform Line the WBS Element belongs to.

KathB27_1-1660702986613.png

Below is an example of a Platform Line (A412) --- Each Platform line has different no. of crates and Parts.

KathB27_2-1660703682074.png

I need help to auto create the number of rows depending on the Platform line the user will choose and carry over the details as well (Specially the PARTS)

Below is the sample of the form:

KathB27_3-1660703883031.png

 

Please please help me on how i can achieve this and what formula i can use for API workflows in appsheet.

Thank you Thank you Thank you for anyone and everyone who will reply to this query.

God Bless!

 

Sincerely,

Kath

 

0 10 365
10 REPLIES 10
Top Labels in this Space