Skip to content
Pozvánka na UXWell Summer Camp 2024
  • Pages
    • Pozvánka na UXWell Summer Camp 2024
      • Getting Started & Examples
        • icon picker
          Adding New Rows
    Pozvánka na UXWell Summer Camp 2024
    /
    /
    Adding New Rows
    Share
    Explore

    Adding New Rows

    You may want to add new rows to your Google Sheet. Luckily we have a solution in the AddRow() action formula. Here we will describe how to use the function in your docs.

    Written Instructions

    Choose any new or existing table
    Create a new column and set the column to be a button column
    Go to Button options, under Actions open the dropdown and scroll to Packs → Google Sheets → Add Row
    Set the Spreadsheet Id and the Sheet Id of the Sheet you want to target
    Set the Row Range to target a specific area you’d like to insert rows below, by default it will find first empty row in the sheet
    Set the Value Parameter, this expects a List() each column will be filled out in order from left to right.

    Video

    ⁠
    ⁠
    ⁠
    Meeting Notes
    Name
    Department
    Date
    Notes
    Send To Sheet
    Archived
    Results
    Spooky Marketing Meeting
    10/31/2022
    Open
    Add row
    1
    Big People Event
    8/19/2022
    Open
    Add row
    1
    Engineering All Hands
    6/13/2022
    Open
    Add row
    1
    Test Meeting
    2/28/2023
    Open
    Add row
    1
    New Meeting
    5/31/2023
    Open
    Add row
    1
    Example Meeting
    5/3/2023
    Open
    Add row
    1
    There are no rows in this table
    ⁠


    Meeting Notes Archive
    Row Data Object
    Name
    Department
    Date
    Notes
    Google Sheets icon
    A2:D2
    Spooky Marketing Meeting
    Marketing
    10/31/2022
    Google Sheets icon
    A3:D3
    Engineering All Hands
    Engineering
    6/13/2022
    Google Sheets icon
    A4:D4
    Big People Event
    People
    8/19/2022
    Google Sheets icon
    A5:D5
    Test Meeting
    Sales
    2/28/2023
    Google Sheets icon
    A6:D6
    New Meeting
    DevOps
    5/31/2023
    Google Sheets icon
    A7:D7
    Example Meeting
    People
    5/3/2023
    There are no rows in this table
    ⁠
    Departments
    Name
    Marketing
    Sales
    People
    Engineering
    DevOps
    Executive
    There are no rows in this table
    ⁠
    Want to print your doc?
    This is not the way.
    Try clicking the ··· in the right corner or using a keyboard shortcut (
    CtrlP
    ) instead.