Creating a Database Manually
Databases can be created either from the ground up or by choosing an existing database template.
When designing your database with an existing database template, you can select a pre-designed template that comes with a predefined structure and build your database using it. This might require a few adjustments such as modifying available fields, adding more fields to tailor the database to your specific needs.
Creating a Database from Scratch
Besides selecting a database template to create a database, you can always design your database yourself by adding required fields and their data types.
Let's create your database from scratch.
On the app homepage, go to the My Work tab on the left sidebar.
All the folders you have created, as well as those created by others, will be listed.
Click on the required folder to open it.
If you cannot locate the folder in the list, type in the folder name under Search Folders. From the search results, click on the desired folder to open it.
Go to the Databases tab.
Click the Plus icon and pick the Create Manually option.
Enter a meaningful name for your database.
Click Continue.
A list of existing templates will be displayed.
Click Skip this step or select the Blank Template from the template list.
Do required modifications (adding, editing, or modifying fields) to the database fields.
Add a new field/column.
To add a new field, click on the Add New Field button.
Type a suitable name for the Field added.
After you have entered a meaningful name, its data type will be automatically picked.
Select a different data type if necessary.
Add more fields as required.
Edit a field.
Pick the field you want to edit and modify the field name.
Delete a field.
Pick the field you wish to delete from the list of fields.
Click the Delete icon respective to the field.
Click Go to next Step.
Once you have designed the structure of your database, click Create New Database.
The below screen will be displayed after creating a new database.
Building a Database using an Existing Template
This section explains how you can select an existing template to build your database.
Upon choosing a template, you will see its pre-designed collection of fields and types. You have the flexibility to fine-tune the structure as required by either adding, editing, or modifying fields as necessary.
Let's build our database using an existing template.
On the app homepage, go to the My Work tab on the left sidebar.
All the folders you have created, as well as those created by others, will be listed.
If you cannot locate the folder in the list, type in the folder name under Search Folders.
Click on the folder you wish to open.
Go to Databases tab.
Click + button and pick Create Manually option.
Enter a meaningful name for your database.
Click Continue.
A list of existing templates will be displayed.
Select a suitable template from the list.
Based on the selected template, its fields and types will be displayed.
Do required modifications (adding, editing, or modifying fields) to the database fields.
Add a new field/column.
To add a new field, click on the Add New Field button.
Type a suitable name for the Field added.
After you have entered a meaningful name, its data type will be automatically picked.
Select a different data type if necessary.
Add more fields as required.
Edit a field.
Pick the field you want to edit and modify the field name.
Delete a field.
Pick the field you wish to delete from the list of fields.
Click the Delete icon respective to the field.
Change the Template selected.
To change the template you have already selected, click Change Template.
This action will redirect you to the template list screen for you to select a different one.
Click Go to next Step.
Once you have completed designing the database, click Create New Database.
Previewing Your Database
Once you've established your database, you can preview its contents by navigating to the Databases tab within the corresponding folder.
On the app homepage, go to the My Work tab on the left sidebar.
All the folders you have created, as well as those created by others, will be listed.
If you cannot locate the folder in the list, type in the folder name under Search Folders.
Click on the folder you wish to open.
Go to Databases tab.
Search and select your database.
Click on the database to view it.
Initially, a manually created database is a empty database with no data.
Watch this video on how to create a database manually to gain a better understanding.
Last updated
