Function - adding a new row to another table

[Diana]

Hi. I have one problem. I have two tables. First is a form, where I make new data and second table is database, where I send these new datas. The problém is, that I used a function -adding a new row to another table. Everything is going correctly, but It send a new data’s row from form to second database table in duplicite. Instead of one new row, it makes the same two rows.
Could you give Me an advice, where is the problém please?

[Marc_Dillon]

Diana:

I have two tables. First is a form, where I make new data and second table is database, where I send these new datas.

I think you have a misunderstanding here. A Form is not a Table. A Form is a type of view, specifically for adding or editing data from a single record, on a Table. When you add a new record with a Form view, the record goes the that Table.

By using the “Add a new row” Action, you’re telling the system to also add that record to another Table.

It seems like you’re not wanting the record to be saved to the first Table? So why don’t you just use a Form view for the second Table?

[Diana]

Sorry, I will try to explain once again. The first table: it is a list of items which I can borrow. The second table: its some database, where all borrowed items are saved. So I choose item from a table one, and I want to save data about this lending to another (second) table. Everything is going correctly as I want. But the only problem is that it saved to this database in duplicate. I would like to save it in one new row with all datas, but it makes a duplicite and makes two same rows.
Is it clearly explained?

Thanks for advice.

[Marc_Dillon]

Diana:

But the only problem is that it saved to this database in duplicate. I would like to save it in one new row with all datas, but it makes a duplicite and makes two same rows.
Is it clearly explained?

No, not clear. Please show the “duplicates” with screenshots.

[Marc_Dillon]

How is the Action triggered? Is it being triggered twice?

[Diana]

Yes, it is being triggered twice. But I have just one action for add a new row.

[Marc_Dillon]

Why/how is it being triggered twice then?

Is it a manual button press, a Form Save Action, a Bot, something else?

[Marc_Dillon]

Can you show how your Event is set up, including any condition expression?

Have you checked the Automation Monitor or Audit Log for any clues about it triggering multiple times?

[Marc_Dillon]

[Diana]

I made a change. But nothing change

[Marc_Dillon]

Do you mean you tested it by adding a new record and still got duplicates?

[Diana]

Yes

[Marc_Dillon]

My best guess at this point then is that the Action is being fired a second time somewhere else, like on Form Save, or another Bot.

Also,

Marc_Dillon:

Have you checked the Automation Monitor or Audit Log for any clues about it triggering multiple times?

[Marc_Dillon]

That’s a “Row Select”, from a Table or Deck view. “Form Save” is found on…Form views.

[Diana]

Thank you for advice.

The appsheet is going correctly now. I tried automatical monitor. There were two similar apps which where working parallel. although I don’t know how it’s possible. So 1 AppSheet document I deleted, and in the second one, there were two function for adding a rows. One in “bot” and one in “Workflow”.

Thank you very much