Discussions

 View Only
  • 1.  HTML not working for including a field within a text

    Posted 08-07-2022 16:28
    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
    ------------------------------


  • 2.  RE: HTML not working for including a field within a text

    Posted 08-07-2022 19:44
    try this...

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

    ------------------------------
    Keith Jusas
    ------------------------------



  • 3.  RE: HTML not working for including a field within a text

    Posted 08-08-2022 08:54
    Thank you! Worked perfectly!

    ------------------------------
    Dawn Rene
    ------------------------------



  • 4.  RE: HTML not working for including a field within a text

    Posted 08-08-2022 01:08
    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
    ------------------------------