Forum Discussion

NirajShah4's avatar
NirajShah4
Qrew Cadet
5 years ago

How to add a Date/Time field within the display text of a Rich Text Field

I want to be able to add the date/time field shown below to the right to the rich text field I have to the left: I'm not sure how to add it to the display text of my rich text field; the ...
Formulas and functions
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
try tbhis

If([PO Submitted]=true, "<div style=\"height:20px;width:395px;padding:10px;color:black; font-size: 12pt; background-color:lightgreen;\"><b>" & ToText([my date / time field]) &  "</b></div>")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
NirajShah4's avatar
NirajShah4
Qrew Cadet
5 years ago
Thank you, Mark! It worked wonderfully.
ᐧ