How can i hide certain value in automated PDF document

Hello, i'm making an app for the employees to log in their work duration and the data will be automated into PDF files.

My issue is with the PDF document created. Is there a way i can only show the TOTALHOURS calculated when there is start_time & end_time entered into the field?

As you can see here, when theres NO start_time & end_time inserted, the totalhours will return as 0.00 and hence it will be automatically inserted into the PDF document. 

TOTALHOURS Visibility.png

 

 





This is the TOTALHOURS expression i use.
_________

template bikswp2.png

 

 

 

 





This is the automated PDF document created. 
If the TOTALHOURS returns as 0.00, i plan to hide it in the automated PDF document.

Is there a way i can hide the TOTALHOURS in the PDF document when it returns as 0.00?

Solved Solved
0 12 477
2 ACCEPTED SOLUTIONS

In the PDF template, for the table data you are likely using some list OR expression to choose the rows to be included.  Use an expression that chooses the data rows meeting your required criteria to be shown.  

If you show us the template expression you are using we can help update it.

View solution in original post

<<IF(
AND(
ISNOTBLANK([Start Time]),
  ISNOTBLANK([End Time])
),
[Total Hours],
""
)>>

 Simon, 1minManager.com

View solution in original post

12 REPLIES 12
Top Labels in this Space