> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://docs.flokzu.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to populate fields from a database?

You can use the information stored in your database to populate form fields.

###### Populate a combo box from a database
The options on a combo box (multiselect or not) can be populated from a column of a certain database.

![](https://storage.crisp.chat/users/helpdesk/website/5a899047-9b38-48ab-9475-31c8c63a3183/eeaa922f-f264-4947-808d-1a0f3bbbd21f.gif)

In the pop-up you will have to select the following:

![](https://storage.crisp.chat/users/helpdesk/website/5a899047-9b38-48ab-9475-31c8c63a3183/e5e5a577-4548-467f-8988-6a4cb3c1b7ed.png)

* Select the database from which you want to extract the data
* Select the column of the database from which you want to extract the data
* You can can choose to sort the combo box options alphabetically

| Filters are optional. They allow you to establish some conditions to extract only those database records that meet those conditions.

|| If you add more than one filter, the system will only show those records that meet all the conditions ** simultaneously**.

###### Trigger
The trigger is optional. If you set a trigger, you can populate other form fields automatically with the information obtained from a database. Example: Select a Supplier on a combo box and the fields corresponding to the supplier's contact details will be populated automatically. 

__Example__: populate the email of supplier after selecting the supplier's name.

![](https://storage.crisp.chat/users/helpdesk/website/5a899047-9b38-48ab-9475-31c8c63a3183/9f32a3ac-d229-4fbe-baec-9320d4b73a54.png)

Once that we have deployed the process, this is what will happen when the users complete the form:

![](https://storage.crisp.chat/users/helpdesk/website/5a899047-9b38-48ab-9475-31c8c63a3183/f4565c1c-8ef0-45d5-8cf1-0d22af19d05d.gif)