AnsweredAssumed Answered

Sugar Locic concatenating issue

Question asked by David Klingelheber on Apr 11, 2016

I have a text field with Sugar Logic that populates the field.  The formula looks like this:

concat($field1,"literal1",$field2,$field3,"literal2")

Some of $field3 values are prefixed with a "0" (zero).  In create/edit mode, if the field is prefixed with a "0", the 1st "0" is lost.  Once the record is saved the correct value is displayed and saved on the record in the database.  For example, if $field3 has a value of "00", it would only show up as "0" but saved as "00" in the database and displayed as "00" after the record was saved.

 

Anybody come across this issue and know of a work around?

Outcomes