I am developing an application where a list is displayed according to the user input. The list is loading and getting displayed when the application is loaded and whenever the user inputs the data through the text fields(in the app) and the cells (in the google sheet) gets appended too ( which is what I want). But I would like to be able to get realtime list append in the application whenever any new data is inserted in the google sheet itself. So how do I listen for changes in google sheet everytime there is any change and update/append the list (in the application) according to it? Currently, whenever the data is inserted in the google sheet itself, the data only gets loaded when I hot restart the application.
Asked
Active
Viewed 477 times
-1
-
Please provide enough code so others can better understand or reproduce the problem. – Chirag Kothiya Dec 25 '21 at 05:06
1 Answers
0
Have you tried Apps Script Triggers? Maybe the function onEdit(e) can help: https://developers.google.com/apps-script/guides/triggers
SKuan
- 37
- 7
-
1An `onEdit(e)` [simple trigger](https://developers.google.com/apps-script/guides/triggers) cannot use external resources. You need an [installable trigger](https://developers.google.com/apps-script/guides/triggers/installable). – doubleunary Dec 21 '21 at 09:37
-
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. – Tyler2P Dec 21 '21 at 10:02