Sending data from a Subtask to a Dado field, Google Sheet or other data destination
Contents
- How to set up a Subtask to send data to a Dado field
- How to set up a Subtask to send data to a Google or Excel Online Sheet
- How to set up a Subtask to send data to your HRIS
- Different Subtasks send different kinds of data
You can use any type of Subtask to fill out a Dado data field, or send data to another destination, like your HRIS or a Google Sheet.
This can be used in a number of ways:
- collect additional information to fill out an employee's HRIS profile, during their onboarding Experience
- collect new hire's equipment choices, and share this with your IT team via a dedicated Google Sheet
- provide your Compliance team with a dedicated Google Sheet to track new hires completing mandatory tasks like background checks
- ask new hires for information that you'll later use to personalize their experience, for instance whether they will be working in-office, remotely or hybrid
How to set up a Subtask to send data to a Dado field
Sending data to a Dado field enables you to use it later in that Experience or future Experiences. For instance, during an onboarding Experience, you could ask a Participant for a short bio introducing themselves, then store that in a Dado field so you can later send it on to their Manager.
Here's how to set this up:
- First, think about which field you will store this data in. If you do not already have a field that you can use for this data, create one first by following the instructions in Add Custom Fields with Extra User Data.
- Go to the edit mode of your Experience and open the Timeline.
- Click the Task to open the Task window. In the middle of the window, click the Subtask you'd like to edit. Its Subtask settings open in the left sidebar.
-
In the Subtask settings, under Data Destinations, click Add Destination.

- In the Save in dropdown, select Dado.
- In the Dado Data Field dropdown, either:
-
Select from any existing field (start typing the first few letters to filter down the list of what's shown in the dropdown)

- If you can't find a suitable existing field, click Create new field to open up a new window where you can create a new custom field
-
- Click Save to save the Data Destination you've just set up.
- Now save the Task by clicking the Save button in the top right of the Task window.
- Close the Task window and save the Experience using the Save changes link on the bottom right.
Be careful of re-using the same Dado field
It's possible to set multiple Subtasks to send data to the same Dado field. It's also possible to import data to a field using an Import Source, and simultaneously have a Subtask sending data to the same field. This can lead to situations where different Subtasks and Import Sources overwrite data already entered into a Dado field.
Consequently, we recommend creating new custom fields wherever that's possible.
How to change which Dado field a Subtask sends data to, or which data is sent
To change or remove a Data Destination:
- Go to the edit mode of your Experience and open the Timeline.
- Click the Task to open the Task window. In the middle of the window, click the Subtask you'd like to edit. Its Subtask settings open in the left sidebar.
- In the Subtask settings, under Data Destinations, click on the field you want to change or remove
- To change the field this Subtask sends data to, or change the data sent, simply change the relevant field, and then click Save in the left hand column
- To remove the Data Destination, click remove
- Now save the Task by clicking the Save button in the top right of the Task window.
- Close the Task window and save the Experience using the Save changes link on the bottom right.
How to set up a Subtask to send data to a Google or Excel Online Sheet
You can set Subtasks to send data to a Google/Excel Online Sheet capturing all data for that Experience; or separate, dedicated Sheets for particular colleagues/departments. For instance, you could create a Sheet that provides your IT team with the information they need to order hardware for new hires and ship it to the right address.
Here's how to set this up:
- Before setting this up, you will need to have integrated Dado with your Google or Microsoft Workspace.
- For guidance on how to do this, see our articles on Google Workspace Integration or Microsoft Integration.
- Go to the edit mode of your Experience and open the Timeline.
- Click the Task to open the Task window. In the middle of the window, click the Subtask you'd like to edit. Its Subtask settings open in the left sidebar.
- In the Subtask settings, under Data Destinations, click Add Destination.
- In the first dropdown, select either Google Sheet or Microsoft Excel.
- In the second dropdown, either select a Google/Excel Sheet that already exists in this Experience, or Use a new sheet.
- If you select Use a new sheet, a new window will appear. In this window you can select which existing Dado fields you would like to appear in this new spreadsheet (alongside the data from this Subtask).
- In the last field, give a name to the column in which this Subtask data will appear.
- Click Save to save the Data Destination you've just set up.
- Now save the Task by clicking the Save button in the top right of the Task window.
- Close the Task window and save the Experience using the Save changes link on the bottom right.
By default, Dado will create a new Excel/Google sheet for each Data Destination you set up. This sheet will be owned by your Google Integration User/Microsoft Integration User (the account used to set up the Google or Microsoft integration).
If you would like Dado to sync data to a sheet that already exists, the Dado help team can set this up for you. To do this, please:
- Ensure that your Google/Microsoft Integration User has edit access to the existing sheet you'd like data to be synced to
- Set up the Data Destination as described above
- Provide the Dado help team with the URL of your existing sheet, and ask them to update the data destination
How to set up a Subtask to send data to your HRIS
Here's how to set this up:
- Before setting this up, you will need to have integrated Dado with your HRIS.
- Go to the edit mode of your Experience and open the Timeline.
- Click the Task to open the Task window. In the middle of the window, click the Subtask you'd like to edit. Its Subtask settings open in the left sidebar.
-
In the Subtask settings, under Data Destinations, click Add Destination.

-
In the first dropdown, select the name of your HRIS.

- In the second dropdown, select the field you'd like to send this data to.
- Click Save to save the Data Destination you've just set up.
- Now save the Task by clicking the Save button in the top right of the Task window.
- Close the Task window and save the Experience using the Save changes link on the bottom right.
Different Subtasks send different kinds of data
| Subtask Type | Data produced by this Subtask |
|---|---|
| Select Option | The exact text of the option selected by the Assignee |
| Answer Question | The exact text entered by the Assignee |
| Provide Address | The address entered by the Assignee |
| Rating or Linear Scale | The number selected or number or stars selected by the Assignee |
| Confirm Action |
The date and time that the confirm button was clicked, in the format "Completed at 06/13/2022 17:41" (note: date format will be the one selected in your Organisation Settings) |
| Visit Link |
The date and time that the link was clicked, in the format "Completed at 06/13/2022 17:41" (note: date format will be the one selected in your Organisation Settings) |
| Create Calendar Event |
The date and time that the link was clicked, in the format "Completed at 06/13/2022 17:41" (note: date format will be the one selected in your Organisation Settings) |
| Upload File |
The date and time that the file was successfully uploaded, in the format "Completed at 06/13/2022 17:41" (note: date format will be the one selected in your Organisation Settings) |
| Read Document |
The date and time that the Assignee finished reading the document or downloaded it, in the format "Completed at 06/13/2022 17:41" (note: date format will be the one selected in your Organisation Settings) |
| Watch Video |
The date and time that the Assignee finished watching the video, in the format "Completed at 06/13/2022 17:41" (note: date format will be the one selected in your Organisation Settings) |
| Complete Background Check | Your selection of the different result and status data from your background check platform. |
Data Destination functionality is not currently available for the following Subtask types:
- Sign Document
- Complete LMS Module
- Data Field Change


