Link pulled into a Formlula Rich Text not working correctly
Hello, I have a formula rich text field which is acting as the body of an automated email that's intended to be sent out to clients. However the link that is being pulled through isn't working, ...
This tested OK for me and I got your form to load.
var text URL = "https://quickbase.formengine.com/#!/render-dynamic?templateId=cc15f538-2b42-412c-9e90-5c1a7010075e&action=update&rids={\"3972ef33-9766-46f8-9b17-fd26ceadf75a\": \"5\"}&connection={\"userToken\": \"b74e79_p8qn_0_d8f7n9dbq83rqcddux2hkb2mchwr\",\"realm\": \"paystream\"}";
var text Hyperlink =
"<a href=" & $URL & ">" & "Click here" & "</a>";
"Hi " & "Mark" & ",<br>\n<br>\nPlease find below a link to your " & "Compliance" &" Personal Tax Questionnaire.<br>\n<br>\n"& "Questionaire" &"<br>\n<br>\nPlease allow a minute for the form to load. " & $Hyperlink
You will see that I added backslashes ahead if each quote in the URL so they would not be seen as normal quotes, but just part of the string. I replaced your fields in the words with hard coded text so you will need to revert this back to your own fields.
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------
Hi Mark, that's great. The link works fine now in a new field [Questionnaire Link for Emails].
The hyperlink isn't working for some reason though, it's just treating the whole formula as part of the url. I've tried creating a new Formula URL field for it too, and that's doing the same thing.
I've tried:
var text Hyperlink = "<a href=" & [Questionniare Link for Emails] & ">" & "Click here" & "</a>";
And it's giving an "Expecting Text" error. I've tried it with entering entering the entire URL where [Questionnaire Link for Emails] is and that does the same.
If I delete the semi-colon the error goes away but the link doesn't work.
If I save it with the error it just shows as this:
But the link is broken.
What I've done is the part of the link that changes depending on the record is the Questionnaire ID Text, so in the link for emails I've typed out the URL as you have above, but inserted that field at the point where it needs to change from client to client, then continued with the url free typed beyond that point. So the link for Email is working fine now.
I'll keep having a play around with that, the more important part is the link working.
Thanks a lot for your help with that.
------------------------------ Joe Alderson ------------------------------
The field type should be Formula Rich Text. It is not quite clear to me from your latest post what the problem is, but if you post a copy and paste of your current formula (not a screen shot) and confirm that it's in a Rich Text Formula field type, then I can help you debug it.
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------
