Forum Discussion

RebeccaKnecht__

Qrew Member

Re: Hyperlink in Rich text formula

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>") &

10 Replies

MarkShnier__You
Qrew Legend
2 years ago
:)

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
------------------------------
- RebeccaKnecht__
  Qrew Member
  2 years ago
  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
  ------------------------------
  Email Code.txt37 KB
  - MarkShnier__You
    Qrew Legend
    2 years ago
    ... you may need some one on one consulting. I can't real'y debug a huge formula like that without access to the app.
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------