Use with ‘Add Rows’ or ‘Update Rows’ to create or update more than one row in a sheet.
Options
- Your Smartsheet sheets (dropdown list): a list of all available Smartsheet sheets associated with your Smartsheet account.
- Action (dropdown list):
- Add Rows - The created object will be used for Add Rows card
- Update Rows - The created object will be used for Update Rows card
Input Fields
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…’ checkbox at the bottom of the Insert Column or Edit Column Properties form is checked in Smart sheet UI, you need to fill in the correct data to pass data validation.
For example, for Date column type, if ‘Restrict to dates only’ is checked, a date like “02/12/2018” should be filled;
for 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 Fields
- Row (object): your newly-built row, which can be dragged and dropped into ‘Add Rows’ or ‘Update Rows’.