Hello,
I currently have a couple of apps published, meant to be used across our distribution network or by our customer service team (respectively).
One is a single-step app that appends an Excel file. All records need to be retained. A team of about 40 will have access to this, and while it won't be used with intense frequency, there is the chance of users being in the app at the same time.
The other is a 4-step chained app, which alters the aforementioned Excel file. Only about 10 people would have access to this one, but again, there is a chance more than one user would attempt to access at the same time.
To compound this, our server is insanely slow, and jobs are queued up for way too much time (I'm trying desperately to push for improvements there).
So, a couple of questions:
1: If more than one user is using the app, and another tries to access it, will it allow them?
1a: If yes, will one of them be prevented from appending the Excel file?
1b: If yes, will the app error out for them, or will some data just be lost without a trace?
2: If the default is to allow multiple users to access the app, and if the results would potentially lead to lost data, then is there a way to block user access if someone else is accessing the app?
3: Since both apps read from and write to the same Excel file, is it very likely I could lose data if both apps are being used simultaneously?
I haven't been able to find much online regarding the back-end behavior, so I'm hoping the community can help.
Thank you,
Molly
