ContributionsMost RecentMost LikesSolutionsRe: Hyperlink in Rich text formula The original huge formula works perfect alone. I did end up figuring it out. I should have been linking the hyperlink from elsewhere in the form rather then trying to add it directly. ------------------------------ Rebecca Knecht, MS, ACSM-CEP ------------------------------ Re: Hyperlink in Rich text formulaI only added that one section unoriginal ally posted. The rest of the formula was already there and working. So it just need to bogies out why the one part is having a syntax error. Rebecca Knecht, MS ACSM-CEP Life Scan Wellness Centers Clinical Director 410-707-4726 Www.lifescanwellness.com Re: Hyperlink in Rich text formulaOkay thanks for trying I’ll reach out to my consultant! Rebecca Knecht, MS ACSM-CEP Life Scan Wellness Centers Clinical Director 410-707-4726 Www.lifescanwellness.com Re: Hyperlink in Rich text formula 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 ------------------------------ 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>") & Re: Hyperlink in Rich text formula Still saying syntax error and highlighting the period in redlinerescue.com 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 error when I try to add the formula for the url in. 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>","") & ------------------------------ Rebecca Knecht, MS, ACSM-CEP ------------------------------ SUmmary Report Formula I have a field labeled METs. Every record has a different number in there as it goes to the 100th decimal (i.e. 10.25) I want a report that groups them into <8.00 , 8.00-10.00, 10.00-12.00 , and >12.00. What fromula do I need to group the records into these four ranges? ------------------------------ Rebecca Knecht, MS, ACSM-CEP ------------------------------ Formula Code Page See attached, Reading results and signaure read INvalid when no selection is made in the field associated. Can I have it so it is just blank if no selection is made and fills in when one is? Example: Patient receives this form and it should be blank so someone can fill it out and fax it back to us. However sometimes our employees fill it out electrronically so in that case I want it to be filled in with our employees info. SO I want it blank when not fille dout but pull the field selection when it is. Code for that section is as follows <div class="col-3 bold underline">PPD TEST</div> <div class="col-3 ">LOT # {{$ctrl.ppdLot}}</div> <div class="col-6">EXP # {{$ctrl.ppdExp}}</div> <div class="col-3">TB(PPD) Administered by: </div><div class="col-2">Left Arm <span ng-show="$ctrl.ppdArm === 'Left Arm'">✓</span> </div> <div class="col-6">Right Arm <span ng-show="$ctrl.ppdArm === 'Right Arm'">✓</span> </div> <div class="col-3"> Date: {{$ctrl.ppdDate}} </div> <div class="col-8"> Time: {{$ctrl.ppdTime}} </div> <div class="col-3">Administered By:</div> <div class="col-4 bottom-b bold"> {{$ctrl.administeredBy}}</div> <div class="col-1"></div> <div class="col-4 bottom-b bold" style="font-family: 'dancing script',cursive; font-size: 1.5em;"> {{$ctrl.administeredBy}}</div> <div class="col-3"></div> <div class="col-4 center">PRINT NAME</div> <div class="col-1 center">/</div> <div class="col-4">SIGNATURE</div> </div> <div class="row medical-personnel bold marg-t-50"> <div class="col-5"><i>For Medical Personnel Reading Results</i></div> <div class="col-1.5">Date Read: </div> <div class="col-3 bottom-b">{{$ctrl.dateRead}}</div> <div class="col-4"> RESULT: Reaction: {{$ctrl.readReaction}}mm </div> <div class="col-1.5"> PPD is (Please indicate Positive or Negative): </div> <div class="col-3 bottom-b">{{$ctrl.readResult}}</div> <div class="col-12">Print Name, License Number, and Location of Medical Personnel Reading Results: </div> <div class="col-12 bottom-b" style="height: 20px;">{{$ctrl.readBy}}</div> <div class="col-12 bottom-b" style="height: 20px;"></div> <div class="col-4">Signature of Medical Personnel Reading Results:</div> <div class="col-6 bottom-b bold" style="font-family: 'dancing script',cursive; font-size: 1.5em;"> {{$ctrl.readBy}}</div> </div> <div class="row marg-t-50"> <div class="col-6 center bold"> FAX RESULTS TO: (813) 876-0653<br> OR<br> EMAIL TO: pinellas@lifescanwellness.com </div> <div class="col-6 "> Medical Director<br> Anthony L. Capasso, M.D. </div> </div> </div> <script> angular .module("ppd", []) .controller("AppCtrl", AppController) .service("QBService", QBService) .filter("trust", [ "$sce", function ($sce) { return function (htmlCode) { return $sce.trustAsHtml(htmlCode); }; } ]); function AppController($scope, $q, QBService) { var self = this; self.employer = BaseHelpers.getUrlParam("employer"); self.examDate = BaseHelpers.getUrlParam("examDate"); self.patientName = BaseHelpers.getUrlParam("patientName"); self.exposedToTB = BaseHelpers.getUrlParam("exposedToTB") self.tbVaccine = BaseHelpers.getUrlParam("tbVaccine") self.ppdSkinText = BaseHelpers.getUrlParam("ppdSkinText") self.tbYear = BaseHelpers.getUrlParam("tbYear") self.tbTreatment = BaseHelpers.getUrlParam("tbTreatment") self.tbMedicine = BaseHelpers.getUrlParam("tbMedicine") self.ppdLot = BaseHelpers.getUrlParam("ppdLot") self.ppdExp = BaseHelpers.getUrlParam("ppdExp") self.ppdArm = BaseHelpers.getUrlParam("ppdArm") self.ppdDate = BaseHelpers.getUrlParam("ppdDate") self.ppdTime = BaseHelpers.getUrlParam("ppdTime") self.administeredBy = BaseHelpers.getUrlParam("administeredBy") self.dateRead = BaseHelpers.getUrlParam("dateRead") self.readBy = BaseHelpers.getUrlParam("readBy") self.readResult = BaseHelpers.getUrlParam("readResult") self.readReaction = BaseHelpers.getUrlParam("readReaction") } function QBService($q) {var self = this; } </script> </body> </html> ------------------------------ Rebecca Knecht, MS, ACSM-CEP ------------------------------ Re: Look-up fields I wasnt able to figure out how to only display active ones but I was able to add the status to the picker so people can see if they are active or not which works. Thanks! ------------------------------ Rebecca Knecht, MS, ACSM-CEP ------------------------------