Hi Dave,
Looks like your idea will work also. It does involve going into define
field to change that last part of the calculation to display (using the
MIDDLE command) to add the additional character. The hyphens don't bother
me much either way.
It might be nice to know if any of this is being addressed in Ver 2 and
how it is being done. I hope they are adding more consideration for
international numbers, etc. The dialers on the home screen are US domestic
only also. If I set this up and Ver 2 is doing it differently it could
make conversion a bit challenging.
Does anyone that knows Ver 2 know the answer to the above?
David Rodgers
Institute for Individual and World Peace
> >What is the proper way to enter international telephone numbers.
>
> If you have a bunch of these it might be worth changing the
> validation criterion of the phone number field to accept 8 digits.
> You would also have to change the display field to put the hyphen in
> the right place. This works only if you have FileMaker, and can
> change the layouts and field definitions.
>
> >Take for
> >instance we have Australian numbers that have the format:
> >
> >61 - 2 - 1234 - 5678
> >
> >61 is the Country code (in the US it is 1)
> >2 is the city code (US area code equivelent)
> >the last 8 digits are is the telphone number (7 digits in the US)
> >
> >So the end result is I end up with one more number than will fit into the
> >field. In some countries the city code is two digits so I would have even
> >more.
> >
> >One way I can see to enter this and to see the result on the HOME screen
> >is to put the country code (62) the city code (2) and number of the eight
> >digit telephone number into thethe HOME AREA CODE field and then change
> >the HOME layout to extend HOME PHONE field display size to show all the
> >numbers.
> >
> >I can't add the 8 digit number into the HOME TELEPHONE NUMBER field
> >because it only excepts 7 digits in the current layout.
> >
> >Is there a better way? Has someone figured this out yet?
> >
> >David Rodgers
> >Institute for Individual and World Peace
> >
> >------------------
> >Reminder to each recipient: To change your list account preferences, go to
> >http://email.sparklist.com/scripts/lyris.pl?enter=support and enter
> >the email address you used to subscribe to the ebase support list::
> >[EMAIL PROTECTED]
> >
> >To unsubscribe send a blank email to [EMAIL PROTECTED]
> >---------------------------------------------------------------------
> > ebase - Relationship Management for Nonprofits, http://www.ebase.org
> >---------------------------------------------------------------------
>
> --
> --
> Dave Shaw H4 Consulting
> tel: 206-954-7526 fax: 206-625-1338
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------