With the Search-widget you can search in the imported data and filter the results.

No MoreApp account yet? Sign up here.

This feature is available in the Leaf, Branch, Tree and Forest plans.

1. Import data

First import a data source. There are 3 ways to import data and use it in your digital form:

  1. Google sheets
  2. Excel
  3. URL

2. Settings of the Search-widget

Click on the pencil to edit the widget. There are a few settings available in the Properties of the Search-widget;

Label: Here you fill in the name of the widget.
Data Source: Here you can choose the data source. Next, the columns of the data source you added will be visible. You can select the columns you want to have visible in the app.
Default Value: Here you can add a value that is already set when you start searching.
Filter: Filter the results using value of other fields in your form, so that only the imported data with the filter is visible.

List colors: Apply colors to data source entries that match the configured queries. We explain this functionality in step 3.

Allow barcode scanning: Selecting this, you can scan a barcode so a product will show up. We explain this functionality in step 4.
Remember last search query: Check to remember your last search query. The search query will be executed automatically.
Required: If checked, this field must be filled in to be able to send the work order form.
Remember  input: Check this to remember the last input of the user on that device for the next registration. If you set a default value as well, remember input will not function. 

3. Add colors to the database

You have the option to assign colors to the imported data in order to speed up the searching process on the Search-widget. To do so, click on the pencil to edit the widget and, under Properties, you will find a field named List colors. Now, click on Add.

Next, a new tab will appear. Write down the Color you would like to show and at Query the record you want to give this color.  

  • Make sure you write the query properly or no color assignment will be assigned. 
  • If you want the color rule to apply correctly, write the name of the color in English.

You can assign as many colors as you like! To do so, click on Add as many times as you wish. By default, a color will appear every time you click. You can change that color and write the one you prefer.

When you finished assigning the colors to the queries, click Save and then Save and Publish.

Now, when you fill in the form and click on the Search-widget, the database will appear with the assigned colors. 

4. Add barcodes of a product

Optionally, you can also scan a barcode so a product will show up.
In the Excel, Google sheets or URL you can insert the barcode of different products. For example: 

Select Allow barcode scanning. Click on Save and Save & Publish. 

When you click on the barcode in the Search-widget in the app it will look like: 

After you scanned the barcode, it will look like: 

You can also click on the Search-widget and fill in the name or the barcode of the item you are looking for:

Do you want to be the first to see our latest tutorials? Go to our YouTube and hit the Subscribe button!