cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • See how to use the JMP Marketplace – Free tools to expand JMP capabilities. Register. July 10, 2 pm US Eastern Time.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Update or refresh Google Sheets

JMP 15 introduced the capability to connect and get data from Google Sheets.
 
Google has several services to update time series data in GSheet every day/week/month, either maintaining the number of rows, or adding new data at the bottom of the table. These are often indexed by datetime which is the first column.
 
When using the GSheet connector, it will be great to have an option to update the current table instead of opening a new one (default behavior for 'source' script)
 
I assume adding this "refresh option" as a setting when loading for the first time the table is not difficult. Yet, this will facilitate day-to-day analytical routines, as users can then re-run saved graph or analysis scripts.
1 Comment
Ryan_Gilmore
Community Manager
Status changed to: Archived
We are archiving this request. If this is still important please comment with additional details and we will reopen. Thank you!