Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

4 points

Input "data" to a specific numbers doc / month sheet-

I would like to run an apple script. get a popup (which is done already) and take that value and add it to a specific numbers document and create a sheet name by "year / month and add the data to the first row and cell. And to the next cell to add the current date that it has been added.

and if I run the script again. add the new "datas" to a row below.

visual example:

so popup input. 60 then autoadd current date to second column. and the 60 to the first one which I inputted.

and if I add a new input then add it to the next row etc. And when It's a new month create a new sheet with year/ month name

Please help 🙂

I'm new to this.

Thank you!!!

numbers app, apple script-OTHER, OS X El Capitan (10.11), apple script help

Posted on Oct 13, 2015 7:27 AM

35 replies

okaypol Author

Level 1

4 points

Oct 29, 2015 2:19 AM in response to SGIII

How do i delete this reply o.o

set

okaypol Author

Level 1

4 points

Oct 29, 2015 2:13 AM in response to SGIII

OMG! You are a genius!!!

Thank you so much!!!! 😊😎

I would like to ask which shall I use to "save and quit" the current document?

shall I use this? set minimized of window 1 to true

set m

or this somehow? I don't want to see it the document, I would be great if it would run "computer way" in the background, if possible. 🙂

SGIII

Level 8

35,324 points

Oct 29, 2015 7:24 AM in response to okaypol

Does putting

quittgtDoc

before the last end tell

do what you want?

okaypol Author

Level 1

4 points

Oct 29, 2015 8:44 AM in response to SGIII

Wow that's great~ how could I ad save and quit? 😮

SGIII

Level 8

35,324 points

Oct 29, 2015 12:03 PM in response to okaypol

okaypol wrote:

~ how could I ad save and quit? 😮

Have you tried adding the line as suggested?

quittgtDoc

okaypol Author

Level 1

4 points

Oct 29, 2015 12:24 PM in response to SGIII

Yes, I did, but it doesn't save the document automatically 😮

okaypol Author

Level 1

4 points

Oct 29, 2015 12:30 PM in response to SGIII

For some reason this comes up. Can't this be automatic with applescript?

SGIII

Level 8

35,324 points

Oct 29, 2015 12:41 PM in response to okaypol

Not sure why you're getting that (it doesn't happen on my machine). A guess is that AppleScript is acting too quickly for your computer, telling it to close the document before autosave has done its deed. To test this you could try putting a delay before the quit statement, so that you have this before the end tell.

delay 2

quittgtDoc

Then, if that works, try 1 instead of 2 to reduce the pause.

okaypol Author

Level 1

4 points

Oct 29, 2015 12:50 PM in response to SGIII

I can close every doc with the last code "close every document with saving" but I can't just close the tgtDoc only o.o

okaypol Author

Level 1

4 points

Oct 29, 2015 12:53 PM in response to SGIII

Sadly it doesn't work 😟 maybe somehow changing the "close every document with saving" code somehow?

SGIII

Level 8

35,324 points

Oct 29, 2015 12:56 PM in response to okaypol

What happens when you use this?

delay 2

quittgtDoc

okaypol Author

Level 1

4 points

Oct 29, 2015 1:21 PM in response to SGIII

The same thing as if it's not there. the same image pops up as wroten.

By the way I found this code. looks like it's working. "
close document 1 with saving" I have no idea why this works before the last end tell.

Does this work for you too, SG?

Can I automatically make a new checklist in the same numbers document by month? like separate sheets for each month.

okaypol Author

Level 1

4 points

Oct 29, 2015 2:14 PM in response to SGIII

This looks like working too : quitdocumenttgtDoc with saving

Wow thank you so much for your help so far, SG~ Couldn't have done it without yoy 🙂 just saying~

SGIII

Level 8

35,324 points

Oct 29, 2015 6:19 PM in response to okaypol

okaypol wrote:

"
close document 1 with saving"

Does this work for you too, SG?

I don't seem to need it on my machine but...

quittgtDoc with saving

works well here here too.

Glad to hear script is working on your end.

SGIII

Level 8

35,324 points

Oct 29, 2015 6:25 PM in response to t quinn

t quinn wrote:

Hi SG,

Always like to see your scripts.

quinn

Thanks, quinn. I think upgrading to El Cap on my machine broke the javascript bookmarklet that formats AppleScript for posting here; in any case, it's not working. I would like to reinstall it but can't find the thread you pointed out. Would you mind providing the link again? Thanks!

Input "data" to a specific numbers doc / month sheet-