Using the Database Module
Database modules make the features of TIMU's task modules available for organizing information in cases where a task module isn't a perfect fit- you can use a database module to create a grid view for things like personnel rosters, activity logs, or order lists.
You can also use your database as a shared list, using reference fields to connect it to other TIMU content.
The first step in working with databases is to add one to your workspace. To add a database:
- Open the workspace settings page
- Scroll to the bottom of the page and click '+ Add Functionality'
- De-select the option for 'Only show official packs'
- Select a module pack that already includes a database module, or add an empty database from the 'blank' module category.
Rows and Columns
A newly created database doesn't contain any built-in fields- not even a 'name' or 'status' field- so you'll need to add some fields to the module before you can start using the database. As an example, we'll build a simple table of customer contact information.
To add fields after adding the empty database to your workspace:
- Click the 'More' link on the right-hand side of the screen to expose the database's settings.
- Click the 'Fields' link.
- Choose any of the predefined custom fields for your database, or create your own as necessary.
For our purposes, we'll need several text-type custom fields for the customer's street address, phone number, and email address, as well as an identifier-type field for creating customer IDs. Since we're going to want to reference the customer list in our 'Orders' database (more on that later), we also need to make sure to add the built-in 'name' field. Once you've added all of the fields the database will need, save your changes and open up the database.
Blank databases come without any preconfigured views, so before we can start adding customers to the database, we'll need to create a view that displays the custom fields we just created.
- Click '+ New View' to create a view.
- Open the 'Fields' link from the filter bar.
- Click '+Add Fields' to open a menu that lets you add your custom fields to the view.
- Once the fields are added, you can click and drag them into the desired order- the fields will be displayed from left to right.
After you've configured the fields for your database, you can begin adding rows of data. You can create a new empty row by clicking '+ New Row'. Type data into any fields in the row and press the tab key to move to the next field. Press the Enter key to save the row.
Using References and Replacing Shared Lists
Once you've got your database configured and started adding information, you can take advantage of reference fields to make connections to that data from elsewhere in TIMU. In this example, we've created a database for tracking orders, with a reference field that gets its values from the 'name' field of our customer database:
To reference your database in another module:
- Open the module's settings and click to the 'Fields' link.
- Create a new reference-type custom field to act as a container for the information from the source database.
- Choose 'reference' as the field type.
- Click the blue 'Browse' link in the next window, and a modal will open and prompt you to
- Navigate to the source database.
- Once you've configured the reference, remember to save!
After the custom field is created, it still needs to be added to a view. Open the desired view, click the 'Fields' link on the filter bar, and add your custom reference field to the view.
The reference field will display as a dropdown list showing the 'name' field from each row of the source database. Select the name that corresponds to the desired row, or start typing the name in the search box to filter the list.