Add or Edit a Record

You add information one record at a time (if you want to add multiple records at once, read about grid edit mode). The process differs slightly, depending on whether you're working in a single-table or multi-table application.

Note: The word "record" refers to the records in a table, but the term used in your application may be different (for example, "contact," "task," or "issue"). This means that the menu item or button text in the instructions below may be slightly different from what you see.

To add a record:

  1. In the table bar on any application page, click the table featuring the report. Within the menu that appears, select Add a New -- Record--.

     

    An empty form appears.

    Note: If no "Add a New Record" option appears, then you don't have permission to add records to the application.

  2. In the text boxes provided, enter the necessary information.

    An asterisk (*) indicates that a field must be filled in.

  3. Save by doing one of the following:

To edit a record:

  1. Open a report that contains the record you want to change.

  2. Click Edit or next to the entry that you want to modify.

  3. Make the necessary changes, and then do one of the following:

FAQ: What happens when two people edit the same record at the same time?

With lots of people working together, it's inevitable that two staff members might edit the same record simultaneously. If someone else snuck in and modified the same record you're working on and saved before you did, QuickBase lets that person save without a care. But don't worry, just because you were late to the Save button, the program won't leave your edits stranded. If you make changes which are different and try to save the record, QuickBase displays a message telling you what's happened. When it does so, the program shows you the specific fields that are in conflict and asks if you want to overwrite with your version.

How do I edit an embedded report?

Your data-entry form may feature a table of related items that you can edit spreadsheet-style (see illustration).


Embedded Grid Edit Report
- A report that lists tasks related to the T3 Install project is embedded on this project form. An embedded report may just display related items, but it can also appear in grid edit mode, which means that you can use it to edit related records (in this case tasks). How can you tell? If you can click in a cell and make changes, your embedded report is editable.
It's up to your application manager to turn on this feature for each embedded report. Read how.

To edit records within this embedded grid edit report:

Edit any value by clicking in a cell. QuickBase highlights the cell in red. You can type or select new values.

Add new records in one of the following ways:

...and there's more. Spreadsheet-style embedded reports are really just grid edit reports that appear on a form. So you can perform any functions that work in a grid edit report. Learn more about working in grid edit mode.

When you save the record, all changes you made in the embedded report will save too.

Tip

 

Related Topics

 

Return to top

© 1999-2010 Intuit Inc. All rights reserved.