Show data in Appsheet made in Google Table

[TheBadOne]

How can I show data in Appsheet app added manualy in Google Sheet? I need this data to be synchronized every time I enter new data for new row into a Google Sheet manually. Is it possible?

[Markus_Malessa]

This question has been asked before and there is documentation for a Appsheet events add-on for Google Sheets. Here is the documentation https://support.google.com/appsheet/answer/11520310?hl=en&sjid=3533172825435433724-NA#configure

[TheBadOne]

Yeah, but it doen't not solve my problem. It does not add a recording to Appsheet. New rows added manualy in Google sheet are still not displayed in Apsheet. Maybe I'm doing something wrong?

[AleksiAlkio]

If the app doesn't show those manually added rows, there could be few reasons.. your key column contains duplicate values, your security filter or slice is filtering the data. Check these first.

[TheBadOne]

Алексей, позволю себе предположить, что вы русскоговорящий пользователь 🙂 Если я ошибаюсь, поправьте. Я проверил, там нет дублированных записей никаких. Я думаю дело в боте. Как настроить бот для добавления новых записей в Appsheet, если я вручную добавляю запись таблицу (т.е. я добавляю ряд с данными).

Ваша предыдущая рекомендация мне очень помогла, за неё спасибо. Надеюсь и тут подскажете. Заранее огромное спасибо. А то я уже полез в Zapier, но хотелось бы отделаться меньшей кровью, так сказать.

[AleksiAlkio]

Your assumption was wrong.

Next check that the Editor > Settings > Performance > Delta sync option is set as OFF.

[TheBadOne]

I'm really sorry, the problem was that the table had rows with the same [ID]. Now it works.

[TheBadOne]

And is there a way for the Appsheet app to automatically sync when adding data to the table manually without clicking on the sync button in the app?

[AleksiAlkio]

Good to hear!

[Denzil_Snyman]

@TheBadOne perhaps this may help, I have not tested myself.

https://youtu.be/lK0BASiLSaU?si=kV9dVemqQetZfNMf

[TheBadOne]

All ok, but I can’t import new rows added to the table manually into the Apsheet application. Synchronizing changes - yes, there is no problem here, but importing so that you don’t have to click on the sync button does not work. Any ideas?

[JSO]

In tests I've done, AppSheet Even works fine but only for record modifications.
If records are added or deleted directly from the sheet, it is not able to detect it and manual synchronization is necessary.