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

2. Adding New Data Records Manually into a Database

1. Creating a Form to Populate Data in a Database

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.

Locating the Form You have Created

All the forms you have created will be saved and listed under the User Interfaces tab of the respective folder.

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.

View the Changes in the Database

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.

2. Adding New Data Records Manually into a Database

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.

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. 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.

   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.