Skip navigation

Automator Actions for Numbers?

3831 Views 7 Replies Latest reply: Nov 25, 2013 9:19 PM by SGIII RSS
Durero Calculating status...
Currently Being Moderated
Feb 3, 2011 2:40 AM
Do they exist?

If so how can I install them?

If not are there applescript actions for numbers and where can I learn to use them?

Any info at all would be greatly appreciated
MacBook Pro 17" 3.06GHz, Mac OS X (10.6.2), Cinema Display 30"
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    Feb 3, 2011 3:02 AM (in response to Durero)
    As far as I know, no automator actions are delivered by Apple.

    To get Scripts, you may go to my iDisk

    <http://public.me.com/koenigyvan>

    and scan the contents of the folder :

    For_iWork:iWork '09:

    Yvan KOENIG (VALLAURIS, France) jeudi 3 février 2011 12:02:38
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.6.6)
  • pjdube Level 3 Level 3 (830 points)
    Currently Being Moderated
    Dec 13, 2012 3:04 PM (in response to KOENIG Yvan)

    Koenig,

     

    I tried going to the link that you refer to, and it no longer works. Can you post a new one? I was trying to see those scripts you created.

     

    Thanks.

     

    Phil

  • Jerrold Green1 Level 7 Level 7 (28,175 points)
    Currently Being Moderated
    Dec 13, 2012 3:40 PM (in response to pjdube)

    Phil,

     

    That's a very old post. The files are now located here.

     

    Jerry

  • pjdube Level 3 Level 3 (830 points)
    Currently Being Moderated
    Dec 13, 2012 4:04 PM (in response to Jerrold Green1)

    Jerrold,

     

    Thanks a lot!

     

    Phil

  • Leborde Calculating status...
    Currently Being Moderated
    Nov 25, 2013 9:33 AM (in response to Durero)

    Hi Guyzs,

     

    I'd like to create an action that will enable me to list my file names in Numbers, file type and date of creation and modification. 

     

    The thing is that I have 900 documents (PDFs, ppt, xls, doc, etc...) contained in folders and sub folders, to list one by one in Numbers, with 4 columns: file name (just the name, not the extension, to be in column A), file extension (with the DOT before the extension name, to be in column B), creation date (to be in column E) and last modification date (to be in column F).

     

    I'm very new to Automator and Apple Scripts, as I only tried long time ago once or twice and miserably failed, while aided by tutorials.

     

    Regards,

     

    Fab'

  • SGIII Level 4 Level 4 (3,290 points)
    Currently Being Moderated
    Nov 25, 2013 9:19 PM (in response to Leborde)

    Hi Fab'

     

    I can't advise on the details of the Automator workflows and AppleScript needed to extract the four columns of data.

     

    But you will want the script to output in tab-separated or comma-separated format that can be imported into Numbers. 

     

    Numbers 3.0 has only minimal AppleScript support, so you can't push the data to it directly.

     

    But importing tsv or csv should work nicely.

     

    SG

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.