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.
This is the TOTALHOURS expression i use.
_________
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! Go to Solution.
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.
<<IF(
AND(
ISNOTBLANK([Start Time]),
ISNOTBLANK([End Time])
),
[Total Hours],
""
)>>
Simon, 1minManager.com
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |