Comments

3 comments

  • Avatar
    Karl Makatenas

    By taking a look at the structure of the Data Grid control, it looks pretty easy in JavaScript.  Here is a quick, untested example.  Note that I reference a Text Box control named "EmailData" where I'm posting the results which you can use in the body of an email.  If you need a Text Area for more than 255 characters or for styling/formatting (HTML), then change the controls and code appropriately.

    DataGrid1 is the internal name of my data grid control.
    Column1 is the name of the first column in my data grid control.

    eFormHelper.getFieldValue({fieldId:'DataGrid1'}, function(result) {
      var body = result.data.DataGrid1[0].Column1;
      for (var i = 1; i < result.data.DataGrid1.length; ++i)
      {
        body += '; ' + result.data.DataGrid1[i].Column1;
      }
      eFormHelper.setFieldValue({fieldId:'EmailData', value:body}, function(r){});
    });

    And I just realized that this requires an event to trigger it, so it may not be useful other than attaching it to the OnBeforeSubmit event.

    Instead, if you wanted to use a loop in the Process Model, you can extract the data from a given column one row at a time and concatenate it together in an Update Process Data activity within each loop:

    SomeProcessVariable = String.Concat(${path/to/SomeProcessVariable}, "; ", ${path/to/row/looping/variable})

    0
    Comment actions Permalink
  • Avatar
    Lucas Drege

    Christopher,

    Please try the below and let me know how it goes for you. This can be achieved via the email macro portion of an email notification.

     

     

    Lucas

    0
    Comment actions Permalink
  • Avatar
    Christopher Lauss

    Thanks a lot!
    With this two different solutions i was able to solve my problem.

    0
    Comment actions Permalink

Please sign in to leave a comment.