Hi all, Is there a way to use a showif in a...

(Elan Bailey) #1

Hi all,

Is there a way to use a showif in a workflow report?

I have a table that has about 10 fields in it. I want to some of these fields so they show up each time I run the report. But some of the fields I only want to include if they’re not blank. Is there a way to accomplish this without having to split the fields into two different tables?

(Philip Garrett) #2

@elan_Bailey

There is no way to conditionally include or exclude content at the moment.

(Elan Bailey) #3

@Philip_Garrett_Appsh Thanks for letting me know.

(Aleksi Alkio) #4

May I ask why don’t you just add that field into the template or body text… if the value is blank, it doesn’t fill anything into that field.

(Elan Bailey) #5

@Aleksi_Alkio yes I have done that. But each field has a label so when the report prints I end up with a bunch of labels that have no text. To be more clear, I’d like it if the label and text field do not show up in the report if the field is blank.

(Aleksi Alkio) #6

Because you don’t have control with Show_If as Philip mentioned, you need to create that functionality by yourself. You can use the same method for headers… like <<IFS(ISNOTBLANK([Column]),“Header”)>>.

(Elan Bailey) #7

@Aleksi_Alkio Wonderful. This did the trick. Thank you