# Adding Data into a Database

Adding data into a database is the key to maintaining information organised and easy to use.

There are two approaches to adding data:

1. [Creating a Form to Populate Data in a Database](#id-1.-creating-a-form-to-populate-data-in-a-database)
2. [Adding New Data Records Manually into a Database](#id-2.-adding-new-data-records-manually-into-a-database)

## <mark style="color:blue;">1. Creating a Form to Populate Data in a Database</mark>

You can create a form to capture data and add data into an existing database.

Forms make data entry simple by providing a user-friendly, structured, and efficient method to input information.

1. On the app **homepage**, go to the **My Work** tab on the left sidebar.
2. All the folders you have created, as well as those created by others, will be listed.
3. If you cannot locate the folder in the list, type in the folder name under **Search Folders.**
4. Click on the folder you wish to open.
5. Go to the **Databases** tab.
6. Search and click on the desired **database**.
7. Hover over the database and click the **Edit** icon that appears.
8. Click **Create a Form**. A form user interface will open on the Widget Designer page.
9. Go to the **General** tab on the right and enter a name for the form in the **Name** field.
10. You can customize the form as needed.
11. After completing your edits, click **Save Widget.**
12. On the pop up window, click **Open Page** to open the form in a new window.
13. Fill in the form and click **Submit**.
14. When you submit the form, data will be populated in the respective database.
15. Refresh the page to add more records.

Watch the below video on creating a form to populate data in your database to gain a better understanding.

{% embed url="<https://drive.google.com/file/d/1fMRulQDqsSz728JLhKO3EezIOk2xIpVl/view?usp=sharing>" %}

### <mark style="color:blue;">Locating the Form You have Created</mark>

All the forms you have created will be saved and listed under the **User Interfaces** tab of the respective folder.&#x20;

If you wish to see your form, here is what you can do.

1. On the app **homepage**, go to the **My Work** tab on the left sidebar.
2. Search and click on the **folder** you wish to open.
3. Head to the **User Interfaces** tab.
4. Find and select the designated form.
5. Click on the desired form to open it.
6. Your form will be opened in a new window.

### <mark style="color:blue;">View the Changes in the Database</mark>

After entering data using a form, all the details will be saved in your database.

To view the changes in the database

1. On the app **homepage**, go to the **My Work** tab on the left sidebar.
2. All the folders you have created, as well as those created by others, will be listed.
3. If you cannot locate the folder in the list, type in the folder name under **Search Folders.**
4. Click on the folder you wish to open.
5. Head to the **Databases** tab. A list of previously created databases will be displayed.
6. To locate your database in the list, type in the **name/partial name** of your database in the search box.
7. Your database will be displayed in the search results.
8. Click on the database to view it.
9. Previously added data using the form will be displayed on the database view.

## <mark style="color:blue;">2. Adding New Data Records Manually into a Database</mark>

If you want to manually add data records into your database, here's a step-by-step instructions:

1. On the app **homepage**, go to the **My Work** tab on the left sidebar.
2. All the folders you have created, as well as those created by others, will be listed.&#x20;
3. If you cannot locate the folder in the list, type in the folder name under Search Folders.&#x20;
4. Click on the folder you wish to open.
5. Go to the **Databases** tab.
6. Search and click on the desired **database**. A table preview of your database will be opened.
7. Add multiple data records.
   1. Click **Add**.
   2. Type in the number of rows to add.
   3. Click **Add Row(s).** The specified number of empty records will display.
   4. Fill in the data.&#x20;
   5. Click **Save Item(s).** Your data will be saved in the database.

Find the video on adding data manually into your database to gain better insights.

{% embed url="<https://drive.google.com/file/d/1NaUycVzGF3LghxkeUHsQaf4IX6eusSHo/view?usp=drive_link>" %}