Problems in syncing from sheet to appsheet

[MartinBarbieri]

Hello! When I add a row from appsheet in my shet I have a script that duplicates that row creating one more for me. The problem is that when that row is added it takes a long time to appear in the appsheet. In fact, I update the application many times and since it doesn't work I have to close and reopen, then the new row appears. What could it be? How can I solve that?

[Steve]

Completely remove your script from the sheet. Is the problem still there?

[MartinBarbieri]

Thanks for answering! If you removed the script as soon as I update it already appears, but I need it to be duplicated when I enter a row, how should I do this then?

[Steve]

You can use Automation. Create a bot that responds to the addition of a new row.

Automate workflows - AppSheet Help

[MartinBarbieri]

It's okay. Should I do it by configuring that the event starts only when it is added and later in the process, something like this would be? :

To set the duplicate row to have the same values ​​as the other, is it correct to use [_thisrow]? Do I have to go field by field or can I make it somehow detect that I want to enter the same thing?
Thank you very much!

[Steve]

Yes, the bot should be triggered by the addition of a new row.

Your bot will need to populate every column of the duplicate row it adds; there's no way to tell it to duplicate the entire row.

You should not need to use _THISROW.

[MartinBarbieri]

And what should i use instead of _THISROW? I mean, How does the bot know what value put in each field?

[Steve · Accepted solution]

In this configuration:

Column references (such as [Column_1] in the above) refer to the column of the row that was added, not the duplicate row that you're adding in response. So the value expressions for the remaining columns shown above are as simple as [PACIENTES], [S], and [DRA/DR].

[MartinBarbieri]

Hi! Although I implemented the bot that duplicates a row and removed all the scripts, I realized after using the application that I have the same problem. When I update a row from the sheet I have to refresh the page many times so that the values ​​appear correctly in the appsheet.
How can I solve that?

[Steve]

Don't update the sheet directly.