Adobe LiveCycle (Archived)

cardgunner · 6/9/10

I have created a form and have numeric fields. I can fill in this form, in these fields, with a negative number. Once I save the document, close it, and open it back up the negative number has been replaced with a 0. I have tried changing the Data format from float to integer and also to decimal and still the form doesn't save the negative number. My Default binding is "normal". Any help would be appreciated.

Thanks.

cardgunner

Report · 6/9/10

Yes that is exactly how it works. There might have been something wrong with your data pattern I did not look that closely .....I merely removed it and the

display format was working when it opened again.

I defined it as a float and it worked.

Paul

View solution in original post

Srini_Dhulipall · 6/9/10

May be you are using a display Pattern which is converting the negative number to 0.

Thanks

Srini

cardgunner · 6/9/10

my display patteren is $ZZ,ZZZ,ZZ9.99.

Report · 6/9/10

Is the field calculated or are you placing a value in there? Are other fields showing the proper data in them?

paul

cardgunner · 6/9/10

It is a User Entered-Optional value type.

When the binding data format is set to integer I do get the value to stay however when I open the document i get the error stating "Invalis value:'$- 200.00' for integer' property

Report · 6/9/10

I just created a form here and cannot duplicate the issue....can you send me your form and I will have a look.

Send it to LiveCycle8@gmail.com

Paul

cardgunner · 6/9/10

Thanks Paul. I sent it along to you.

What Binding Data Format would normally be used for a numeric field that will hold both positive and negative numbers?

Report · 6/9/10

The binding has nothing to do with the content of the field ....it simply defines whether you want to store the field in the data dom (which is what is used to submit) and what node in the data dom to write the data into.

Hope that helps

Paul

cardgunner · 6/9/10

Isn't this very similiar to a form on a db? The information can be entered and shown on the form in a certain way however you would like it stored in the forms underling table a different way.

Such as phone numbers. I may want it displayed as (123) 456-7891 however it should be stored in the document as 1234567891. Then when they submit it i get it as 1234567891. But when I open it in it's form it comes back as (123) 456-7891

That being said should currency be stored as a float or an integer?

Report · 6/9/10

Yes that is exactly how it works. There might have been something wrong with your data pattern I did not look that closely .....I merely removed it and the

display format was working when it opened again.

I defined it as a float and it worked.

Paul

Report · 6/9/10

Also because you are using a currency you may want to use the decimal field ...you might find that easier.

Paul

cardgunner · 6/9/10

Paul,

You are a correct! Why I was wanting the store the info in that pattern is beyond me, but I took the pattern off and WHAM it works.

Thank you. I fell kinda stupid for having not tried that hours and hours ago.

Thanks again.

cardgunner · 6/9/10

"Also because you are using a currency you may want to use the decimal field ...you might find that easier"

...really? This is my first form. Are you saying create 2 fields in the form one to capture the whole figure and the other to capure the change? or is there a field like a numeric or text called decimal?

Report · 6/9/10

No No ...the decimal field will hold the whole currency amount it is really a floating field with a specific pattern applied but it allows you to click on check boxes and makes it easier for you the Designer to build the pattern without having to know about patterns.

paul

Srini_Dhulipall · 6/9/10

There is a Type of field called Decimal Field in LiveCycle. Just like Numberic Field /Text Field. You can add a Decimal Field to the form (OR) selecte the current field and in the properties change the type to Decimal Field.