Creating Useful Helper Actions For Mac Numbers

By using JavaScript in Automator you can change the value of selected cells in Numbers. But a little more coding you can place specific or random values in the cells, reorder them, insert data from the clipboard or even an Internet location. There are allo sorts of ways to use code like this to do things you couldn't easily do in Numbers otherwise.



Download the text of the scripts here.

Comments: 2 Responses to “Creating Useful Helper Actions For Mac Numbers”

    Scott R
    1 day ago

    Interesting video. Can you give some quick recommendations on the best way to start learning the JavaScript language you showed for automating Numbers? Do I start with learning Automator first? Is JavaScript the primary or only language for Automator? Is there a JavaScript language documentation feature within Automator similar to the function browser in Numbers? I’ll starting watching your Automator videos ASAP. Thanks.

    1 day ago

    Scott: You can use JavaScript, AppleScript or shell scripts in Automator. There is no documentation in Automator, but there is in the Script Editor app (the Library) and Script Editor is a good place to play around and learn “JavaScript for Automation,” which is what is used in Script Editor and Automator. But a basic background in JavaScript is helpful, and that is easy to find all over the Internet since it is used everywhere.

Leave a New Comment Related to "Creating Useful Helper Actions For Mac Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)