Issue: Currency Fields on Form Engine forms don’t display trailing zeros, like the $544.50 amount below (this is due to a limitation in Quickbase’s API).

 

A close-up of a number Description automatically generated

 

This solution for this is to create a Formula-Rich Text field, and put this formula in it:

 

var number Currency = [NAME OF CURRENCY FIELD];

"$" &

If([NAME OF CURRENCY FIELD]=0,ToText("0.00"),

If([NAME OF CURRENCY FIELD]>0,

ToFormattedText([NAME OF CURRENCY FIELD],"comma_dot",3) &

If(not Contains(ToText($Currency),"."), ".00",

Length(Right(ToText($Currency), "."))=1,"0")))

 

NOTE: “Name of Currency Field” is the Currency Field that is missing the trailing zero.

 

Here is the resulting Formula-Rich Text field  in Quickbase, fixing the [Line Item Subtotal] currency field:

 

A screenshot of a computer Description automatically generated

 

The Formula – Rich Text field displays the currency values correctly:

 

A close-up of a number Description automatically generated