Branding - Enable SKIPIF function in advanced DOCX templates
Please enable the Microsoft Word function SKIPIF for use in docx invoice templates. Currently, we can use the "IF" function in customized invoices to skip item records according to its ItemCode, but as noted by another user in the Microsoft Office discussion, a blank row will still appear for records that meet the filter test. Read a detailed discussion of the issue here: https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-word-mergefield-code-to-skip-certain/3414ecba-e0c9-46aa-90bb-b5a205d25f5a?page=1
Kenneth Schwartz
shared this idea
-
Daniel Minnick
commented
A major reason these specific fields aren’t available or consistent is the archaic state of the DOCX rendering engine. It can’t handle modern XML mapping or advanced conditional logic (like SKIPIF) reliably because it's running on nearly 20-year-old libraries. Modernizing the parser to OOXML v16 would allow for the robust field mapping we actually need. I've detailed the specific mapping failures and the path to a fix here: https://productideas.xero.com/forums/967115-invoices-quotes/suggestions/51245914-modernize-advanced-templates-full-support-for-mod