Hi there! How can I show a specific word in ...

(SABIO Soporte) #1

Hi there!

How can I show a specific word in a doc template for a workflow rule if a particular cell is blank or notblank?

Eg: I had a checklist table, where I need to have a report of the questions that have been asnwer or not. But I don´t need to see the answer per se, I just need to see if the cell on that row is blank or not.

Many thanks!

(Aleksi Alkio) #2

You could write a IF (or IFS) statement like <<IF(ISBLANK([Column]),“Blank”,“NotBlank”)>>

(SABIO Soporte) #3

@Aleksi_Alkio

Hi!

I just try this:

<<IF(ISBLANK([Column]),“Blank”,“NotBlank”)>><> And for some reason is not showing anything in the workflow doc template when I received the email.

(Aleksi Alkio) #4

Is the whole template blank or just the last column?

(SABIO Soporte) #5

@Aleksi_Alkio

No, the first column of the template show a name and an ID, the other columns of the template must show the values in the IF formula. I am plannig to do this in a 100 columns.

(SABIO Soporte) #6

@Aleksi_Alkio

If you are asking for the template that arrives to the email, yes, it is all blank. check the pic

(SABIO Soporte) #7

@Aleksi_Alkio

Any other thought on this?

(Aleksi Alkio) #8

There are two reasons for this behavior… the list is empty or the FILTER expression is wrongly constructed.

(SABIO Soporte) #9

@Aleksi_Alkio

Ok thanks! Translate

(Aleksi Alkio) #10

Is the Column name correct?

(SABIO Soporte) #11

@Aleksi_Alkio

Yes it is

(Aleksi Alkio) #12

Why do you have that <>? Are you using <Start:> as well?

(SABIO Soporte) #13

@Aleksi_Alkio

Yes, I am using a <>

(Aleksi Alkio) #14

Would you please show the whole “section” so we could understand the possible reason.

(SABIO Soporte) #15

@Aleksi_Alkio

I just share you the doc

(Aleksi Alkio) #16

You had this… <<IF(ISBLANK([Column]),“Blank”,“NotBlank”))>> where you should use <<IF(ISBLANK([Column]),“Blank”,“NotBlank”)>>

(SABIO Soporte) #17

@Aleksi_Alkio

The formula is working perfect if I test it in the expresion builder. But when I triger the workflow, In the email doc is not showing any data. If the column beloging to the table has an editable if filter expresion, that could be the issue why I am not seeing ant data in the email doc?