Currency Fields

[DigitalDreamer]

I was wondering if someone could help me with a few currency fields i have in my run time solution. This is something that never really crossed my mind until a problem came up. I have a runtime solution with 2 or 3 number fields and they are used for currency fields. But what i noticed is when the users international settings are set to like United Kingdom or Europe the currency information is diplayed in US currency. Is there anything i can do to correct this in the future? Thanks for any suggestions you can give me. Take care.

Filemaker 6 Developer

Windows OS

[AudioFreak]

In layout mode you can go to Format/Number. Here you can select currency leading and also insert the symbol you would like to have. HTH

[DigitalDreamer]

Ok i see what you mean. So if this is a runtime solution i would need to make different versions for different countries? Thanks for your help.

[SteveB]

You don't really need multiple runtimes, which will be a headache.

Call the original field "mydollars". Place one or more calcs on top of this field. Each of these is a calculation that is formatted differently: one is dollars, one is pounds, francs, etc. Depending upon which country you're in, one of these calcs will display. On the number format screen (the one you use to select decimals, $, set the checkbox to not Display if the value is '0'.

You'll need a flag in your setup section that the user will set to whatever country he is in.

Each of these stacked calcs only has a value in the right country:

Case(country="UK", mydollars,0). So the UK format is zero, except in the UK.

You'll need to make the field transparent.

Steve

[DigitalDreamer]

That is exactly what i was looking for. The problem is i have no idea how to setup flags. Do you have a sample file that i could look at for flags? Or a link that describes this. Thanks alot for your help.

[SteveB]

You don't need an example...it's very simple. Define a global text field called 'gCountry'. If you get the user's name or other info, ask them what country they reside in, and save it in this field. If you don't collect any of this, as they run your solution for the first time (gCountry would be empty so you know it's the first time), ask them to pick their country from a value list.

Steve