Database Reference
In-Depth Information
With the
Self()
function, which takes no parameter, and therefore doesn't need its own set
of parentheses, you can write the calculation this way instead:
"(" &
Left ( Filter ( Self ; "0123456789" ) ; 3 ) &
") " &
Middle ( Filter ( Self; "0123456789" ) ; 4 ; 3 ) &
"-" &
Middle ( Filter ( Self ; "0123456789" ) ; 7 ; 4 )
The
Self()
function knows that it's referring to the field it's in, so you can copy and paste
this function until the digital cows come home, and you never have to edit it for its new con-
text. Good as it is, this calculation still has a couple of loopholes. See the box on
Field For-
matting Calculations
for another way to clean up stray data entry in a Phone field.
WARNING
Unfortunately,
Self()
doesn't work in every setting, script parameters (
Script Parameters
), for one.
When
Self()
won't work, FileMaker shows an error message.
