Pulling data from a chart with AppleScripts & Pages

How can i pull data from a chart with AppleScripts to place into various textboxes in Pages?


In the attached, for instance, I want to extract the dates in line one and plug them into the 6 text boxes on page one. I want to do the same for several other boxes as well using a few other tables of data, but this task would take months of very simple (yet monotonously grueling) work without an automated process involved.


Any help would be great, and I'm even willing to pay for help.


Could I use find and replace? https://iworkautomation.com/pages/body-text-replace.html


Is this an issue that can be solved with Equations? Right now the data is in Google sheets, but I can easily transfer it to Pages or Numbers to get this started. I just have no clue how to begin.


Thanks.


MacBook Air

Posted on Nov 20, 2019 7:36 AM

Reply

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Pulling data from a chart with AppleScripts & Pages

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.