AnsweredAssumed Answered

Newbie Having difficulty following instructions

Question asked by TimG on Jan 17, 2010
Latest reply on Jan 17, 2010 by TimG

Title

Newbie Having difficulty following instructions

Post

Hi everyone:

 

I am trying to format my phone numbers so that is looks like this. (###) ###-####

 

Here are the directions I am trying to follow. Answer #3516

Here is the url. 

http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=3516&p_created=1115172726&p_sid=fa7DaeSj&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9MTgsMTgmcF9wcm9kcz04NjQmcF9jYXRzPSZwX3B2PTEuODY0JnBfY3Y9JnBfcHNfYW5zX3VwZGF0ZWQ9JnBfcGFnZT0xJnBfc2VhcmNoX3RleHQ9Zm9ybWF0IHBob25l&p_li=&p_topview=1

 

Here are the instructions.

 

Data entry into certain types of fields can be significantly automated by using field filters to supply standardized formatting automatically. Two examples of such fields are phone number and social security fields. With a phone number entry, the parenthesis around the area code and the hyphen between the first three and last  four digits of the phone number can be automatically supplied. In the case of a social security number, hyphens are typically used in the following standard format: 123-45-6789.

Create a calculation field that supplies the formatting, place the calculation field directly over the data entry field, and set the calculation field so that entry is not allowed using the Field Format dialog. This combination of fields allows data entry either by tabbing or clicking into the field, and shows the formatting as soon as the next data entry field is tabbed to.

For example, let's create a phone number field filter.  (A ^ in any of the following formulae denotes a space.)

1. Create two fields:
PhoneNumber, a text field.
PhoneNumberFilter, a calculation field resulting in text with the formula, "(" & left(PhoneNumber,3) & ")^ " & middle(PhoneNumber,4,3) & "-" & right(PhoneNumber,4)

2. Place the PhoneNumber field on a data entry layout. Make sure the option to allow entry into field in the Field Format dialog is checked.

3. Place the PhoneNumberFilter field on the layout. Make sure the option to allow entry into field in the Field Format dialog is NOT checked and that the fill color is set to white. Move the field so that is exactly on top of the PhoneNumber field.

4. Return to Browse mode, try creating entering or changing some phone numbers. Note that clicking into the field is just like clicking into a standard data entry field. Note that the formatting is automatically supplied as soon as the field is exited.

5. Remember that any report layouts that use the phone number field should actually use the PhoneNumberFilter field.

In all current versions of FileMaker, the filtered text will not appear until after clicking out of the text entry field to commit the data entry

 

Problems I am encountering.

When I follow these instructions I get a blank box that does not mask the phone numbers. Instead the phone numbers are now hidde3n and they will quickly show for a second when cycling thru records, however then it is covered by the PhoneNumberFilter field which I created and placed over the PhoneNumber fiel.

 

I think my problem is I am not following these directions accurately. Here are the issues.

2.  Place the PhoneNumber field on a data entry layout. Make sure the option to allow entry into field in the Field Format dialog is checked. I amassuming this is in the Manage > Database options for PhoneNumber and I would check "Allow user to override data entry. I think I have this wrong.

3.  Place the PhoneNumberFilter field on the layout. Make sure the option to allow entry into field in the Field Format dialog is NOT checked and that the fill color is set to white. Move the field so that is exactly on top of the PhoneNumber field.

 

Again I am assuming this is in Manage > Database options for the PhoneNumberFilter field.

 

Everything else I seem to be okay on. I am new to this and have read "The Missing Manual" as well as the real manual and watched most of the videos but I am still having trouble with this. Can anyone help please.

 

Thank you.

 

Tim G.

Outcomes