DJP
January 7, 2023, 9:28pm
21
Hey, Andrey! The definition of a Sync from our Doc on Updates is below:
Syncs: When Glide reloads data from an external data source that has changed (e.g., Google Sheets, Excel), this counts as a Sync.
Is the data in your Google Sheet changing? This will cause syncs as Glide will reload the data from the external data source.
user19
January 7, 2023, 9:32pm
22
not much before (when i start this topic)
and not at all now. (but sync still appear)
@DJP Thank you for the clarification.
Uzo
January 7, 2023, 10:11pm
24
maybe you have the time now() function in GS… and your sheets are refreshing every hour?
user19
January 7, 2023, 11:10pm
26
GS - you mean google sheet or glide sheet?
in google i have no one calculation.
in glide - i have, but it’s not affect to sync.
Uzo
January 7, 2023, 11:13pm
27
GS (Google Sheets) GT (Glide Tables)
maybe you have extra syncs turned on in Glide settings?
so no Today() or Now() functions in GS?
then I have no idea… maybe a webhook? or trigger?
user19
January 8, 2023, 12:24am
28
report:
i add a row
it’s affect as: 1 add, 1 edit (all in case of app logic) and 2 sync.
then for 20 minutes and no any activity - 1 more sync
then add one more row:
1 add, 1 edit (all in case of app logic) and 3 sync
it’s looks like add - affect to sync.
Uzo
January 8, 2023, 12:31am
29
yes, after adding a row, Glide runs the second sync to update any GS computed columns… I noticed that… i guess, so you don’t need to wait for next auto sync,
user19
January 8, 2023, 1:00am
30
in settings - “normal”
in GS no one function
i have a webhook during add - but it’s not work with GS.
trigger? what do you mean?
user19
January 8, 2023, 1:10am
31
one more unexpected behavior:
in castom action used 2 setcolumn.
i run this action inside builder and… in usage appear 2 sync and 0 edits.
then i do same via app in usage appear 2 sync and 2 edits.
user19
January 8, 2023, 1:19am
32
in GS i remove 1 row = 2 sync
Uzo
January 8, 2023, 1:40am
33
when using editor, edits are not counted
david
January 8, 2023, 5:42pm
34
While you have a Google Sheet open in your browser, it is constantly sending updates to Glide. Does any of your data depend on the current time?
user19
January 8, 2023, 6:49pm
35
hi David.
“While you have a Google Sheet open in your browser, it is constantly sending updates to Glide.”
does it means that even if the result of calculation same as before - Glide count it as new information and add a sync?
“Does any of your data depend on the current time?”
no.
i remove all formulas. no one any more in GS. (i check all tables, even that not in Glide)
but again and again to each activity (add or edit) - appear sync.
if no activity (for now) - almost no new sync. (for 6 and half hours appear 2 sync)
once i add a row (just a minute ago) emmediately appear +2 sync
user19
January 8, 2023, 6:53pm
36
and little bit later +1 sync.
like a echo
david
January 9, 2023, 2:50am
37
Hmm, we will have to check our logs here.
We don’t count syncs when no data changes.
1 Like
user19
January 9, 2023, 8:10pm
38
Please chek it
for the day and one hour:
6 add
47 edit
40 sync - why?!
i have no any formulas in GS
i close all windows with that GS
i pay for 2500 updates, but in fact will use about half of it.
user19
January 9, 2023, 8:22pm
39
@david how can i send you a video with situation? i guess it can explaine extra sync, and give a key to find error.
david
January 9, 2023, 8:31pm
40
@user19 you can use loom and share it here. I think you should open a Support ticket and we can work with support team there.