Team,
Challenge: a workflow is created for a report that disseminates to a reader base via email; part of the email body presents tables within the MANAGE LAYOUT tool in which occasionally there will be no data to present in the table and within the email body the space designated for the table will be blank; in this situation, I am looking to add a text string to that blank spot should there be no data table to add.
Summary: IF data table is present, present table in email body, IF NO data table is present, present text string "No Errors Today" in same email body location
How is this done?
Hi @Xervarian
I may have an idea that might work for this. Before you render the table, bring on a Formula Tool that has a condition that follows this logic: IF IsNull([Table]) THEN "No Errors Today" ELSE [Table] ENDIF. This way you can account for the instance it is blank, and also still bring in the correct table if data persists.
Hi @Xervarian
One way of doing this
Result when there is no data on the table
Result when there is data on the table