Dynamic inputs to add rows in another table

[INN_ENGENHARIA]

I have been trying to use the expression input() to add rows to another table, but it seems that the dynamic input is not recognized, as it is my first time using this fuction, i dont know if i’m wrong or as it is a beta fuction it is not working as it should.

1. First I have created an action to add the rows to another table:

2. Then i have put an expression to call the dynamic input from the parent table:

3. Last i add an action to execute from the parent table and declared the input “id orçamento” to be the value from the row [id orçamento]:

Result:

It has been a wild ride to put this function working, if anyone could help i would be much obliged.

[Marc_Dillon]

At this time you cannot use INPUT() within a “data add a new row” Action.

[shahappsheet]

It is Possible.

Add a New Row to Another Table Means, Table 1 is the base table where your View is linked. Therefore, the INPUT value need to pass to the Table1, then following the relationship the value will go to Table 2 where you create Another row to Table2 or Update it. I have have done it using action following this rule. Actually this AppSheet basic logic. Appsheet all the time bound to a table and that table is its main business.

[shahappsheet]

shahappsheet:

. I have have done it using action

Yes I mentioned previously in my thread, as well. Anyway, Great.

[INN_ENGENHARIA · Accepted solution]

I have recently found a solution for the problem,

The ideia is, as i have some inputs to add to a third table that is not in the parent table but i can access if from the actual table, i can create a webhook to appsheet API to carry these values.

If anyone is interest in how to make the automation you could access these two topics.

SAVE a TON of SYNC time WHEN CREATING MULTIPLE ROWS (From: 120sec to only 5sec with ONE SINGLE TIP) Tips & Tricks 💡

Guys, Im so happy right now, I just drop a sync time from 120sec to less than 5sec on automation (Actually 120sec using bots, with delta sync, server chache, etc etc… I dont even want to know how much time it would have been If I were using Actions instead) Im sure this is not a big surprise for most advanced users but… Man… I think this is the biggest game changer I have discovered after understanding REF column Type. Like most things in life, the hardway, is the most powerful and …

Copy parent record together with child records ; Action Only, No API, No workflow Tips & Tricks 💡

After introducing a trick how to copy the related child records along with parent record through the post of Quite a few people have been asking me how to manage it without API, but actions only. Sharing this trick may get the Appsheet sales team angry with me, so I m bit reluctant to do so, as it may reduce the sales opportunities for business subscriptions … , but let me put it aside now, This is what I managed to achieve the same task, “copy parent record together with child …

[INN_ENGENHARIA]

Another solution that works for me was to first create an action to add the rows then create another action to edit the rows using the input() expression and then create a third action to execute the other two at the same time.