How to link to a URL with custom text
This app shows how to link to a URL (e.g. https://www.appsheet.com) with custom link text (e.g. "Build an app").
Also see: tablet mode & fullscreen mode
How we built this app
To do this, we have a sheet with two columns, URL and Link Text. Then, we created a virtual column with the formula HYPERLINK([Url], [Link Text]). This creates a clickable hyperlink with the given URL and link text.
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.