Datasets

If you have your own dedicated database where source data lives, or have data in a spreadsheet, which you want to host on Next Matter. Datasets enable such an approach.

​

Create a dataset

1. Click datasets [left-hand navigation].
2. Specify the headers for your data table and select the data type (if the content is a number or text).
3. Upload a CSV file with your data. Make sure the data columns have headers.
4. Click Complete.

We’ll notify you when your data gets transformed into a dataset and is available for selection inside a single-choice dropdown form field.

To show the data as a dropdown:

1. Select the single-choice dropdown form field.
2. Select Add items dynamically from Next Matter dataset.
3. Select the dataset from which you want to pull data.
4. Select the column from the dataset that you want to display as a dropdown.
5. Save your changes.

Now the column contents will be available as a single-choice dropdown.

​

Reference dataset items

You can reference a selected dataset item by picking it from the data reference dropdown.

You can also reference a value from a different column that corresponds to the selected value. To do that:

1. Click the cog item next to the data reference.
2. Select the column from the dropdown. The available columns are from the same dataset row as the selected item.

The reference will show the value from this column that corresponds to the item selected from the dropdown.

​

Data references and duplicates

To manage the number of options to select from in the dropdown, we only show unique values (and combine all the occurrences of the same element). This streamlines the end-user experience. However, this can also affect data referencing.
For data referencing, we take the first occurrence of the item. If you want to reference another item from the row in which the selected item resides, we will always reference the same item. For example, for Data Scientist, we’ll always show Jane Smith as the Name reference.

​

Filter datasets

To show users specific dataset items to select from, workflow builders can apply multiple filters when creating the form. The filters depend on each other, so the user will need to select an item from a parent dropdown to activate the child dropdown.

You can filter data using:

• Manually entered values
• Data references from your workflow (system values, user inputs, other datasets)

Important: You can use data from various datasets as filters, including data based on different datasets than the one you’re filtering. However, the data needs to exist as a dropdown field somewhere in your workflow.

​

No filter results

It might happen that specific filter combinations will not show options to choose from. In such cases, the user will be able to select No options available to proceed. If you (as a builder) observe this happen, you can create custom paths to manage these scenarios. For example, you can create a conditional workflow or allow users to enter free text.

​

Create filters

To use filters for datasets, toggle on Use row filters and apply the filters you need.

You will see the filters applied when you hover over the funnel icon, which is available for every single-select dropdown with the dataset as the source.