Data from Datagrid

フォローする

Christopher Lauss

• 2019年04月11日 05:44

Is it possible to get out the data of a datagrid?
e.g. I want to write "test21" in a mail, but also "test11" if an entry is present.

0

• 

  Karl Makatenas

  • 2019年04月15日 13:14
  • 編集済み

  

  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

  コメントアクション パーマリンク
• 

  Lucas Drege

  • 2019年04月15日 19:55

  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

  コメントアクション パーマリンク
• 

  Christopher Lauss

  • 2019年04月16日 08:23

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

  0

  コメントアクション パーマリンク

サインインしてコメントを残してください。