Hyperlink in Rich text formula
I am trying to make the following work.
If the check box PHQ follow-up is checked then this statement will appear and will have a clickable hyperlink to the URL(in yellow). I keep getting syntax er...
Forum Discussion
Still saying syntax error and highlighting the period in redlinerescue.com
MarkShnier__You
Qrew Legend
Qrew LegendI can't debug a small screen shot because it won't copy paste as text. :(
Can you copy paste the formula text into the Forum post.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- I just copy pasted what you said to try
If([PHQ Follow-up], "As Life Scan Wellness continues to enhance psychological testing and resources for mental health, we have screened and recommend for you to consider for fire service " & "<a href=" & redlinerescue.com & ">" & "Redline Rescue" & "</a>" & "or for law enforcement to gain access to resources through a partnership with UCF Restores. These links can provide accesses to culturally competent trained peer providers or therapists that can deliver sustainable healing." & "<br>") &
- MarkShnier__You
:)
In your original post you gave a screenshot which is pretty unreadable and then you copy paste or just a portion of your code. So the only code I tried to fix is the portion of the code that you posted b y copy paste.
If you're saying that the code has a syntax error, then you need to show me the entire code for the field because if you just actually took what I suggested that was only a small portion of your formula.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------The code is massive and all of it worked prior to adding the bit I copy pasted to you. but attached is a notepad with the code as i think it would be overwhelming to paste here.The part i pasted to you is the only thing i changed in the code. let me know if that works. Thank you!!
------------------------------
Rebecca Knecht, MS, ACSM-CEP
------------------------------