Dustin- Thank you. I don’t care whether the automation is in the cloud or on my mac. And I think i distracted from my real question with the mention of dashboard.
My first question is simply to find the easiest way to load records into a database, query the database, and use the results of the queries in AppleScript, etc.
Essentially, I’m asking if there is an easy way to query records in Applescript with the equiviloent of the spreadsheet fuctions SUMIF, SUMIFS, AVERAGEIF, etc. And if I can’t do that easily in Applescript, what is the alternative with the lowest learning curve.
If it turns out that the way to do that also uses a tool (or easily connects to a tool) that can make the data pretty, that’s a bonus.