With the Search-widget you can search in the imported data and filter the results.
1. Import data
First import a data source. There are 3 ways to import data:
2. Settings of the Search-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 correct 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.
Allow barcode scanning: Selecting this, you can scan a barcode so a product will show up. At step 3, you will find further explanation.
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 have 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.
- Under Query, type the name exactly as it appears in the database.
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:
After you added the data source you can add the Search-widget to your form.
Select Allow barcode scanning.
Click on Save and Save & Publish.
5. Filling in the form
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!