Synchronization issues between google sheet and glideapps

I’m having several sync issues between google sheete and glideapps.
Introduction: I have a google sheet that is populated via a google form.
When I try to insert the data into the glide table both manually and using the appropriate form in the add row component it doesn’t synchronize, maybe I’m doing something wrong?

Which plan do you have? Do you have a plan that supports google sheets sync? Is your table icon black or green.

I have had the legacy starter plan for several years.

I just discovered something by chance.
Synchronization from glide to googlesheet occurs but the data can be found on line 50115… :scream:

Do you have any arrayformulas in your Google Sheet?

2 Likes

more than one…
is it a problem?

No, but you’ll want to make sure you delete any extra rows in every sheet. You also might want to modify the formula to account for blanks. I usually use

={“Column”;IFERROR(ARRAYFORMULA(if(len(A2:A),TRUE,)))}
2 Likes

I deleted the thousands of lines, but in the afternoon, another 30,000 lines formed…very strange, what could it depend on?

Did you adjust your arrayformulas as Bob suggested?

1 Like

Yes, in the end in addition to the arrey it depended on a formula that started from line 2 and created synchronization problems because it went one line further, something has settled down even if today 500 empty lines reappeared after two days

What do you mean by “went one line further”? Can you show us the set of formula you’re using?