

For example Company could come from a Customer database, Year could be generated by the Current Year or the Current Year plus 1, etc. Alternatively, these variables could be determined, rather than in the dialog box, from another data table. More merge variables could be added as needed. If you enter a Month variable, 12 monthly folders will be generated using a loop. There are two merge variables created in the dialog box, one for Year and another for Company. The Folder Name field can handle three merge variables. When the user runs the script, they are prompted to enter a Year and Company name.

Bah! Dedicated software, why use an app when you can build it into FileMaker? The FileMaker 17 demo file below, allows you to create batches of folders on your desktop or other locations, including some cloud folders, such as Google Drive and Dropbox.Įnter the folder names and their directory paths here.

There is a nice and free alternative to building folder structures on your hard drive from the Mac App Store. The free Client Folder Maker was an inspiration for this demo file. With FileMaker 17’s new ability to “Create Directories” in the “Export Field Contents” step options, and an old trick to delete files from the OS, this demo file demonstrates a new and useful capability in FileMaker to create pre-defined folder structures, pretty much anywhere on your computer or related cloud directories. In keeping with the principle, “Why use a screwdriver, when I have this hammer right here?”, I decided, instead of just downloading a free utility from the Mac App Store, I would build folder creation functionality using FileMaker Pro Advanced 17.
