Using %recLink% and %recID% in notifications

You should be able to make a formula HTML field to use on the Notification which will appear as Record ID#, but would actually be a link to the record.

var text Words = ToText([Record ID#]);
var text URL = urlroot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];

"<a href=" & $URL & ">" & $Words & "</a>"

As for accessing the actual record without logging in, that will only work if you have the application set to be open to everyone on the internet as you need access permission to view records.

The one exception to that is that if you are trying to link to the user to download a document, then then a file attachment field can be set to allow a download without have access to the app.  But the hyperlink for that would be different than what I provided.

I have an Everyone on the Internet role set up and able to View All Records.
I don't see Formula - HTML as an option in the field list.

:) sorry old habits.  That field type is now called formula Rich Text.  It was renamed by Quick Base about a year ago.

I created a Formula - Rich Text field but I'm not understanding how to complete the formula.

My URL is https://cokecbs.quickbase.com/db/bmyn95tvh

... but I wrote out the formula for you.

I pasted it in and it highlighted in yellow urlroot

Did it save OK though?

Ok, the yellow went away after I saved it. The email looks good, however, when I click on the link in the email it says QB can't understand the URL.

Can you post the resultant URL you see in the URL bar and also your formula?

https://cokecbs.quickbase.com/db/bmvzyxtgs%20&

var text Words = ToText([Record ID#]);
var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];

"<a href=" & $URL & ">" & $Words & "</a>