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, Quick Base 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.

    Quick Base 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, Quick Base 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. Quick Base highlights the selected records so you know you’ve snagged them. Select as many records as you'd like to add.

        Note: If Quick Base 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. Quick Base 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: