I asked the question before, but I want to make sure.
recently i created a project on Google Apps Script through which employees of a company can know their salaries, and more than 2,000 thousand people will use it. The first question is: If the number of users of the project that I created increases, will it lead to the project being disrupted or causing any confusion in it? Secondly, I fear that Apps script will be stopped in the future and my project will collapse.
@icrew Can you help please
I'm not an expert by any means on this sort of thing--maybe ask on the Google Apps Script Community mailing list at https://groups.google.com/g/google-apps-script-community/about?
I do know that we use simple apps script based apps for a lot more than 2K users here at UC Berkeley, and they seem to hold up reasonably well, unless there are tons of folks all hitting it simultaneously. One key point for scaling is to make sure you're using a Standard Cloud project rather than just the Default Cloud project. See https://developers.google.com/apps-script/guides/cloud-platform-projects
Hope that helps!
The problem is not the amount of users but the real limit is the quotas that are bound to App Script, as the users increase you will most likely reach those quotas https://developers.google.com/apps-script/guides/services/quotas
I would say that if you intend for the code to be long lasting and scalable you might want to change from App Script to Cloud Run Functions:
https://cloud.google.com/functions?hl=en
Thank you, I have read more about quotas, but I did not understand much. My project that I designed is an interface that appears to the employees and is fed with information from a Google spreadsheet. When the employee writes his job number, the results appear to him in the form of a table, and thus he can know his grade, stage, job title, and so on. If more than 2000 employees do this process during the same day, will my quotas be bypassed and the project stop?
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |