Workflow - Email Notification

I have a dataset with about a dozen fields of information, including a recipient email address that I want to run through a workflow to generate an email notfication to each recipient that includes a body summary containing the information from the other fields.

I've been using Dan Hendriksen's workflow tutorial on tagging a dataset as my example. I have successfully set up my workflow, counter, queried the dataset, got the current row as an object, and created children in the object to align to the dataset fields.

I thought the next step would be one of two things. I could maybe, if lucky, just use these object children as inputs in the email body (and recipient field) or what I assumed I would have to use "Get Text From Object" and create a text output variable for each field. However, neither worked as intended as the email just showed the variable names i.e. {{currentRow.Assignment}} or {{outAssignment}}

Can anyone point me in the right direction for how once I have my row object I map the fields in that row to variables that I can then use for the Send Email?

Tagged:

Best Answer

  • Recluz
    Recluz Member
    Answer ✓

    I learned the answer. I was correct that it is "Get Text From Object" but instead of using the Object Child as the Property I just needed to select Custom and type the field name from the dataset for each that I wanted to map.

Answers

  • Recluz
    Recluz Member
    Answer ✓

    I learned the answer. I was correct that it is "Get Text From Object" but instead of using the Object Child as the Property I just needed to select Custom and type the field name from the dataset for each that I wanted to map.

  • DanHendriksen
    DanHendriksen Domo Employee

    Recluz, I would encourage you to replace the "Query Dataset" step in the template (new updated template should be out soon) with the new Query Dataset shape (click on the 3 dots on the upper right of the shape, and you should see that option).

    Alternatively, you can edit the "currentRow" object variable to add the children (remember, this is case sensitive and type sensitive) and then call those children directly. That will save you having to use the "Get Text From Object" steps to extract them to additional variables.