Hi, thank you for your video! I have some problems when using the lock (maybe??). What I am doing is collecting data from Google Form, and input the data inside Google Sheet, by Apps Script. It creates a table with all data input by user(as some questions are optional) under the last row of Google Sheet, it will trigger after receiving submission. When only one user submits the form, it works totally fine. But when multiple users submit the form at the same time, it will replace some data. That's why I am here! After I used the lock service, it solved the problem of replacing data. However, it created two tables which contains the same data!!! (always User2 data) I am guessing if the reason is that when I did the form.getResponses, it had some delay and always get the latest(i.e. second user), so it created two tables of same data? Any suggestions on what I should be aware of? Thank you!
Great tutorial, really helpful thank you, David :)
Thank you!
Nice video Keep it up. For like one year you will get around 5k subs next 2nd year around 25k and then it will sky high.
thank you very much
Hi, thank you for your video!
I have some problems when using the lock (maybe??).
What I am doing is collecting data from Google Form, and input the data inside Google Sheet, by Apps Script.
It creates a table with all data input by user(as some questions are optional) under the last row of Google Sheet, it will trigger after receiving submission.
When only one user submits the form, it works totally fine.
But when multiple users submit the form at the same time, it will replace some data. That's why I am here!
After I used the lock service, it solved the problem of replacing data. However, it created two tables which contains the same data!!! (always User2 data)
I am guessing if the reason is that when I did the form.getResponses, it had some delay and always get the latest(i.e. second user), so it created two tables of same data?
Any suggestions on what I should be aware of? Thank you!
How to prevent multiple users from opening a Google sheet simultaneously using onOpen and getDocumentLock