Utilising Content-aware Autofill to Automatically Fill in Fields in Your Database

This article explains how to automatically fill in your database fields using the content-aware autofill feature in Lucy.

Content-aware Autofill is a powerful feature that uses AI (Artificial Intelligence) to automatically fill in data in a database based on existing columns. Simply provide initial row examples, and subsequently, this feature will fill in columns automatically when new data is added or updated.

For instance, let’s create a database to capture employee feedback and use this feature to automatically classify the feedback as 'Good' or 'Bad' and autofill the result in the database.

Utilising Content-aware Autofill for database population involves several key steps.

1. Creating Your Database

2. Adding Data into Your Database

3. Enabling the Content-aware Autofill in Your Database

4. Testing the Content-Aware Autofill Feature

5. Viewing Your Updated Database

1. Creating Your Database

As the initial step, you need to have a database created in the system.

Find the article below to create a new database.

Creating a Database Manually

Database example

2. Adding Data into Your Database

Next, create a form to easily add sample data into your 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.

6. Search and click on the database we previously created.

7. Hover over the database and click Edit icon that appears.

8. Click Create a Form.

9. Under the General tab on the right, provide a name for the form.

10. Click the Delete icon of the corresponding field (e.g., Mood) to remove it from the form.

11. Click Save Widget.

12. Click Open Page to open the form in a new window.

13. Fill in the form details and click Submit.

14. Refresh the page to add more data.

15. Open the database to view and fill in data in the required column.

    1. Within your folder, go to the Databases tab.

    2. Search and click on the required database. Entered data will be displayed.

    3. Click the Edit button to enter the edit mode in the database.

    4. Fill in the data in the required column e.g., Mood.

Feedback Form

Entering form details

Previewing the data

3. Enabling the Content-Aware Autofill in Your Database

After creating your database and adding sample data, enable the Content-aware Autofill feature to learn from the given data and automatically populate relevant columns.

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.

6. Search and click on the database created.

7. Hover over the database and click the Edit icon to open its edit mode.

8. Enable the Content Aware Autofill option.

9. Choose the field you want to look at from the Choose Raw Text Field list. In this example, it is the 'Comment' field.

10. Select the No of Example Rows you want the autofill feature to use for training.

11. Columns to AutoFill (Optional): Select the field you wish to automatically fill in. In this example, it is the 'Mood' field.

12. Click Done.

13. Click Update Database to save changes.

4. Testing the Content-Aware Autofill Feature

Now, add more examples using the form interface to test the Content-Aware Autofill Feature.

Testing the Content-Aware Autofill Feature

1. On the app homepage, go to the My Work tab on the left sidebar.

2. Click on the folder you wish to open.

3. Head to the User Interfaces tab.

4. Find the form user interface and click on it.

5. The form will be launched in a new page.

6. Enter the form details and click Submit.

7. Refresh the page to add more data.

Adding Data from the Database

You can also add or update data directly using the specific database.

To Add Records/Rows from the Database

1. On the app homepage, go to the My Work tab on the left sidebar.

2. Click on the folder you wish to open.

3. Head to the Databases tab.

4. Find the required database and click on it.

5. Click the Edit button to enter the edit mode.

6. Click Add. Add few records.

7. Click Save Item(s).

8. Click the Refresh icon to refresh the database.

9. Now, you can see the required column is automatically filled in.

5. Viewing Your Updated Database

Let's view the database to see the changes.

1. On the app homepage, go to the My Work tab on the left sidebar.

2. Click on the folder you wish to open.

3. Head to the Databases tab.

4. Search and click on the database to view it.

5. The 'Mood' field will be auto filled based on the data you entered.

A preview of the updated database

Watch this video to learn how to automatically fill in your database fields using the content-aware autofill feature in Lucy.