A few corrections.
When you Concatenate(), you aren’t making a text string, but a rich text that can contain links, @-refs etc.
_Deref() is marked as deprecated, but sometimes it’s the only way to work around code editor bugs. The editor becomes better though, so I find myself using deref less and less often. This here is not the case for it at all, though.
@Sean_Sloan:
Simply putting together a @ symbol and a piece of text won’t make it a reference. Besides, @-references can only reference rows or people — not tables. What you experience when you type @ and then get a list of stuff to insert, including tables — it’s just a shortcut to insert a link.
If you want to get a clickable link to a table, you have to do it like this:
Hyperlink(TableName.Url())
and then you can concatenate that wherever.
If you want to dynamically insert links to different tables — you cannot do that by table name because table URLs are based on table IDs (e.g. grid--U4OGUK-dE) or _suXXX#_tuYYY short page/view ID pairs, but not names. You’ll probably have to make a separate table that will link each name to a table URL:
(either enter those URLs yourself or do this to get them more easily)
Then instead of just entering table names, you’ll have to select items from this table and use the selected item’s URL in your Hyperlink()
