You are viewing limited content. For full access, please sign in.

Question

Question

Forms' currency fields from a database

Forms
Updated December 10, 2014
asked on December 10, 2014

Hi ,

I have this form which needs to pull the annual rates from the database. I tried using both 'money' as well as numeric(20,4) for the database columns. But it only seems to be pulling 2 digit or 1 digit values like xx.xx or x.xx.

It is not populating the form field with three digit values.  The form field is set to type currency. 

I have attached the screenshot to show how only two digit currencies are being filled in the form and the rest of the fields do not show any data, despite the database columns having data. Also attached the snapshot of the database.    

 

Thanks,

Shraddha

0 0

Answer

SELECTED ANSWER
replied on December 10, 2014

The currency field in Forms only allow two digits after the decimal, if it is more than 2 digits, it will be treat as invalid, so it won't be filled. You can use single line field type if you want to support more than 2 digits.

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...