Skip to main content
Nintex Community Menu Bar

For each collection working on 3 of 4 variables/HTML table incorrect formatting

  • September 27, 2021
  • 3 replies
  • 8 views
  • Translate

Forum|alt.badge.img+1

I have 2 problems.  Details will be below the 2... 

 

1. HTML table in email is not lining all the rows and instead only 1 box in every other row. 

2. Collection variable not displaying when using a for each. 

 

1. See screen shot 

          Screenshot with the code is what it should look like based on the HTML simulator. 

19862i7F0909E9DB0DE31D.png

          Screenshot with the email of what is actually produced. 

19863iFE196C420B3BCE4A.png

          The information comes from collection variables looped through a "for each". I have a comment log for each "for each" and ccan confirm the loop is working correctly and that the data in the email is accurate, just the formatting is wrong. Screenshot below of the loop. 

19864i5BA5A0CC8116DAFD.png

 

2. 2nd data collection operation not working as intended. 

           Screenshot below is the history log. Based on this I can see that the colleciton is pulling correctly as the names follow what they should. HOWEVER the last 2 comments are the "for each loop" that is pulling ONLY the title incorrectly. 

19861iA32CDE0EB4D6C290.png

 

This is the list query.  ( I do have a filter of when Workflow instance ID = Workflow Instance ID) the information pulls fine, its the "for each" that is failing.

19865i98A2B49F77AC4587.png

Screenshot of the loop. 

19866iE50C17E085D6DE33.png

 This is the WFTitle collection operation

19868iA4EB1FF369341448.png

- it matches every other one you see. 

** NOTE this was a test run for screenshots, so it appears that Program/outcome/people assigned does not work, but they do. I just skipped it for speed. 

 

ALSO if anyone knows a smarter way to accomplish these goals, I am all ears!

 

 

 

 

Did this topic help you find an answer to your question?

3 replies

MegaJerk
Forum|alt.badge.img+14
  • Scholar
  • 832 replies
  • October 26, 2021

Let's start with the first issue. 

Can you post your starting Table html, and your resulting html after the workflow has put together your complete table? 

 

Please remove any identifying information, but without actually seeing the resulting html it's almost impossible to help. 

 

By using the Code Block, you can simply paste your code into your reply so that we can easily copy / paste it. To do that, look at the controls above the body of your reply textarea, and expand the controls by clicking on the ellipsis (three dots "..."): 

 

From there find the Insert /Edit code sample tool: 

 

And then, in the new pop up window, select the type of code you're pasting into it (in this case HTML/XML) and then paste your code into the text area. Once you've finished, you can simply click on the OK button: 

 

Thank you

 

 

Translate

Forum|alt.badge.img+1
  • Author
  • 4 replies
  • December 16, 2021

Thanks for the response. 

I was able to resolve the issue. 

 

Here is the code that was introduced into 2 different build strings. The issue was with the build table action, I was missing 2 ' marks within the code. 

 

START..... This is placed within the "for each" loop with all the collection operations. 

{WorkflowVariable:WF2VarReport}<tr align="center">
<td style='color:#161717;font-weight; border: 1px solid #10407a;'>{WorkflowVariable:WF2IDTxt}</td>
<td style='color:#bc9a31;font-weight; border: 1px solid #d9d9d9;'>{WorkflowVariable:WF2OutcomeTxt}</td>
<td style='color:#161717;font-weight; border: 1px solid #d9d9d9;'>{WorkflowVariable:WF2ApprovalCommentTxt}</td>
<td style='color:#161717;font-weight; border: 1px solid #d9d9d9;'>{WorkflowVariable:WF2TitleTxt}</td>

BUILD .... This is placed after the "for each" loop

<table cellpadding="2" style='border-collapse: collapse; border:1px solid #d9d9d9; font-family:"Helvetica","sans-serif";'><tr>
<td colspan="9" bgcolor="#edf1f5" align="center" style='font-size:20.0pt;font-family:"Helvetica","sans-serif";color:#293642; font-weight:bold'>ITAM Software List</td></tr><tr><td></td></tr><tr>
<td colspan="9" align="center" bgcolor="#edf1f5" style='font-family:"Helvetica","sans-serif";color:#293642'>The information below is for the ITAM workflow started on - {WorkflowVariable:StartDate} </td></tr><td></td></tr><tr><td colspan="9" align="center" bgcolor="#edf1f5" style='font-family:"Helvetica","sans-serif";color:#2874A6'>Action 1 (provide POR contacts) due date: - {WorkflowVariable:Action 1 -Due Date}</td><td></td></tr><tr>
<td colspan="9" align="center" bgcolor="#edf1f5" style='font-family:"Helvetica","sans-serif";color:#2874A6'>Action 2 (provide updated data) due date: - {WorkflowVariable:Action 2 - Due Date} </td>
<tr align="center" bgcolor="#18458c" style='font-weight:bold; font-family:"Helvetica","sans-serif";color:#ffffff'><td style='border: 1px solid #d9d9d9;'>ID</td>
<td style='border: 1px solid #d9d9d9;'>Outcome</td>
<td style='border: 1px solid #d9d9d9;'>Comments</td>
<td style='border: 1px solid #d9d9d9;'>WF Task Title</td>{WorkflowVariable:WF2VarReport}</td>
Translate

MegaJerk
Forum|alt.badge.img+14
  • Scholar
  • 832 replies
  • December 20, 2021

excellent that it's solved! Don't forget to mark your answer as the solution to this problem!

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings