Concurrent users for a GAS web app

[Emile]

Hi all,

I'm currently creating a webapp that reads and writes to a Google Sheet. This works fine when one user is on it - however this app will get used by up to 20 people, potentially concurrently. This is an issue. For example, if a second user were to start using the app, their data would then start overwriting the first user's. I've come across the following potential solutions:

1. Making use of the LockService to force only one person to use the app at a time (not ideal since the app would be used for quoting customers and don't really want to keep users waiting).

2. Multithreading

3. Stacks

I'm not sure how 2 or 3 would work, or even possible in GAS. Could anyone please shed some light on if it is possible to facilitate multiple users, and how?

Thanks in advance