Discussions

Expand all | Collapse all

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

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

    Posted 19 days ago
    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 field formula is currently:

    If([PO Submitted]=true, "<div style=\"height:20px;width:395px;padding:10px;color:black; font-size: 12pt; background-color:lightgreen;\"><b> This Purchase Order has been submitted to the Vendor on </b></div>")

    What would be the best way to do this - Do I create more html formatting an implement the date/time within that?


    ------------------------------
    Niraj Shah
    ------------------------------


  • 2.  RE: How to add a Date/Time field within the display text of a Rich Text Field

    Posted 19 days 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
    ------------------------------



  • 3.  RE: How to add a Date/Time field within the display text of a Rich Text Field

    Posted 18 days ago
    Thank you, Mark! It worked wonderfully.