Sending data from a Subtask to a Dado field, Google Sheet or other data destination

Contents


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:

  1. 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.
  2. Go to the edit mode of your Experience and open the Timeline.
  3. 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.
  4. In the Subtask settings, under Data Destinations, click Add Destination.

  5. In the Save in dropdown, select Dado.
  6. 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
  7. Click Save to save the Data Destination you've just set up.
  8. Now save the Task by clicking the Save button in the top right of the Task window.
  9. 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:

  1. Go to the edit mode of your Experience and open the Timeline.
  2. 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.
  3. In the Subtask settings, under Data Destinations, click on the field you want to change or remove
  4. 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
  5. To remove the Data Destination, click remove
  6. Now save the Task by clicking the Save button in the top right of the Task window.
  7. 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:

  1. Before setting this up, you will need to have integrated Dado with your Google or Microsoft Workspace.
  2. Go to the edit mode of your Experience and open the Timeline.
  3. 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.
  4. In the Subtask settings, under Data Destinations, click Add Destination.
  5. In the first dropdown, select either Google Sheet or Microsoft Excel.
  6. 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).
  7. In the last field, give a name to the column in which this Subtask data will appear.
  8. Click Save to save the Data Destination you've just set up.
  9. Now save the Task by clicking the Save button in the top right of the Task window.
  10. 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:

  1. Ensure that your Google/Microsoft Integration User has edit access to the existing sheet you'd like data to be synced to
  2. Set up the Data Destination as described above
  3. 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:

  1. Before setting this up, you will need to have integrated Dado with your HRIS.
  2. Go to the edit mode of your Experience and open the Timeline.
  3. 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.
  4. In the Subtask settings, under Data Destinations, click Add Destination.

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

  6. In the second dropdown, select the field you'd like to send this data to.
  7. Click Save to save the Data Destination you've just set up.
  8. Now save the Task by clicking the Save button in the top right of the Task window.
  9. 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

Still need help? Contact Us Contact Us