Insights on the Assignar dashboard can count and total the answers your workers and office staff give on forms, grouped by client, project, supplier, asset or worker. Anyone with an Insights licence can open the prebuilt Form Results report; people with an Insights Creator Licence can build their own form reports.
Your company can rename some words in Assignar, so you might see another word for Form.
Open the Form Results prebuilt report
To see form results in Insights on the Assignar dashboard without building anything, go to Insights > Saved Reports > Prebuilt Reports and open Form Results. Use its filters to pick the form and date range.
Build a form results report in Insights
To build your own form results report in Insights on the Assignar dashboard:
Go to Insights > Report Builder and click the Form Results tab.
Add the form name and the record you want to group by. A form result can be linked to a client, project, supplier, asset or worker, depending on what the form asks for when it is set up.
Add the questions and answers you need (see below).
Add a date filter and click Run.
Add questions and answers to a form report in Insights
To bring each question and its answer into a form report in Insights on the Assignar dashboard, add the question field from the form result details, then the answer field that matches the question type:
Number question: the answer number field.
Worker question: the worker's full name (or another worker field).
Asset question: any field of the answered asset.
Every other question type: the answer text field.
To show each question as a column heading with the answers below it, add the questions, pivot the question field, then add the answer field.
To total the answers to a number question, use the measure that sums the answer numbers.
Report on who submitted a form or who it's assigned to in Insights
To split form results by who submitted them in Insights on the Assignar dashboard, use the fields for results created by dashboard users and results created by workers (fieldworkers).
On the dashboard, a form result can be given a status and an Assignee with Change Status & Assignee. To report on these, add the form result's status and the assigned dashboard user to your report.
Form results filled in under an admin (dashboard) profile don't show the worker in Insights
When someone fills in a form under their dashboard login (for example "name (admin)") instead of their worker login, Insights on the Assignar dashboard records the result as created by a dashboard user, so a report that uses the worker (fieldworker) who created it leaves the name blank. To fix this:
In the report: add the field for results created by dashboard users as well as the field for results created by workers, so both kinds of submitter show.
On the form, for new results: in the form builder's Settings, tick Worker under Associate with. Every new result then asks which worker it is for, whoever fills it in. In Insights, report on the worker linked to the result instead of the person who created it.
For results already submitted: once the form asks for a worker, open each result on the dashboard (Field Data > Forms > the result's three-dot menu > View/Edit Results), click Edit Form Result, choose the worker in the Worker field and click Submit. You need the Forms or Form Results Only permission. See How do I edit a form result on the dashboard?.
You can't change who created a form result: it stays the login that submitted it.
