Skip to main content
Question

HTML not working for including a field within a text

  • August 7, 2022
  • 0 replies
  • 56 views
Forum|alt.badge.img+5
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
------------------------------
This topic has been closed for replies.

KeithJusas
Forum|alt.badge.img+7
  • KeithJusas
  • Quickbase Alumni
  • August 7, 2022
try this...

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

------------------------------
Keith Jusas
------------------------------
  • AdisKljajic
  • Quickbase Alumni
  • August 8, 2022
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
------------------------------
Terms & ConditionsAccessibility statement