Hello, I know this is not a glide problem by itself but maybe somebody can help me with this. In my sheet I have a column Address (I) ,a column Coordinates (J) and a Backup Coordinates column (K).
I’m using a script to create a custom formula to calculate the coordinates from the address using Google localization services. In my Coordinates column (J) I have an array formula like this
=ARRAYFORMULA(IF(LEN(K2:K) > 0,K2:K,GEOCODE_GOOGLE(I2:I)))
So, if K has a value then I copy that value to my column else I use the GEOCODE custom formula. My problem is that I’m gettis this error:
Service Invoked too many times for one day: geocode. (line 5)
I know there are limits for the use of this service but my app only have like 20 or 30 new rows per day, so I think maybe the problem is in my arrayformula?, my sheet have 200 rows right now, so maybe the formula is executing 200 times every time a new row is inserted?
Please any help, thank you