Workflow Report expression

Jin_Tan
Participant V

Hi,

I want to show a table in my workflow report only when certain condition is met. I tried to use IF() function, but it does not work for table. I can only use If function for the words inside the table.

Does anybody know if there is any solution to this?

Thank you

Solved Solved
0 11 599
1 ACCEPTED SOLUTION

Hi guys,

I solved it by reading this article. Thanks Appsheet team for this article. It helps. Yay:)

I was using <<IF([Condition], True, False)>> so it didnt work.

This expression in the link works.

View solution in original post

11 REPLIES 11

Lynn
Participant V

Hi @Jin_Tan Could you please expand on what you are trying to achieve.

Hi,

i am trying to create a workflow report with page. Workflow pagination, headers and footers.

But this table(Check the attachment picture)appears on every page. I want it to appear on the last page only.
2X_d_d5e4936733bd3a08b5f4f489cf31bcbbc3a628be.jpeg

What i was trying to do was using IF(condition, [insert the whole table], " "). However, IF() does not work for table.

Hi guys,

I solved it by reading this article. Thanks Appsheet team for this article. It helps. Yay:)

I was using <<IF([Condition], True, False)>> so it didnt work.

This expression in the link works.

<<Start: Submit 2 ID's Report[Key Timestamp]>> <<IF: AND(( 
Submit 2 ID's Report
[Needs to Submit 2 Forms of ID]= TRUE), ISBLANK([ORIENTATION]))>><< [2 Forms of ID]= TRUE>> <<EndIf>><<IF:( 
Submit 2 ID's Report
[Needs to Submit 2 Forms of ID]= FALSE)>> <<[2 Forms of ID]=FALSE>><<EndIf>> <<
Submit 2 ID's Report
[Still Needs to 2 Forms of ID]>>

Please help me I am getting Failed: Action not performed because 1 errors are present. Error: Workflow rule โ€˜Has Submitted ID Reportโ€™ action โ€˜Email Taskโ€™ Attachment template. Found 1 unmatched โ€˜Startโ€™, 1 unmatched โ€˜Endโ€™, 2 unmatched โ€˜EndIfโ€™. They are:

<<Start: Submit 2 IDโ€™s Report[Key Timestamp]>> <<IF: AND((

', '

[Needs to Submit 2 Forms of ID]= TRUE), ISBLANK([ORIENTATION]))>><< [2 Forms of ID]= TRUE>> <><<IF:(

', โ€˜

[Needs to Submit 2 Forms of ID]= FALSE)>> <<[2 Forms of ID]=FALSE>><> <<

โ€™, '

<>

.

Do you have an <<End>> tag for every <<Start>> tag?

Do you have an <<EndIf>> tag for every <<If>> tag?

Yes thats what is throwing me for a loop. Unless I am missing something. Please a fresh pair of eyes is highly appreciated!

The template snippet you posted does not contain an <<End>> tag.

This is my VC SELECT(Delivery Associate[_ComputedName], IFS(AND(ISBLANK([ORIENTATION]), [Needs to Submit 2 Forms of ID]= true), [2 Forms of ID]= true, [Needs to Submit 2 Forms of ID]= false, [2 Forms of ID]=false))

Please Steve thats not the issue

Sounds like you must know what the issue is, then.

And you sound really bored when I have a real issue so please stop

Top Labels in this Space