One of the advantages of delivering spreadsheets through Nathean Analytics is the ability to populate the spreadsheet with live or fresh data.

Take the case of providing lookup lists in your spreadsheet. Using Nathean Analytics , you can have the lookup list refreshed when the spreadsheet is opened and therefore the the user has access to the most recent values for data entry.

Nathean Analytics has the ability to load data from a spreadsheet on a cycle, however using dataset linked spreadsheets, modifications to that data are posted back to a database when the spreadsheet is saved. By connecting a Post Save script, you can very easily implement a form which pushes data from one stage in a data pipe line to the next.

Linking a Spreadsheet to a dataset

Revision: 4
Last modified: Jul 24, 2019

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment