You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

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.

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.