Is there a limit to how many times me, and my...

(Jorge Santos) #1

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

(Grant Stead) #2

No. Not to my knowledge.

(Jorge Santos) #3

@Grant_Stead

Thanks Grant!

(Levent KULAÇOĞLU) #4

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

(Jorge Santos) #5

@Levent_KULACOGLU

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

(Levent KULAÇOĞLU) #6

@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.

(Jorge Santos) #7

Thanks!

In this app it we will never reach that kind of information volume…

Cheers! :slight_smile:

(Jonas /) #8

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 :slight_smile: