Although database forms are created by a Smartabase builder, with appropriate data permissions people can write (create and/or edit) or delete database records. These permissions are determined by a Smartabase administrator and, depending on the type of database, may not be given to all people who are able to view the database.
View a database
- Log in to Smartabase to view your home page.
- Using any method of data entry, open an event form that references the database you want to update.
- Select the database field.
- When the pop-up appears showing potential database records, click the View all button at the bottom of the list.
- You are now able to:
When finished editing, use the trail bar to return to the event form or the home page.
Add a database record
- Log in to Smartabase to view your home page.
- Using any method of data entry, open an event form that references the database you want to add a record to.
- Select the database field.
- When the pop-up appears showing potential database records, click the Add button at the bottom of the list.
- Fill out the fields necessary to create a new database record.
- Click Save & Close.
Make sure to check that you are not creating a duplicate database record.
Edit a database record
- Log in to Smartabase to view your home page.
- Using any method of data entry, open an event form that references the database you want to update.
- Select the database field.
- Enter the name of the record you want to edit.
- When the pop-up appears showing matching database records, click the Edit button for the relevant record.
- Modify the database record.
- Click Save & Close.
Editing a database record that has previously been referenced and saved in a form can cause data to be lost.
Delete a database record
- Log in to Smartabase to view your home page.
- Using any method of data entry, open an event form that references the database you want to update.
- Select the database field.
- When the pop-up appears showing potential database records, click the View All button at the bottom of the list.
- Select the Delete button next to the database record to be deleted. If you cannot see the Delete button, your role may not have permission to delete database records. Speak to your Smartabase administrator if you require this access.
Deleting a database record that has previously been referenced and saved in a form can cause data to be lost.
Import database records
- Log in to Smartabase to view your home page.
- Using any method of data entry, open an event form that references the database for which you want to import records.
- Select the database field.
- When the pop-up appears showing potential database records, click the View All button at the bottom of the list.
- Select Import from the Options drop-down in the top left-hand corner of the screen.
- Select the database for which you want to import the records.
- Upload a CSV file of the new records you wish to import. This file must be formatted similarly to a standard data import file, but does not require a Date or About column (as a database records do not have date stamps and are not associated with a particular person).
- Ensure all columns in your CSV file are mapped to the correct field in the database.
- Click Import.
All entries in your CSV file will be imported, regardless of whether there is an existing identical record in the database. Make sure your file only contains new records to avoid duplicate entries.
Download a report of the database contents
- Log in to Smartabase to view your home page.
- Using any method of data entry, open an event form that references the database you want to add a record to.
- Select the database field.
- When the pop-up appears showing potential database records, click the View All button at the bottom of the list.
- Select Download Report from the Options drop-down in the top left-hand corner of the screen.
- The database fields will be downloaded as a CSV report.