You might be wondering about a few things: The date of the report is entered and the top left cell of the expense table is selected, ready to be filled. When the script finishes, the expense report file looks just like the screenshot above. I have it saved in a folder that LaunchBar indexes, so I can run it by typing “oet” or just “oe” in LaunchBar. While doing this today I realized how silly it was to keep repeating those steps, so I wrote this AppleScript, which I call “Open Expense Template”: applescript:ģ: make new document with properties Ĥ: - delay 2 - might have to wait for Numbers to launchħ: tell table 1 to set value of cell 1 of column 2 to todayĨ: tell table 2 to set selection range to range "A2:A2" Click in the main table to start entering expenses.Click in the date field to enter today’s date.Scroll down through the list of templates to select my expense report template.So for the past several months, I’ve been making expense reports this way: Clicking the template file on the Dock would launch Numbers, but it wouldn’t create a new file from the template. At some point-possibly with Mavericks, possibly with the more recent versions of Numbers-that stopped working. I could click on it and Numbers would launch (assuming Numbers wasn’t already running-usually a safe bet with me) and open a new document formatted according to the template. Once upon a time, I had an alias for the template file in my Dock. The table in the top right has just two cells for the date of the report and its label the table that takes up most of the sheet has the usual cells for the expenses themselves. It saves me a few steps when creating and filling out a new expense report.Īs I’ve mentioned before, I have a simple two-table Numbers template for my expense reports. Here’s a simple AppleScript I should’ve written a while ago. Next post Previous post A simple Numbers workflow
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |