Hi ..

 

I am using Scribe to populate a PD with Acrofields.

One is a numeric field with defined with 0 decimals and a comma. ie. 15,000

It is used in a calculation, so it can't be defined as text.

If I manually enter the number using 15000, the field displays as expected ... 15,000

 

In FileMaker, the database field that will populate the field is also numeric.

If I simply use ScribeDocWriteValue( "field", $value )

The result in the PDF field is 15000.0

 

If I use ScribeDocWriteValue( "field", int($value) )

I get the same result.

 

If I change the database so the field is Text, ScribeDocWriteValue( "field", $value ) populates the field with 15000

but displays wrong in FileMaker App.

 

How do I get rid of the decimal when writing a numeric field?

 

Thanks

 

 

 

 

There are two potential issues in this case

 

1) The actual value

2) The formatting of the value on the layout in _THAT_ field.

 

The definition of the 0 decimals can only be done at the formatting pr field or merge field in layout AFAIK, not pr field,

unless you to a calculate of int( ScribeDocWriteValue( "field", $value ) ) in which would impact on the actual value; yet could be displayed as: 15'000.00000

Thanks for the post Gjermund

 

I'm not too worried about the layout field. I can force it's display to be correct.

 

If I tell scribe to send an int, the single decimal appears on the acrofield even though the acrofield is formatted with 0 decimals.

This may very likely be an issue with acrobat ... I'm not sure.

 

In any event, I'm avoiding the issue by having a second copy of the field on the PDF which is hidden. It will contain the numeric one used for calculation on the PDF.