Project Description

Integration Usage
Link creation of new Excel worksheets, rows or cells to creation and updating of new projects, scoops and fields. Feed relevant data collected using Scoop back into corresponding Excel cells. Create a “FLO” as a series of steps to automate or integrate data and workflow with Scoop. In this way when an Event “triggers” the FLO it will perform each Action and Function, one by one, from left to right. See the specific set of available Events and Actions for integrating with Scoop.
Specifications
Powered by: | Scoop Robotix GLOO™ |
Support: | Fully Hosted & Managed Service |
Available Events & Actions
- New Worksheet
Start the FLO when a new worksheet is added to the workbook - Row Added or Updated
Start the FLO when a new row is added to the worksheet - Table Row Added or Updated
Start the FLO when a new row is added to a Table - Updated Cell
Start the FLO when data within a cell is updated
- Add Row
Adds a row to the end of the Sheet including values for that row - Add Table Row
Adds a row to the end of the table including values for that row - Clear Cells
Clears values in the cell(s) - Delete Cells
Deletes cell(s) and shifts the worksheet in the specified direction - Get Cell Value
Gets Value and other properties from the Cell - HTTP Request
Make an authenticated HTTP request to the Excel Online API - Read All Rows
Read all rows in a worksheet (maximum of 300) - Read Row
Get Values from Row - Read Table Row
Get Values from Row in a Table - Search Rows by Column
Search for a row or rows that match a value in a certain column - Update Cell
Updates Value from Row - Update Row
Updates a row in the Sheet including values for that row - Update Table Row
Updates a row in the sheet including values for the row