Multiple Hyperlinked URLs in One Cell in Google Sheet to Translate onto AppSheets

[daltonlam]

Hello, 

In my Google Sheet, I have multiple hyperlinks in a given cell. How do I get all of these hyperlinks in one cell to translate onto AppSheets as still hyperlinks and all separate clickable links? I have already tried doing Enumlist with a base being URL but still having difficulty. Ideally I would like to keep the hyperlinks in the Google Sheet Cell but don't mind having the document name: then URL. The biggest thing would be having clickable URLs on the app reading the document name attached to the URL on the Google Sheet but I do not want any actual URL strings to be in the AppSheet as those are quite long.  I tried a few expressions but they still have not worked either. Looking for a few solutions understanding that AppSheets cannot read multiple hyperlinks in one given cell and that expressions or workarounds may be needed. 

[Tijesuni]

Since AppSheet does not natively support multiple hyperlinks in a single cell while preserving their display names, you’ll need a workaround. Here are a few approaches:

Solution 1: Separate Columns for Each Hyperlink

If the number of hyperlinks per row is relatively consistent (e.g., 3-5 links per entry), the easiest way is to store each hyperlink in a separate column:

Google Sheets Format

ID	Link 1 Name	Link 1 URL	Link 2 Name	Link 2 URL
1	Document A	https://linkA.com	Document B	https://linkB.com

AppSheet Setup

• In AppSheet, mark each URL column as URL type.

• Use HYPERLINK([Link 1 URL], [Link 1 Name]) as a Virtual Column to create clickable links.

• Repeat for each hyperlink.

Feel free to contact me if this  solution didn't work  there are more solutions to it but i believe it will work