The FileMaker GetAsText Function

From Dwayne Wright PMP
Certified FileMaker Developer

TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit or other formatting of the posting may fail. For the best experience, please visit the journal directly by clicking (here)

GetAsText( data)
FMP Version: FileMaker 7 and higher
Text, number, date and time information are stored differently and those differences can become very important in complex calculations. The GetAsText function looks at information that is stored in another format and converts it to text. When converted to text, then you can manipulate the text string with any of the text functions like left, right, middle, position or patterncount ( to name just a few ).

FYI ... You can even use the GetAsText function to capture where reference container data resides. When you wrap a container field with GetAsText and that container field stores the reference to that file, FileMaker will tell you that path!

Open storage paths subdirectory names for FMP12 container data that have been manually edited will result in FileMaker displaying <Missing:theFileName> errors. The directory path must be restored manually and guess which calculation function can help with that? Yep, the GetAsText function!

More info about the author and FileMaker in general, contact me at

© 2012 - Dwayne Wright -

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.