Google Sheets On Form Submit Event - Complete Code Before Next Submission -
i using on form submission trigger in google sheet created. problem having there chance form submitted quicker takes execute code, first submission interrupted.
ideally, complete execution first submission, , completes, begin on second submission. possible?
two options.
lockservice
or deal concurrency.
others have begun investigating using firebase alternative in-built lockservice due recent reliability issues.
personally latter option recommendation. i.e. have project cope multiple entry points @ uncontrollable times.
Comments
Post a Comment