Help > Documents > Admin Guide > Data > Datasets

Datasets

What are Datasets?

Data collected by your field teams in checklists, time sheets, work orders, and other forms in the Fluix app can be automatically aggregated and extracted into datasets for further export and analysis. To start collecting data, please follow the steps below or watch the video tutorial.

How to start extracting data?

Data is extracted from documents that are filled out and submitted by your end users within Fluix workflow. The data is saved to a report called Dataset and can be then downloaded in Excel/CSV format, sent directly to third-party data visualization software services, such as Power BI, Tableau, Domo, Qlik, etc, or exported via Zapier, Integromat, or any other integration platform, or to your database via API.

To start extracting data:

  1. Navigate to the Workflows tab under the Configuration section of the Fluix Admin Portal
  2. Open the workflow where you’d like to extract data from and click Edit Workflow
  3. Find the final submit rule for the documents (e.g. ‘Upload to folder’) and click ‘+’ to add a parallel submit action Extract Data:

4.  Add a new dataset (or select an existing one) where the data will be extracted to, and click Done:

5. Save changes to the workflow.

From now on all the data that is entered into fillable PDF forms within this workflow will be saved into the dataset each time the document is submitted. Photos that were inserted into the image fields in your form will be also saved into the dataset as a download link.

Each dataset will include the list of submitted documents, columns with the fields and data that was filled out in the documents:

The list of datasets can be found in the Datasets tab of the Data section:

By selecting any dataset, you can Customize it, Rename, Export, download as CSV or Excel, Delete it, or set up Notification Rules:

To create a dataset to be used in a workflow, click the New Dataset button in the top right corner.

Subsets with Filtered Views

By default, the dataset includes all the fields that are present in the submitted documents and the fields are named exactly as in PDFs. By creating filtered views (subsets), you can configure what fields to extract and rename them in a way you prefer.

Here are the steps:

1. Select the dataset and click Customize

2. Create New Subset and name it

3. On the left, you will see the list of documents that have already been collected in the dataset. On the right, there will be a list of fields from the collected documents. By default, all fields are deselected. You can select them by clicking on the button ‘Select all fields in all documents’ in the menu on the right.

4. To select a particular field, simply click on it on the document preview.

5. If the field names are generic (e.g., Text1, text2, etc.), navigate on the field to see its name, or navigate on its name in the list on the right, and it will be ‘linked’ to the right field in the document:

5. Here, you can also rename the fields by clicking on the pencil:

6. Type in a report name in the top left corner and save changes.

Filtered views can be exported, edited, or deleted:

Notification Rules

Besides extracting data, you can also track the deviations from the expected values in your documents and receive email alerts in real time. To proceed, you need to create rules for email alerts:

1. Select the Dataset and click on Notification Rules
2. On the left sidebar, add recipients of the email alerts
3. Click on Add Rule to create a rule for email alert
4. Add a field name, select the condition More, Less, or Equal to and specify the value
5. Add a message to be emailed
6. Save changes

Once the specified values deviate from the norm you expect, the respective email will be automatically sent to the recipients.

Access to Datasets

In case you do not see some of the options mentioned above, you can request access from your account owner. The permissions are regulated in the Roles tab under the Configurations section of the Admin Portal:

Finding bottlenecks and benchmarking in your business processes is now very easy.

Feel free to contact us at support@fluix.io if you have any questions or comments.

Check what you can do with Fluix. Explore features >

Was this article helpful?
Thanks for your feedback!
Oops, something went wrong. Please, try again later.
We're sorry about that, please contact our support for help.
1 out of 1 found this helpful

Sign Up to Our Product Newsletter

The latest updates from our Product team, straight
to your inbox

Before using our website, please read our Privacy Notice for Fluix Website.

Cookies

We use necessary pixels to ensure that all windows, pop-ups or similar components are displayed properly. This technology is stored on your devices and we do not have any access to it or store.

We use necessary cookies that help us make a website usable by enabling basic functions like page navigation and access to secure website areas. The website cannot function properly without these cookies.

We use statistics cookies that help us to collect information on how you use our website. These cookies collect information in a way that does not directly identify anyone.

We use marketing cookies that help display relevant ads for individual users, thereby more valuable for publishers and third-party advertisers.

We use analytics cookies to track website visitors and their user behaviour. This data is then used to improve the way the website works and in turn, used to improve user experience.

Please enter your business email to download this file