I am using Google sheet to receive data from ODK Collect v1.22.4 from 60 users who submit 1 to 2 forms daily. There is an app script which enters serial numbers in the Google sheets in a particular column triggered by the "On change" event providing a unique id for each record (row). I am not sure how Google sheets or ODK handles concurrency. Will there be a problem in running the script when two or more users simultaneously submit their forms? Thank you in advance
it shouldn't cause any conflicts. I tested sending 10+ forms to google sheets and ran a script (which should add updated word to each cell in the second column), while sending 4th and the result was:
so it looks fine.
1 Like