As part of the series of product updates on AgilePoint NX v8.0 Software Update 2 release, the next one I would like to share is about the Google Sheets Connector.
Google Sheets is a spreadsheet program included as part of the web-based Google Docs Editors suite offered by Google. Google Sheets is part of the web-based office productive suite offered by Google. AgilePoint NX already supports another popular spreadsheet application, Microsoft Excel.
With this new feature, you can create a nice looking web front-end to your spreadsheets with rules, external lookups, validations, calculations, charts etc. and no matter where you are in the world, the web apps connects your spreadsheets so that your people can work as a team, in real-time.
The following process activities have been added
- Create Spreadsheet
- Add Sheet In A Spreadsheet
- Copy Sheet
- Delete Sheet
- Add Rows
- Insert Rows
- Read Rows
- Delete Rows
- Insert Columns
- Delete Columns
- Update Cell data
- Clear Cell Data
This video covers end to end scenario for how to configure business process to perform supported Google Sheets operations which includes basic concepts like activity configuration, runtime execution etc.
Note: Please note that this video is recorded while this feature is in beta version. Some of the labels and icons might change by the time it goes GA but the general concept of configuring these activities would remains the same.