I am trying to change the currency format onchange of the currency field and onsubmit of the form. Currently my currency field format is: £###,###,###.## and I would like to remove the decimal point on change of field as well as when the user tries to submit the form.
For eg: 4545 entered on the field should save it as: £4,545.
May a script to return a substring of the the field value until the index of dot, would work?
This post had a similar requirement : community.progress.com/.../53437.aspx
I tried that but On clicking the save, it retains the currency format. How do I change it on Save?
There is an onblur function which is automatically added on currency fields. Unfortunately you cannot remove it directly from the event component of the field. You can however remove it by adding the code below on your script component:
//code to replace your onblur code here
While this code removes the client-side formatting, the format will still be the same upon saving the value. I believe a server-side code is formatting the value.
Godfrey Sorita : I can get the onblur/ onchange to work but the format on saving is still not getting saved properly. It retains the format that it has from the field definition. I tried a trigger to update that field value but it doesn't work. Any suggestions?
The value stored in database is always without formatting. Because the field has a format set, any place the value is processed and rendered the formatting specified on the field definition applies. For custom formats, use the way suggested by Godfrey
We are using Private Cloud. Is there a setting we could change to add it to the list of currency format?
I dont think there is a way to put in a custom currency format at the moment. (Its pretty much a hard coded list)
In 3.2 we are working on enhancing the list of currency formats Rollbase provides.
Could you possibly let me know as to when is 3.2 due to release please?
Could you please confirm whether you'd be providing this format in that list: £###,###,### ? (without the decimal).
We are currently consolidating a list of formats we want to put in. We will take this as one of the inputs.