I made some important bug corrections yesterday and some small layout changes.
The most important one: the url shortener would get an error if you input an url without “http://“ or “https://“, now i’ve implemented a formula to check if the link starts with http and automatically add it if not.
Hey @Roberto_Salim, thanks!! Sure, it’s a little bit hacky but works. I’ve changed the loin to public with email and added the option to use google login, than i loged in with my account and changed the privacy to public. Now, when i add a login button, it uses the configuration from the public with email.
Regarding the discussion on Twitter with @eltintero and me, I found a working solution with TinyURL so I think it might help.
Here’s my sheet for testing with TinyURL. Input any link to ColumnA to get the TinyURL link in column B.
Script also copy the value back to the same cell right after the formula runs to prevent multiple runs at the same time from IMPORTDATA when the user reloads the sheet, which might cause a bug/exceed script limit.
Thank you @ThinhDinh! I will test it later. I have just another question, I’ve made some changes to the script (the one from your tutorial) and now I’m using importxml to import domain data (Seems more reliable than import json).
But, I’m having some problems:
Do you Know if there is a way to transform the cells using formula into text? My hypothesis is that this could speed up the app (Probably need to keep at least one row with the formula to use it with autofill.)
The biggest problem now is handling autofill with delete feature. If the user responsible for the last url chooses to delete it, the autofill script stop working because the row above would be empty. Do you any possible solution?
My pleasure brother, this is gonna be big for scripts that generate distance/reverse geocode. Previously it’s too “sensitive” and reloads everything when the user opens the sheet. They quickly reach the daily limit.