Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
2 years ago

HTML not working for including a field within a text

I'm trying to pull in a field within text in a rich text formula field. New to html and QB rich text fields.

"<div style=\"font-size: 14px;font-weight:bold;\"align=\"center\">ABC, INC. CONSULTING AGREEMENT</div>"&"<br>"&

"<div style=\"font-size: 14px;\">Consulting Agreement (this Agreement) is made as of [Today] and is a binding agreement.</div>"

[Today] is the field I want to pull in but this actually puts "[Today]" in the field and not the actual date. Any ideas on where I went wrong? My [Today] formula field works perfectly. I want to be able to do the same with [Name] and [Address] within other text but thought I'd start with the date.

------------------------------
Dawn Rene
------------------------------
Formulas and functions
Tables and fields

3 Replies

Sort By
  • KeithJusas's avatar
    KeithJusas
    Qrew Captain
    2 years ago
    try this...

    "<div style=\"font-size: 14px;\">Consulting Agreement (this Agreement) is made as of " & [Today] & " and is a binding agreement.</div>"

    ------------------------------
    Keith Jusas
    ------------------------------
    • DawnRene3's avatar
      DawnRene3
      Qrew Trainee
      2 years ago
      Thank you! Worked perfectly!

      ------------------------------
      Dawn Rene
      ------------------------------
  • AdisKljajic's avatar
    AdisKljajic
    Qrew Trainee
    2 years ago
    Use the following format "&Today()&" it should work fine. Also you can format it using the following method "&ToDate(Now())&". I believe that should be sufficient.

    ------------------------------
    Adis Kljajic
    ------------------------------