sorry - the formatting side. Then, you format your fields to your requirements using the Inspector in Layout mode.
Inspector>Data tab>Data formatting ... Format Currency.
I want to automatically include the $, comma and decimal point.
Results should look like this.
I am using FileMaker 7. Where do I find Inspector? I don't see it here.
in layout mode, try right-clicking on the number field and selecting Format Number - I think ... it's been a long time.
product documentation will be beneficial here. you can download (as pdf) the user guides)
jehjeh, the FileMaker 7 is not used much here, but we know there are some solutions still out there!
The Tutorial and the User Guide are probably the best place for FM 7 answers.
the guide p.56, for example says this:
Formatting field data on a layout
You can control how FileMaker Pro displays the values in number fields, calculation fields with numeric results, and summary fields.
1. In Layout mode, select one or more fields that display numeric values.
2. Choose Format menu > Number.
3. In the Number Format dialog box, select the formats you want to use.
The "Format" menu (while in Layout mode) is what you seek. The dialog allows you to format as decimal and include the $ and comma. While the actual data in the field does not change, only the format you specify will be shown.
I was able to find the number format window and get it to work properly except for the 2 digits after the decimal point. If you enter enter a number it makes everything after the decimal point .00 and I need it to be the cents at that point. i.e. if I type in 434, I would like it to show up as $4.34. What happens is that it shows up as $434.00. Is there a way to do this?
well, I think you'd need a calculated field to convert 434 cents to 4.34 dollars in order for it to be formatted with FM formatting. Somebody else might have a better solution ... just wait a bit.
It may take some research. Perhaps you can have an "entry field" and then a calculation of the field entered which would be division by 100. But what if the user enters the decimal? then you need to test for that.
Give us some more examples and perhaps we can check the old functions (FM7) to see what might work. But give all the possibilities, so that we can be more thorough!
Hi Beverly, I thought of checking the entry. But what if the operator entered 434 meaning $434.00? I was working on this when I thought of that possibility ...
you could also use Field Definition>Auto-Enter calculated value to convert
If(PatternCount(GetAsText(Self); ".") > 0;
Self / 100
I have discovered that if you type 434 you get $434.00, if you type 43412 you get $43,412.00. However if you type 434.12 you get $434.12.
yes! the assumption is that the value is whole numbers, unless a decimal is entered.