Solved

Conditional Rows Based on Multi-Select Picklist

  • 17 June 2019
  • 4 replies
  • 81 views

Hi,

I have a multi-select picklist in Salesforce with values A, B, C, and D.  I want to only show rows of a table in my Word template if the corresponding value is chosen in the multi-select picklist.  For example, if I select A, B, and D from the picklist, I would want the entire row for C below to be hidden.  Is this possible?

 

Header 1 Header 2
A 1
B 2
C 3
D 4

 

Thanks,
Scott

icon

Best answer by leighburke 19 June 2019, 01:04

View original

4 replies

Userlevel 5
Badge +13

Hi Scott,


 


Can you confirm if you are trying filter the data going into the table, or are looking to remove a row in an existing table?


 


Cheers,


Leigh

Hi @leighburke,


 


I’m open to suggestion, but I have an existing table with a row for each value in the multi-select picklist. I would like to hide any rows that are not selected from the picklist.


 


Thanks,


Scott

Userlevel 5
Badge +13

Hi Scott,


 


There isn't really a way to delete/hide rows in a table in Word alone, you can use conditional text(https://help.nintex.com/en-US/docgensf/Templates/ConditionalTextInWord.htm) to hide text or even a whole table but not a single row. You could use Excel to make the table and Excel as middleware to bring it into the template(https://help.nintex.com/en-US/docgen/docservices/#docgen-sfdc/Services/templates/ExcelMiddleware.htm).


 

Ok, thanks @leighburke 

Reply