Code to hide lines where the MergeField is Zero, using IF
Hi.
I use software called WorkflowMax which uses MSWord format for custom Invoice Templates. There is a type of Invoice which shows several columns of data for each item on the invoice inlcuded Original Quoted Price, what was Previously Claimed, what’s being claimed on the current invoice, and what is remaining as outstanding.
I have managed to work out the code to not show a “0.00” for any particular field when the value of the field is Zero so that part is all good. As below in the third line where there is no “Claimed Incl This Invoice” for the Task “Consulting RMA Ecology”, nothing prints.
However, I need conditional code so that I can not show all 4 columns of a specific line, if just one of those columns is Zero. ie. if Nothing is being claimed on part of the quote in an invoice, then I don’t want to print the other columns for that line, which do still have values (Task Name / Quoted / Previously Claimed/ Claimed Incl This Invoice / Balance Remaining). So as an example, to not show the Quoted column it will need to look and see if there is a zero value in the “This Invoice” column. I’ve really had a go with it but just can’t make it work!
Hi. I use software called WorkflowMax which uses MSWord format for custom Invoice Templates. There is a type of Invoice which shows several columns of data for each item on the invoice inlcuded Original Quoted Price, what was Previously Claimed, what’s being claimed on the current invoice, and what is remaining as outstanding.I have managed to work out the code to not show a “0.00” for any particular field when the value of the field is Zero so that part is all good. As below in the third line where there is no “Claimed Incl This Invoice” for the Task “Consulting RMA Ecology”, nothing prints.However, I need conditional code so that I can not show all 4 columns of a specific line, if just one of those columns is Zero. ie. if Nothing is being claimed on part of the quote in an invoice, then I don’t want to print the other columns for that line, which do still have values (Task Name / Quoted / Previously Claimed/ Claimed Incl This Invoice / Balance Remaining). So as an example, to not show the Quoted column it will need to look and see if there is a zero value in the “This Invoice” column. I’ve really had a go with it but just can’t make it work! Read More
