Solved

how to use 'is blank' filter on component group

  • 12 May 2023
  • 4 replies
  • 120 views

Badge +1

I’d like to filter a component group to display only when a field has content. Or, put another way, if the field specified in the filter is blank then I don’t want the component group to be pulled through on to the document.
My specific use case is that I have a component group which is just a title or header of ‘Additional Terms’. If no additional terms have been specified on the opportunity then I don’t need the title for that blank field.
I can see that there is a filter of ‘is blank’ and my instinct was to write ‘false’ in to the filter criteria thinking that would equate to “If this field is not blank then display this component group otherwise don’t”.
But this doesn’t seem to work. I can’t find anything in the documentation about how to do this. Is there anyone who happens to know how to achieve this?
Many thanks in advance for any help.

 

icon

Best answer by matthew_mcgrath 5 June 2023, 16:08

View original

4 replies

Badge +3

@Mel_Stephenson - try using the “not equal to” Operator. Then leave the Value field blank.

Let me know if that works. 

Badge +1

Hi Matthew, thanks very much for taking the time to answer this - much appreciated. In the end I solved this by using a formula within the Word template but I’m sure that your solution would also work.

Out of curiosity, is there any documentation or can you just let me know what the valid / expected / permitted values are for the argument ‘is blank’? 

 

Many thanks in advance

Badge +3

@Mel_Stephenson unfortunately I could not find any documentation on ‘is blank’.

I believe when using the ‘is blank’ operator, you simply need to leave the Value field blank/null (don’t type anything in it).

Badge +1

thank you Matthew

Reply