Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

AS_FolderPathListing ( _resultTOGlobalCellName ; _folderPath ; _extensionVL )

Rate this function:  

  Average rating: 4.7  (31 votes)
  Discuss this Custom Function

Thomas Seidler,

MAC ONLY. Generates Applescript to obtain folder listing & returns result as ValueList.

Sample Input:
Perform Applescript ( AS_FolderPathListing ( ":Macintosh HD:User:Shared:tmp:" ; "MyTable::GlobalField" ; "jpg¶jpeg" ) )

Perform Applescript ( AS_FolderPathListing ( "/Macintosh HD/User/Shared/tmp/" ; "" ; "" ) )
Sample Output:
MyTable::GlobalField =>

[If _resultTOGlobalCellName blank, the result will be set to clipboard, so pasting into field is the option]

 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed


_resultTOGlobalCellName must be the full reference (i.e. including TO) for a global field.

29 Sept 2011 - updated to handle file extension value list filter. By default unfiltered.

Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it


Regarding having the field on the layout - I strongly prefer to use global fields to receive applescript results. Global fields do NOT need to be on the layout and do not need a reference to the current record. You only need a table (table occurrence) reference. Example:

set cell "gResult" of table "Contacts" to "whatever"

Bruce Robertson, Redmond WA
September 15, 2011 4:34pm

Nice Bruce! As ever I can always learn from you, that's much much better. Yes, so we switch to global fields and away! Thank you sir! I will make the corrections to the function shortly...

Thomas Seidler, London, UK
September 16, 2011 2:41am

Hi Thomas!
Thanks for the CF. I was wondering if it was possible to extend it to list subfolders also?


Ian Mazursky, New Rochelle, NY
September 26, 2011 8:33pm

hi Ian, that's easily done within FM itself. Just create a loop that does it... gets listing for folderPath, then for each member of listing, requests listing with path folderPath & member. And so on...

How would you want the data ideally? Value list of strings?

It can be done, might hack it at some point if i find a need. If someone else wants to and submits code to me, i'll alter and give credit. That's an old way, apparently tis easier now. But no time...

Thomas Seidler, London, UK
September 27, 2011 1:50am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 6 + 6 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. ExcludeValues(MyList ; Out)
  (Wed, Mar 21, 7:23am)
2. PreviousMonthEndDate ( myDate )
  (Wed, Mar 07, 3:35am)
3. PreviousMonthName (myDate)
  (Wed, Mar 07, 3:33am)
4. FmTableFields ( tableName ; fieldsInclude ; fieldsExclude ; classExclude ; typeExclude ; prefixExclude )
  (Fri, Mar 02, 6:32am)
5. sql.getTable ( fullyQualifiedFieldObject )
  (Thu, Feb 22, 8:36am)
6. sql.getField ( fullyQualifiedFieldObject )
  (Thu, Feb 22, 8:34am)
7. FilterOut ( ListA ; ListB )
  (Wed, Feb 21, 6:11pm)
8. Char0 ( )
  (Sun, Feb 18, 2:35am)

RSS Feed of Custom Functions