Hey, how can I hide a specific section of a workflow attachment if a certain column is blank?
I wanted to try putting the โisblankโ expression in, but I have no idea how to implement it with the template as it will be text, a table, etc. that I would like not to show up if the column is blank.
Thanks!
Hi I think that question has been answered before. Maybe search the community.
I was able to accomplish this, but it was not easy.
First off Iโm not sure if it is possible when using a separate template file. I wrote out all the table html by hand in the Email Body section of the workflow. So youโll have to know how to write html tables with
and so forth.
Iโm assuming youโre using a <> expression? Inside the start expression put something like this: <<IF( ISBLANK([column]) , โโ , concatenate(" |
@Lynn I thought it would too, but I searched a couple different ways for it and I couldnโt find anything. The Posts I saw were not specific to workflow templates.
@Marc_Dillon Holy Cow! haha Thanks Marc! Iโll Do some more digging into HTML stuff then!
Maybe it might just be easier to have 2 workflows? One without that section and a condition for if the column is blank and another for the default one with the Section and a condition for when the column is not blank.
Depends on exactly what youโre trying to accomplish.
@Marc_Dillon Thanks man!
On second thought, perhaps your situation does not require a complicated solution. If you are using a <> expression, you can create your list of rows with a select() expression where the condition checks if a column is blank or not.
<<Start:SELECT(table name [key column] , ISNOTBLANK([column to check])>>
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |