Build Row Object
Build a row object. Use this action with Add Rows or Update Rows to create or update more than one row in a sheet.
Options
Field | Definition | Type | Required |
---|---|---|---|
Your Smartsheet sheets | A list of all available Smartsheet sheets associated with your Smartsheet account. | Dropdown | TRUE |
Action |
|
Dropdown | TRUE |
Input
Input fields for Build Row Object are dynamically generated per Smartsheet sheet. For each column in a sheet, an input field will be generated. Input fields will be named with respect to the column they refer to.
For example, if a column is named "Date" in a Smartsheet sheet, it will have a corresponding input field named "Date".
If no custom names are specified, the default Smartsheet naming scheme (Column1, Column2, ...) will be used.
If Update Rows is selected from the Action dropdown menu, then a Row ID field will appear so that you can specify a row.
If the Restrict to... check box at the bottom of the Insert Column or Edit Column Properties form is checked in Smartsheet UI, you need to fill in the correct data to pass data validation. For example:
- For the Date column type, if 'Restrict to dates only' is checked, a date like "02/12/2018" should be filled.
- For the Dropdown List column type, if 'Restrict to dropdown values only' is checked, only one option value from the list should be filled.
- For Contact List column type, if 'Restrict to list values only' is checked, the email address should be filled if email address is available, otherwise, name should be filled.
Output
Field | Definition | Type |
---|---|---|
Row | Your newly-built row, which can be dragged and dropped into Add Rows or Update Rows. | Object |