I have three related questions:
- In Wdesk, if I have several spreadsheets each with several sheets, each with several Wdata Connections, is there a way using Chains to enumerate all these Wdata connections and auto refresh them?
- In Wdata, if I have linked DataSets pointing to Spreadsheets in WDesk, is there a way to have a Chain refresh these datasets?
- In Wdata, it is possible to create a View. I can also export this view to a sheet in a Spreadsheet. However there does not appear to be any link between these two. Is it possible using chains to export a view to a spreadsheet? If one can automate this using chains then there is no need for a persistent link / refresh.