August 17, 200520 yr In the UK we have the following types of telephone number London 020 7694 1234 020 8694 1234 Rest of the UK 01642 294 878 or 0870 133 2064 How can filemaker know whether it is a London number or the rest of the UK and insert the spaces as shown below automatically? London (020) 7694 1234 Rest of UK (01642) 294 878 If anyone can help me I would be very grateful. Thanks Martin
August 17, 200520 yr Take a look at Business Tracker. They use 2 custom functions that determine the phone number format by location.
Create an account or sign in to comment