AnsweredAssumed Answered

Australia formats

Question asked by ajayz on May 3, 2012
Latest reply on May 3, 2012 by ajayz

In Australia we use the following formats and I would like help on how to set these up for my Filemaker database. All values are set to TEXT and I know I would need to use a calulations, but not too sure how to write it.

 

Formats required:

 

a) ABN is the company registation number and is a number that needs to be formatted as: 00-000-000-000

 

b) ACN numbers similar to the above but formatted as: 000-000-000

 

d) Mobile phones numbers are formatted as 0000-000-000

 

e) Phone numbers are formatted as: 00-0000-0000

 

I've only been using FileMaker Pro 12 for one month and all my database development has been with MS Access, I'm trying to make the change and I find formatting is a very difficult thing to do in FileMaker.

 

Thank you for your help.

Outcomes