INSERT multiple raw with 1 form

[Fortunato]

I have a form for tracking expenses. In this form, user can select if the transaction is a income, expense or Bank Transfer. 
if is expense, form shows only account, amount etc… 

if is income, form shows only accont, amount etc

if is bank transfer, form shows account income, account expense and amount. 
I need an automation that insert 2 row, one for debit movement and one for credit movem te whith same amount. 
how is it possible?

[TeeSee1]

Try using a composite action to fire two "add a row to another table ... " actions.

https://support.google.com/appsheet/answer/10107706?hl=en#zippy=%2Cgrouped-execute-a-sequence-of-act...

[dbaum · Accepted solution]

Try creating a "Grouped: execute a sequence of actions" action that

• Runs when the transaction is a bank transfer (using an expression in the Only if this condition is true property
• Includes a "Data: add a new row to another table by using values from this row" action for each row you need (as well as, if desired, the delete action for the original row)
• Is set as the Form saved event

[Fortunato]

Thank you. I will try, even if it is a bit complicated for me to do this procedure. 😣

[Fortunato]

I managed to create the two behaviors (Add Credit and Add Debit). I created the Bots which is started by the DATA CHANGE / Tbl Transactions / AddsOnly event.
The Bot performs the two processes.
But now I don't know how to delete the original row. Now I have 3 rows: Debit, Credit and  the original one...

[dbaum]

To be clear: You shouldn't need to use an automation (bot) to accomplish this, although that's a valid way to do it.

To delete, use an action (from an automation data change step if you like) that invokes the system-created Delete action for the table.