Change Currency Symbol on Multiple Fields

Posted on 2013-09-22
Medium Priority
Last Modified: 2013-12-18
Hi Experts
I have a form which has in excess of 100 Currency Fields used in a quoting system. These fields have a $ currency symbol as set in the Control Tab of the properties of each field. Is there an easy (or quick) way to display these fields in the document with a different Currency Symbol, for example EUR (other than creating a copy of the form and having to change the properties of every currency field)?  I would like an end result of the user being able to select which currency to display (not concerned with conversions).
(Not sure if this is a simple solution, or there is a clever complex method, so happy to increase points if the latter is true.
Question by:an_cwc
  • 2
  • 2
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39516478
AFAIK the currency symbol is fetched from the O/S, in the International settings. If it isn't, there might be a currency setting in the quoting system (for it seems rather dangerous to me to change the symbol and not the values...).

Author Comment

ID: 39516504
Yes, I believe the currency is fetched from the O/S if you have "User Setting" selected for 'Use preferences from' on Control tab of properties of the field. However, if you select "Custom" instead of "User setting" then you can select the Currency Symbol from a drop down list. Also the quoting system is a customised database developed by me in lotus notes. If I can figure out how to easily change the curency symbol (without the method described above), then changing the values will be easy to change.
LVL 46

Assisted Solution

by:Sjef Bosman
Sjef Bosman earned 300 total points
ID: 39516992
You could try to modify the form using the R8.5+ Designer, using the source of the form (in XML). Since it's plain text, you can simply search the currency and replace it. IN theory that is, I never changed the currency symbol (but I changed other things that way).
LVL 11

Accepted Solution

larsberntrop earned 300 total points
ID: 39517117
If you want to use the standard number fields with the built in currency display of a number field and change all the currency symbols in one is to set the 'Preferences for display formatting':'Use preferences form' to 'User setting', not 'Custom'.  But note that this might require to close the notes client and start it again to pick up the change, so not very dynamic.

Another way would be to put all those fields in a subform, and use those in a Computed subform part of the form.
A computed subform is calculated upon opening the document, so when changing the currency, the displayed form should be closed and re-opened to display the other subform.
(You can still use DXL and use text-based search and replace to not have to edit all the fields)
This would require a separate subform for each chooseable currency, and the opening and closing of the form is again not very dynamic.

Another option is to computed for display fields displaying the currency symbol outside the fields, and remove the currency symbols from the current fields. This would be dynamic, but would change how the fields look.

Yet another option would be to use an XPage. In XPages the currency symbol can be dynamically computed, giving you the choice of wich symbol to display. Very dynamic, full control of layout, and you gain the experience to futureproof your Domino Designer knowledge, since XPages enables you to give your users solutions that in classic Designer are impossible.

Author Comment

ID: 39517171
At this stage I'm not too familiar with xml, DXL or XPages, so I have some work to do. Thank you for all the suggestions. Splitting the points as you've both helped.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question