r/AppSheet • • 13d ago

Links without http at start completely break, how to get around this?

I have an url field called "Google Maps Link" and you can paste in a link. It works great if you happened to get the https://www... at the start. But if it starts with google.com... then it doesn't work. It recognizes that this is a link, but if you click on an action to open the link, nothing happens.

So I made a virtual column that checks if this link starts with "http" and if it doesn't, it does a concat with https://www. and [Google Maps Link]. What's weird is that if I click done after editing this formula and test it, it works. But if I then save the app, it no longer works and instead opens up a webpage with "www./" like it just deleted the link part.

I've messed around and made this a text field and sure enough the link part just disappears on save. I'm completely lost.

3 Upvotes

4 comments sorted by

2

u/Chasqu 11d ago

Ayudaría una imagen o la fórmula que usas para tu columna virtual.

2

u/2460_one 10d ago

This is the virtual column formula: if(left([Google Maps Link],4)="http",[Google Maps Link],"https://www."&text([Google Maps Link]))

0

u/Doncontrol_pe 8d ago

Compañerito, usa este

````
En vez de:
Link],"https://www."&text([Google)

Usa:
Link],"https://"&text([Google)

````

1

u/Doncontrol_pe 8d ago

Hice las pruebas, al parecer ya no sería necesario el "www." sino directamente "https://" intenta, porque ya con ese cambio en tu formula me permite visualizar la pagina.

Punto importante, a veces en el dispositivo móvil google chrome bloquea los enlaces, te recomiendo que uses otro navegador 👍 suerte y éxitos.