Building own URL Link to a Record in Email/SMS

Hey @sorin_mihai

Wrap your concatenate in a HYPERLINK() formula:

HYPERLINK(
  concatenate(
    {formula bits here}
  ),
  "Visible Text"
)
1 Like

it’s not working … I guess it has something to do with the fact that the Hyperlink() expects both parts of the formula in quotes, but the Concatenate part is not in quotes.
I tried adding them but if I just add quotes, they end on the first quotes in the concatenate formula and that’s no good / tried adding the other kind of quotes but no good and then I tried adding " ’ “& concatenate (…)&” ’ " but still not working.
Any other ideas?

When I ran into this issue just the other week, instead of building my own link I used <<_ROW_WEB_LINK>>.

  • Renders as “Click Here”
  • Takes the person directly to the record inside the app