Insert a Row

Inserts a row into the table with given data.

Overview

This procedure inserts a row into the table with given data at the specified row number.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

insert a row in the table where

What does it do?

Initializes row insertion.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — A reference to the table must be defined.

the row number is x

What does it do?

Specifies the row number to insert the new row at.

Where does it go?

Indented under insert a row in the table where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace x with a row number. Note: Table rows are numbered starting with 1. If not provided, the row will be inserted at the end of the table.

Example

the row number is 3

the {name} is {value}

What does it do?

Specifies the row data to be inserted.

Where does it go?

Indented under insert a row in the table where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

✅ Yes — Replace name with the name of the column and replace value with the value to insert.

Example

the row number is 3

Examples

1. Insert a Row Without Specifying Row Number

To insert a new row into the table without providing a row number or a reference to a row, we specify data for all the columns in the table.

insert a row in the table where 
    the Name is "Beet"
    the Color is "Red"
    the Type is "Root"

2. Insert a Row When Specifying a Row Number

For this example, the row refers to the following row:

Name	Color	Type
Beet	Red	Root

insert the row in the table where
    the row number is 2