Adding multiple rows to another table on an action

[Virgil_Wilson]

I’m creating a work order application and when a work order is added it automatically adds 4 tasks to the task table with an unique ID

OderTask Table Rows
TaskID Order Number - Task
Row 1 uniqueID() 1 A
Row 2 uniqueID() 1 B
Row 3 uniqueID() 1 C
Row 4 uniqueID() 1 D

[Koichi_Tsuji]

There are bunch of the tricks to achieve your goal. but the most simplest one should be

1. Create action to add new row using column value from this row, for each different tasks. Now you have 4 x similar action, to append new rows to order task table.
2. Create the another action execute grouped actions, pick up 4 x action you created in no.1.
3. Fire this No.2 action either way, upon saving the form, or by hitting action button or worflow whatever you want.

[Virgil_Wilson]

Thanks for your reply
I understand the jist of what we are doing. I created the actions to add each tasks
This is the action with multiple actions to call

This is one of my task being corrected

The part I’m confused is how are they triggered.

[Koichi_Tsuji]

The action to add multiple rows is the Create Tasks action isnt it ?

Option 1; Simply place this action either place, overlay, permanent. User explicitely hit action button to add row.

Option 2 ; Go to form view where the action is starting from. For setting of form view, place this action to fire “on save” to fire action. But problem with this set up is action will keep fired all the time when the form is updated.

Option 3 ; Fire this action through the workflow, ideally ADD ROW event to the table. Once the new row is created and saved, the workflow is fired and action will add rows to the child.

[Steve]

FAQ: Add a number of rows Tips & Tricks 💡

Add an arbitrary number of rows to a table based on a column value of type Number. Try the sample app! For this example, the table from which the row-addition process will be initiated is called Control Table. The table to which new rows will be added is called Target Table. Use your own names as you see fit. Note that they could even be the same table. Control Table must allow updates; Target Table must allow adds. Control Table must have at least two columns for this process: Finish Count (…

FAQ: add a set of rows Tips & Tricks 💡

When a row is added to a table, add a set of rows to another table. Try the sample app! This example uses three tables: Master Table: when a new row is added here, all rows from Source Table will be copied to Target Table and linked back to the new Master Table row. This table must allow adds. Source Table, from which all rows will be copied to Target Table. Target Table, to which all rows from Source Table will be copied. This table must allow adds. Action 1: Copy Source Table row…

[Diego_Leon]

Hola podrias brindare consultoria para implementar esto en un proyecto mio?

[PStar]

This works so well!

When “adding a number of rows” version from above, I use the tool and it works fine across many columns but it won’t copy down the ‘referenced rows’ column data. I could do with the referenced rows doing the same please - Is there a way to do this? Thanks in advance.

[Steve]

PStar:

it won’t copy down the ‘referenced rows’ column data. I could do with the referenced rows doing the same

Could you explain a little more? I’m not sure I understand.

[PStar]

Hi.

I have columns with data that has been manually entered by a user and this is copied down with the behaviours rules all really well with the tools above.

I need to get thenewly created (copied) rows to duplicate all the cells ‘set as references’ to other tables in the app to duplicate with the same behaviour as the manualy entered cells please.

[PStar]

Can anyone help please? Really can’t figure out a way to get the duplication working for referenced cells in the same way as the normal cells. Thanks in advance to any wizard that can pass me the magic.

[Steve]

Your additional explanation provided no new information. Help me understand, preferably using AppSheet terms rather than spreadsheet terms.

[PStar]

Thanks, to expand in AppSheet terms;

Columns that are data added by the user in the app, are duplicated with the great tool above.
Columns that are referenced from other tables are not duplicated by the actions.

The two in the red boxes, are references and they do not seem to be duplicated in the table where duplication occurs.

[Steve]

Thank you for the additional explanation!

There’s no technical reason Ref values can’t be copied, so we should probably look at how you’re adding the rows and copying values. Please post screenshots of the configurations of the actions involved.