Jump to content

Problem with comma in numeric field


This topic is 5777 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi,

In a portal I have a numeric field where the user inserts a value ("Price per piece"), usually something like 1,30. In the Invoice it will turn out as 13,00 (not what I want!).

If the value is inserted as 1.3 it turns out the way I want it to in the Invoice, ie 1,30. Obviously I want the user to be able to insert the value with a comma and not a dot.

Any help/suggestions are appreciated

Anders

Link to comment
Share on other sites

Set your file to always use current system settings (in File > File Options... > Text). Tell your user to set his/her OS number format to use comma as the decimal separator.

Alternatively, you could clone the file on a system set to use decimal comma (assuming the original was created under different settings), and set the clone to always use file's saved settings.

Link to comment
Share on other sites

Wow, thanks, it works - when I'm using FMP 8! Unfortunately the users working with this database are still stuck with FMP 5.5 - any way of reproducing this setting under 5.5? There doesn't seem to be any way of setting the file to use current system settings under 5.5... or is there?!

thanks

Anders

Link to comment
Share on other sites

I am not sure about 5.5, but if it's similar to version 4, then you should have a 'Use System Formats' option under the Format menu. There's also a 'Set Use System Formats' script step that you can include in your opening script.

In any case, cloning the file should work the same. I'd suggest you read the help on opening files with foreign system formats.

Link to comment
Share on other sites

This topic is 5777 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.