Webhooks preset option

[Kaushal_Didwan1]

I am trying it add a row from app to data of another app using webhooks preset option? Can anyone explain me how to do that in detail or can share a video where this can be done.

Scenario which I have:

After adding an order in sales order app, a purchase order in purchase order app should be added automatically.

[Aleksi]

Have you checked this new feature where you can add rows with an action and Webhook is not needed?

New Action: Add a Row to a table Announcements

We just added an initial version of a new action ‘Data: add a new row to another table using values from this row’ Please try it and give us feedback. Documentation, etc coming later this week. The brief version is here: let’s consider an example with Orders and OrderDetails as two related tables in an app. Add an action ‘CreateChildRow’ to the Orders table that will add a row to the OrderDetails table. You can specify expressions to assign to each column of this row. For example: Order = [O…

[Kaushal_Didwan1]

The concept is good But when i am saving the data, i am getting an error message saying that the column with same key already exists. The _rowNumber is my key with time stamp so it should not say that the row exisits with key “09-21-2019 18:55:45”

[Kaushal_Didwan1]

It works, but when i am adding more than 10-15 rows, some off the rows are not getting added in the other sheet.

After doing this I have a onChange function written in google sheets but that function is getting executed twice. Any idea why it must be doing that?

Moreover apart from adding an entire row, can we change the value of a single cell in another sheet once a value has been set in a sheet. for example: i have a sales order sheet and a purchase order sheet. Once I have received an item in purchase order. I can see set that i have received the item in sales order file.

Thanks,

[Kaushal_Didwan1]

Hello,

I am not able to add a row in another table from the data collected from a table using the preset option. Can you please help?

[Aleksi]

Please check a sample app called UpdateEventAction from https://www.appsheet.com/portfolio/531778

[Kaushal_Didwan1]

I have done the same thing you have done. But still row is not getting added untill I run the action manually in the app.

[Aleksi]

What do you mean by “row is not getting added”? Do you mean it doesn’t update the record?

[Kaushal_Didwan1]

I have an action defining that when a new row is added in Table1, also add some values in Table2. But it is not getting executed when a row is added in Table1.
However in the app if i click the action button displayed in top right, only then it is getting added in Table2

[Aleksi]

You mean that your action is adding some values into the existing record, correct?

[Kaushal_Didwan1]

No. I am adding a row in table1, after adding if a contidion is true then the value is also added in another table