Apple Intelligence is now available on iPhone, iPad, and Mac!
I currently input data to a (once) daily calendar, one of 2 scenarios (If I was working or my partner) then later I go to numbers and input the same data there based on the historic record made within Calendar.
My question is, is there a way, that when I input the data in Calendar, that the data automatically updates the Numbers file on the fly, without me having to go and do this manually in Numbers?
[Re-Titled by Moderator]
It may be possible to have an AppleScript read the calendar and update numbers, but there are a whole load of gotchas in that - namely how does the script identify relevant events in the calendar? and how does it know where to put the data in the spreadsheet.
Happy to take a run at this, but going to need more detail (and sample data) to be able to make it work.
Depending on the details you might be able to automate this with a script (which would have to be triggered manually).
But more information is needed before knowing whether that would be worth the effort.
SG
Basically on a given day, 7 days per week, I input onto Calendar whether I or my partner worked.... If I worked it is with a green colour, if my partner worked that day it is with a red colour - If we both worked that day then obviously theres a red and green colour. I then, at the end of each week (for example, or whenever I get to it), go through the Calendar and total up the relevant days and add them to a Numbers spreadsheet, which gives a running total of total of days worked each - The Numbers spreadsheet already automatically calculates the total number of days worked at the bottom of the sheet, it updates everytime I update the days worked. Is that enough information?
It would be convenient if I did not have to go through manually adding the days to the spreadsheet, if I could just mark Calendar each day then the spreadsheet side is auto updated that would be great.
I did think of some kind of script via automater but no idea where to start, to be honest. Thank you for any and all assistance.
How can I automate data entry between Calendar and Numbers?
