I'm using a formula-URL field to do an on-demand email and it looks a bit like this. At the end, I want to show the URL for the current record. I've looked at dozens of formula-URL suggestions and can't find an answer. Can you help me correctly generate either/or:
1. A link to the record that spawns the email from the Formula-URL field or
2. A link to edit the record that spawns the email from the Formula-URL field.
Thank you in advance!
"mailto:" & "firstname.lastname@example.org"&
"?cc=" & "email@example.com"&
"&subject=" &[Email Subject Line] &
& "Hello," & "%0A%0A"
& "Blah, blah, content" & "%0A%0A"
& "Please copy this link into your browser to see the full request: " & URLRoot() & "db/" & Dbid() & "?a=er&rid=" & ToText([Record ID#]) &"%0A%0A"