We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
2,854 Tutorials

Automator workflow of the month: Create a suggestion box

If you were to break into an office building not occupied since the mid-70s, theres a good chance youd see tacked to the wall a pine-based receptacle labeled Suggestion Box. This padlocked box would have a slot on top that allowed for the insertion of small slips of papereach one containing a hastily scribbled note complaining about Fred in Accounting.

The physical suggestion box has largely disappeared, but theres no reason for its functionality to, particularly if youre willing to spend a little time with Automator. In the following few paragraphs Ill show you how to construct and automate a virtual suggestion box so you can get employee feedback. These instructions work in both OS X 10.7 (Lion) and OS X 10.8 (Mountain Lion).

Make the digital box

Start by navigating to your user accounts Public folder. Within it create a new folder called Suggestion Box. Select that folder, press Command-I to bring up the Info window, click the Sharing & Permissions triangle, and click on the entry next to the Everyone item. In the menu that appears select Write Only (Dropbox). Suggest to those in your office that they access this folder on the network and make an alias of it, leaving it on their desktops. (They can Command-Option drag the folder to the desktop to create the alias.)

When they have a suggestion to share, they can fire up TextEdit, make as many disparaging remarks about Fred as they like, and drop the saved TextEdit file into the Suggestion Box folder. It will be copied to the host folder on your Mac.

Get Automator to check it for you

Now that their work is done, you can get to yours. Launch Automator and in the workflow template that appears, choose Calendar Alarm (iCal Alarm, if you're using Lion), and click Choose. In the library pane to the far left of the workflow, select Files & Folders and drag the Get Specified Finder Items action into the workflow area. Then add these actions belowGet Folder Contents (Files & Folders library), Combine Text Files (Text library), New TextEdit Document (Text library), Get Specified Finder Items (Files & Folders), Get Folder Contents (Files & Folders), and Move Finder Items (Files & Folders).

Into the first action (Get Specified Finder Items) drag your Suggestion Box folder. Do the same thing with the next instance of Get Specified Finder Items. To accomodate the last actionMove Finder Itemscreate a folder on the desktop and call it Archived Suggestions. Drag this folder on top of the To menu in the Move Finder Items action.

Save your workflow and, when prompted, enter a name such as Suggestion Box for it and click on the Save button. Calendar (or iCal, if youre running Lion) will open and a new Automator calendar will be created (if one doesnt already exist). If you run into the bug where the calendar alarm workflow turns into a regular workflow, choose File -> Convert To, and save a copy as a calendar alarm.

Your Suggestion Box workflow will appear as a calendar event. Select it, press Command-E to edit it, and change its start time to 5 PM. Click on Repeat, in the Frequency window that appears, choose Every Week, and move the event to a convenient dayFriday, for example. (If youd like to see suggestions each work day select Custom, click on the Monday through Friday buttons, and click OK.

Read the suggestions on a schedule

So, what have we done? At 5 PM on each Friday our workflow looks in the Suggestion Box folder for any text files it finds. It then launches TextEdit and combines those text files into a single document that you can then peruse at your leisure. Having created the file with the combined suggestions, it moves the original text files into the Archived Suggestions folder.

Of course you neednt use this workflow strictly for a suggestion box. Its an easy way to effortlessly combine any text files and bring them to your attention, whether or not they beef about Fred.

IDG UK Sites

Samsung Galaxy Note 4 release date, price and specs UK: Is this the actual Note 4 - video

IDG UK Sites

How Apple, Adobe, Microsoft and others have let us down over UltraHD and hiDPI screens

IDG UK Sites

How Ford designs next-generation cars at its Melbourne Design Centre

IDG UK Sites

iPhone 6 release date, rumours, video, UK price & images: iPhone launch event confirmed for 9...