Forum Discussion
Code to hide lines where the MergeField is Zero, using IF
helens63 Are you saying that you want to conditionally hide some of the columns, INCLUDING the header of the column. If that is the case, you will need to conditionally display variations of the table with each variation only containing the wanted columns.
Doug_Robbins_Word_MVP Hi Doug, thank you for entering this conversation. My understanding of the terminology might be incorrect. When you say the header row I'm thinking that means the titles, or the first row of the table. I don't want to hide that. It will be fine to display the header row, even if some of the rows underneath are empty. But for any particular row, if the Current Claim is 0, then we don't want to display anything on that row. I've found it easy enough to stop the Current Claim part not showing, but not the other columns for that row. The owner is thinking that if there is no Current Claim for part of the Quote, then he doesn't want to show the original Quoted price, what's been claimed before and what's still outstanding for that particular part of the quote, on that invoice.
helens63 Sorry, I have not been able to determine exactly what the criteria is, which might be me, or it might be because you have used a term "Current Claim", rather than the relevant MergeField name. Can you re-phrase the requirement, making use of the actual MergeField names.
I am not sure how WorkflowMax processes the data, but the Many to One facility of my MergeTools Add-in, which can be used from creating output for items such as a multi-line invoice, the test for a field that is empty must be for " " rather than "".
Doug_Robbins_Word_MVP Hi Doug. I'm sorry I'm not much help myself. I've done another snip with the merge field codes revealed but I'm unsure if that's what you mean. The Merge Field that is showing as highlighted in grey is the problem one that doesn't work. I'm trying to say in that field to look at the field under "This Invoice" heading and if that one is Zero, then not to print.
