Forum Discussion

StephanieHarris's avatar
StephanieHarris
Qrew Assistant Captain
7 years ago

Formula Rich Text Fields

I can't find any resources out there to guide through the proper syntax for HTML in Rich Text fields.  I see that it's significantly different that what is allowed for Text boxes on forms.  I have been using text boxes directly on forms however I can't use dynamic form rules to control when or what Text boxes appear and I can if I make them Rich Text formula fields so that's what I would like to go with.  Below is the text I have directly on the form.  I have most of it translated to a Rich Text formula field, also see below (some text different), but I have had to make a lot of adjustments.  Any help would be appreciated.


Text box on form with HTML enabled:
<B><P style="color:steelblue; font-size: 20pt">Advisory & Assurance ? Cast Privileges Abuse Incident Submittal Form
</P></B>
<B><p style="color:indianred; font-size: 12pt"> Confidential Information - Do not retain copies of this form</b> </p>

<p style="color:gray; font-size: 11pt"> Use this form to consult with Advisory & Assurance (A&A) regarding or make A&A aware of possible abuses of Cast Privileges including Main Entrance Privileges and Cast Member discounts.<br>To expedite your request, complete the information below. The items marked with a star <b style="color:indianred">(*)</b> must be provided.</b> </br> Once a form is submitted an A&A Representative may contact you to further discuss the matter.</p>

Rich Text Formula field:
"<font color= steelblue><font size=6><B>" & " Advisory & Assurance - Incident Submittal Form" & "</B></font>\n\n<font color=indianred><font size=4><P><B>" & " Confidential Information - Do not retain copies of this form" & "</B></P></font>\n\n<font color=gray><font size=2>" & " Use this form to consult with Advisory & Assurance (A&A) regarding or make A&A aware of: Possible abuses of Cast Member Main Entrance Privileges, Cast Member Discounts, Potential Conflicts of Interests as well as forwarding Guidelines pertaining to A&A" & "</font>"

  • I'm sure there are a number of valid ways to do this, but I would do something like this:
    "<h2 style='color:steelblue;'>Advisory & Assurance - Incident Submittal Form</h2>" &  "<h3 style='color:indianred;'>Confidential Information - Do not retain copies of this form</h3>" &  "<p style='color:gray;'>Use this form to consult with Advisory & Assurance (A&A) regarding or make A&A aware of: Possible abuses of Cast Member Main Entrance Privileges, Cast Member Discounts, Potential Conflicts of Interests as well as forwarding Guidelines pertaining to A&A<p>"
  • SuryaExpert's avatar
    SuryaExpert
    Qrew Assistant Captain
    Stephanie,

    To your point about not being able to control what fields should appear etc on forms, you should use Dynamic Form Rules for that. That's what they exist for. Generally Formula Rich Text fields are used to display information in a neatly formatted manner like RTF (Rich Text Format). I am wondering why you want to display text boxes using RTF. What do you plan on doing with data entered there by your users? I am intrigued.