Hourly rate

[ttmail]

New to Filemaker so please apologise if this is a simple question.

 

I have a text box for hourly rate so before after I enter the wage say 6.19 I need it to return £6.19

 

The £ needs to be inserted automatically.

 

Thanks for your help

 

 

[jbante]

First, if you're entering currency data in a field, it should probably be a number-type field, not text. In layout mode, select the field and look at the Inspector Palette > Data tab > Format (at the bottom). In the numeric formatting options, select "currency," which will give you the option to select a currency symbol and limit a number of fractional digits to display. Note that this setting applies only to the presentation of that instance of the field on that layout, not the data stored in the field. We usually want it this way so that the value in the field doesn't confuse any calculations or other operations it might be used in.

[ttmail]

Hi Jbante 

Thanks for that works a treat.