Excel Online2019-02-19T11:33:17-07:00

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.

Contact Sales

Specifications

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