Last Updated: February 09, 2021

PREREQUISITE

Before we can configure a global search, we need to create at least two tables to call data from.

Product Information
Delivery Information

Based on the images above, we have tables for Product Information and Delivery Information. The Product Information is composed of the following columns: Product Name, Price, Delivery Address. The Delivery Information, on the other hand, is composed of the following: Delivery Address, Courier, Mobile Number. You will also notice that both tables have Delivery Address column.

Once you are done with the tables, let us now proceed to create a form.



The first row is composed of the following columns from the Delivery Information table:

Product Name (Search/Filter)
Price (Text Field)
Delivery Address (Text Field)

Next, add another row with two columns to call data from the Delivery Information:

Courier (Text Field)
Mobile Number (Text Field)



To set up the Global Search, we will configure the column that both tables have in common, which is the Delivery Address. Click the Delivery Address column and go to the Global Search tab.



Dataset - the table used to extend the search of data (Delivery Information)
Searchable Column - the data which will be shown as choices as they appear in the form (Delivery Address)
Returned Columns - the data which will be called based on the searchable column (Courier, Mobile Number)

MAPPING OF COLUMNS

The DDM Column contains data from the selected returned columns, while the Form Control contains the fields in the form builder, where the data called from the table will appear.

Courier - Courier
Delivery Address - Delivery Address

Based on the configuration we made, we used the Search/Filter element in the Product Name, and will return the data for its Price and Delivery Address. To also show the corresponding data of the courier assigned to deliver the specified product, we extended the search in the Delivery Address since this is the column which both tables have.

Preview 1
Preview 2

In the first preview, you will notice that no data were returned in the courier and mobile number fields, while there are data shown in the second preview. It is because the search was extended through same exact delivery address that both tables have.

RELATED ARTICLE(S):
Product Update: Global Search

Need more help? Send us an email at customersuccess@quickreach.co, or send us a message on the chat widget.
Was this article helpful?
Cancel
Thank you!