Forum Discussion

AngelRodriguez's avatar
AngelRodriguez
Qrew Assistant Captain
5 years ago

Rich text formula field does not show under rich text field options menu

Has anyone else experienced this as well? I haven't found any posts mentioning this, so I figured I'd ask here. I created two rich text fields, in hopes that I could add some HTML/CSS to each field, b...
Formulas and functions
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
You field appears to be a Rich Text (ie data entry) field type. 
It looks like you want to change the type to a Formula Rich Text field.

But be sure that is what you want, as when you do that if there is manual data entry in that field you will loose it when you change it to be a formula field type.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
AngelRodriguez's avatar
AngelRodriguez
Qrew Assistant Captain
5 years ago
I will have to reassess making the change if that's the case. I'm glad you mentioned that.

Thank you, Mark!

------------------------------
Angel Rodriguez
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Maybe you want to have a formula field which takes your data entry field and adds some hover text to it.  So you would use the formula w/ hover field  in view mode and on reports and then the data entry field in edit mode and grid edit.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • AngelRodriguez's avatar
      AngelRodriguez
      Qrew Assistant Captain
      5 years ago
      That sounds like a good option as well. 

      With that said, since the data entry part is on a form, would it make sense to create a second field (Formula - rich text) that takes the original text field, displays it in table view where it still allows me to add markup to field 2? For instance, field 1 shows on the form as a text multi-line field where users can enter data. Field 2 has a formula field that takes field 1's data, adds markup and some JavaScript and displays all records in table view, but only field 2 shows on the table with the formula rendered data?

      ------------------------------
      Angel Rodriguez
      ------------------------------
      • AngelRodriguez's avatar
        AngelRodriguez
        Qrew Assistant Captain
        5 years ago
        Mark, I decided to try the alternate solution I mentioned, with your help, of course, and it worked. Thanks again!

        ------------------------------
        Angel Rodriguez
        ------------------------------