Forum Discussion

JeffElliott's avatar
JeffElliott
Qrew Member
3 years ago

html with inserted field from QB

I'm trying to create a field in a Quickbase table that would have in the rich text SOURCE CODE an inserted field from the same table.

For example instead of "Joe Blow" in the line below.... it would be [Client Full Name] field result (whatever name was in that same record)

<p class="MsoNormal" style="line-height: normal;"><span style="font-size: 14px; font-family: Calibri;">Joe Blow,<br />

Can this be done?  

Jeff

------------------------------
Jeff Elliott
------------------------------
Formulas and functions
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    3 years ago
    Hi Jeff,

    If you are looking to stylize the value in a field that you are using to capture data in a formula field that is absolutely possible in a Rich Text field. You would actually be able to do that using a code like what you posted the trick is you just need to make sure your formula links all the pieces together. In this instance you would drop in your styling in quotation marks and then use an ampersand & between the styled sections and your field reference. A simple example of how you could do this would be:

    "<div style=\"background-color:yellow;\">" & [Client Full Name]  & "</div>"

    The only difference as you add more styling is just keeping it in order.

    ------------------------------
    Evan Martinez
    ------------------------------