URL & Text

[bob_evan]

I have a column in my data that contains a URL. When it displays the table in my app it also shows the full URL. How can I have the URL display as a customer text to click on instead of just the raw url.

[Marc_Dillon]

Add a new column that uses the HYPERLINK expression, referring to the original URL column.

help.appsheet.com

HYPERLINK()

New hyperlink

[bob_evan]

Do I put the hyperlink expression in the formula field for the new column?

[Marc_Dillon]

Possibly.

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

[bob_evan]

HYPERLINK([Tracking Number], “Click here”)

My URL’s are in a column called Tracking Number. THis does not seem to work when I use the formula in my new column field.

[Marc_Dillon]

Is it a real or virtual column? Do you know about the difference of when expressions are evaluated in real columns vs virtual columns?

[bob_evan]

This is a real column that contains the URL’s and a real column im trying to put the hyperlink code into.

[graham_howe]

If this is a real (non-virtual) column then an App formula expression will only recalculate when some other update is made to that row. If you want it to recalculate at any time then perhaps use a virtual column?

Update to add documentation link:

https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values

The bottom of that page mentions the common use of different columns and formula types.