Add Multiple Records at Once

Maybe you’re not the one-at-a-time type. If you want to add or edit multiple records in one stroke, Quickbase can oblige.

To add multiple records at once:
  1. Display a table report of records in the table you want to add records to, such as List All.

  2. Click the Grid Edit link on the Page bar.

    Quickbase makes the entire table editable, so you can change any value directly from this report. This feature is a handy way to make changes to several records at once or to add or delete several records at a time. (Read more about Grid Edit.)

  3. Add records in one of two ways:

    • Scroll and type. Scroll to the bottom of the list of records where you'll find four blank rows. Type data in a blank row to add a new record. As you add records, Quickbase keeps generating blank rows, so you can go on adding new records as needed.

    • Select and insert. If you'd rather not scroll to the bottom of the list, you can insert blank rows any place you want. To do so:

      1. Select some records.

        To select the records, click in the leftmost table cell and while holding your mouse button down, drag down or up to select additional records. Quickbase highlights the selected records so you know you’ve snagged them. Select as many records as you'd like to add.

        Note: If Quickbase won’t let you select the records, you’re not in Grid Edit mode. Click the Grid Edit link on the Page bar.

      2. Right-click within the area of the selected records and within the menu that appears, select Insert Blank Rows.

      3. Quickbase adds empty records to the report. You can complete them here in Grid Edit mode.

  4. To save your changes and continue editing, click Apply Changes. When you’re done, click Save.

Tip - Create a Grid Edit report

You can create reports that automatically display in Grid Edit mode. This is handy for letting your users enter lots of records at once. For instance, say they need to enter multiple timecards at the end of the week. To do so, create a new report and make its type Grid Edit.

Related topics: