Skip to main content
Nintex Community Menu Bar

add conditional table row (in place)

  • Feb 25, 2020 6:55 PM UTC
  • 5 replies
  • 198 views
  • Translate All

I'm trying to figure out the most efficient way to conditionally add two rows of data in the middle of a table. 

 

Lets say I can have up to 4 rows of data and always have at least 2 rows. The 2 conditional rows need to be added in the 2nd and 3rd position when present or just 2nd position if 1/2 is present. All data would be on the same object and could potentially be on a middleware excel file. 

 

I know I could use multiple templates and maybe even multiple tables in my excel file.

 

If you all have any ideas lmk in the meanwhile i'll be tinkering. 

 

Thanks

5 replies

Forum|alt.badge.img+14
  • Nintex Employee
  • Feb 25, 2020 10:26 PM UTC

Hi @Doc503,

 

You could have 2 tables in your DocGen package and use conditional text(https://help.nintex.com/en-US/docgensf/Templates/ConditionalTextInWord.htm) to show/hide the correct table. You can copy paste an entire table inside the condition.

Translate

  • Author
  • Rookie
  • Feb 25, 2020 10:39 PM UTC

Right but that solution would require 4 tables in the scenario I listed above.

 

Table 1 - 1,4

Table 2 - 1,2,4

Table 3 - 1,3,4

Table 4 - 1,2,3,4

 

Wouldn't every conditional combination need to have it's own table?

 

For a use case with up to 10 variable rows of data where the ends are static, this solution seems a bit bulky. 

Translate

Forum|alt.badge.img+14
  • Nintex Employee
  • Feb 26, 2020 12:36 AM UTC

Hi @Doc503,

 

It is a little bit bulky but it would allow you to just use Word and is the easiest to implement, other than the multiple template option you mentioned. You could use excel as middleware, I am just not sure what logic you would use to create the dynamic table missing middle rows without knowing what the data looks like.

Translate

  • Author
  • Rookie
  • Feb 27, 2020 11:00 PM UTC

It would be nice if there was an option to put a table into a component. 

 

I'm sure I could determine which table to use in excel, can I put the table name in the word merge field or do I need to actually paste the entire table into the merge field?

Translate

Forum|alt.badge.img+14
  • Nintex Employee
  • Feb 28, 2020 1:54 AM UTC

@Doc503 Copy paste the entire table in the merge field.

Translate