Auto insert rows depending on type of form chosen

[KathB27]

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.

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

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:

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

[SkrOYC]

App design 101 - AppSheet Help

[KathB27]

Thank you so much!

[KathB27]

Thank you for your reply. Is there any way i can auto insert rows when we enter the no. of crates?

[Suvrutt_Gurjar]

There are multiple tips and tricks posts on adding multiple rows to a table. Please take a look at those posts.

Search - Google Cloud Community

[KathB27]

Thank you Suvrutt! i will for sure read all of them and use whatever i can. Thanks again 😊

[Steve]

You should probably try to find someone you can pay to help you. The phrasing of your request suggests your need is not simple.

[KathB27]

Hi Steve,

Thank you for your reply but unfortunately i dont have that option...so all i can do is rack my brains till crazy.

Please are you able to help me on just one big problem that i have... so i created the form below where the platform line is an enumlist referenced to another table. I just want appsheet to count the number of rows that belong to the platform line i have chosen and create rows as per the same number.

Like for example i chose A412 Line which has 8 rows as per the 2nd photo. I just need the formula to auto count only the rows for A412 and then auto create the rows.

Thank you so much in advance and sorry for taking your time.

 

Sincerely,

Teren 

[SkrOYC]

Looping with actions - Google Cloud Community

Add any number of rows from any row within a table - Google Cloud Community

Nested Action Loops - Google Cloud Community

Looping with Actions (Sample App BUILD Video) - Google Cloud Community

Once you wrap your head around the concept, it get's easier

[KathB27]

Thank you very much!😊

[KathB27]

Hi Steve,

Thank you for your reply but unfortunately i dont have that option...so all i can do is rack my brains till crazy.

Please are you able to help me on just one big problem that i have... so i created the form below where the platform line is an enumlist referenced to another table. I just want appsheet to count the number of rows that belong to the platform line i have chosen and create rows as per the same number.

Like for example i chose A412 Line which has 8 rows as per the 2nd photo. I just need the formula to auto count only the rows for A412 and then auto create the rows.

Thank you so much in advance and sorry for taking your time.

Sincerely,

Teren