Is there a limit to how many times me, and my staff, can sync and edit an google sheet trough my app?
Limit per minute? second? day?
Thanks a lot Jorge
No. Not to my knowledge.
Thanks Grant!
Basically you can set a ChangeCounter and use it as an Editable_if criteria. Canโt limit sync but can limit the edits with that @Jorge_Santos
Thanks Levent.
I have no problem with how many times the users sync.
I was worried that google had some kind of limitโฆ That was my problemโฆ
Cheers
@Jorge_Santos the only quota that Google has with the sheet is; - Max. 200 sheet tabs in a spreadsheet - Max. 2M cells (not rows) in total in a spreadsheet file
This 2M cells are counted as text values and blank values. If your spreadsheet cells include complex sheet formulas, than the quota drastically decreases. Therefore I suggest, you remove all the unwanted columns and rows from your base gSheet. You can delete the empty rows till the last datarow, as AppSheet always appends new rows to the table when adding a new record from the app.
Thanks!
In this app it we will never reach that kind of information volumeโฆ
Cheers!
EDIT: it appears that there is really no rate-limit here. (maybe Google didnt tell it eitherโฆ :-D)
see this post:
https://plus.google.com/116466377064499551355/posts/S8xQdBEYL15
There is a rate-limit but you wont be able to reach it, so nothing to worry about
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |