Have the LinkText show up as the label in a detailed view instead of the url

[HeathBiller]

Hi,

I have a data field where I have put the type as "URL" and have selected "Is Hyperlink" in the type details. This works great except that I want this to also be the Label. When viewing the details page in the app it is showing the URL instead of the LinkText. Is there a way to have the Label show up as the LinkText instead of the URL?

A screenshot is attached for reference. Thank you.

[Arni_Kli · Accepted solution]

@HeathBiller , you can make virtual column with LinkText and set it as label.

[HeathBiller]

@Arni_Kli Thank you. I like that idea. Any guidance on the formula to put into the virtual column for it to pull what the user inputs in as the LinkText for the URL?

[Arni_Kli]

@HeathBiller , the text could be correspond with other content/columns in the row where you can have relevant parts for LinkText. Assemble this parts by CONCATENATE().

[HeathBiller]

@Arni_Kli Thanks I was able to add a virtual column and set the formula as "LinkText(Households)" This works well when adding a link to a household that is already in the app.

Unfortunately, when I try adding a new household into the app with a new URL, the app is unable to sync and I receive the error message below. Not sure if you or someone else might know why this is happening?

[Arni_Kli]

@HeathBiller , please look for  https://support.google.com/appsheet/answer/10107911?sjid=14747516518018347153-EU

May be answer for your issue in HYPERLINK() and encoding.