JoeAlderson
2 years agoQrew Member
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, only part of the address is acting as an actual link. it's appear as this:
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"}
The entirety of that is supposed to be a link to a Form Engine document clients should have to complete. You can copy and paste the entire thing into a browser, and it works, but clicking it doesn't load the page as it's only loading part of the link.
I cannot manually edit the link itself as that's pulling directly from another field, but is there anything I can put either side of the link to force Quickbase to read the entire string of text as one link and secondly, if I can, I would like yo hyperlink it so clients just see a couple of words i.e. Personal Tax Questionniare, rather than the entire link. Is that also possible?
How this is input into the formula rich text field itself is:
"Hi "&[Compliance work - First Name]&",<br>\n<br>\nPlease find below a link to your "&[Compliance work - Tax Year Ending]&" Personal Tax Questionnaire.<br>\n<br>\n"&[Personal Tax Questionnaire]&"<br>\n<br>\nPlease allow a minute for the form to load."
There is more text afterwards but it's not relevant to the issue. The link is pulling from [Personal Tax Questionnaire].
For further context there are 4 tables involved in the way this works. These are:
Compliance Work
Tasks
Emails
Questionnaires
The relationships between the tables are all working fine, the Form Engine link is to a form connected with the Questionnaires Table but ideally I want to be able to send it using the email templates from the Emails table.
Thanks,
Joe
------------------------------
Joe Alderson
------------------------------
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, only part of the address is acting as an actual link. it's appear as this:
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"}
The entirety of that is supposed to be a link to a Form Engine document clients should have to complete. You can copy and paste the entire thing into a browser, and it works, but clicking it doesn't load the page as it's only loading part of the link.
I cannot manually edit the link itself as that's pulling directly from another field, but is there anything I can put either side of the link to force Quickbase to read the entire string of text as one link and secondly, if I can, I would like yo hyperlink it so clients just see a couple of words i.e. Personal Tax Questionniare, rather than the entire link. Is that also possible?
How this is input into the formula rich text field itself is:
"Hi "&[Compliance work - First Name]&",<br>\n<br>\nPlease find below a link to your "&[Compliance work - Tax Year Ending]&" Personal Tax Questionnaire.<br>\n<br>\n"&[Personal Tax Questionnaire]&"<br>\n<br>\nPlease allow a minute for the form to load."
There is more text afterwards but it's not relevant to the issue. The link is pulling from [Personal Tax Questionnaire].
For further context there are 4 tables involved in the way this works. These are:
Compliance Work
Tasks
Emails
Questionnaires
The relationships between the tables are all working fine, the Form Engine link is to a form connected with the Questionnaires Table but ideally I want to be able to send it using the email templates from the Emails table.
Thanks,
Joe
------------------------------
Joe Alderson
------------------------------