CBSubs: display conditionally text in proforma invoice

hello

I would like display conditionally a specific Custom text for 'Terms and conditions' on my proforma invoice. In practice that mean I would like display this text only when the invoice is unpaid (normally when using offline payment mode). When is paid I would like hide this text.

I suppose is possible using substitution with conditions but I don't know how to set the paid/unpaid condition in my substitution.

any suggestion please?

thank

All invoice text can be customized at CBSubs > Settings > Display > Invoices. Scroll to the bottom to see custom substitutions available. I believe what you'll need is [DATE_PAID], but I don't know if it'll work in an IF statement or not. It's worth a shot however; usage would be as follows.

[cb:if DATE_PAID="0000-00-00 00:00:00"]Not paid![/cb:if]

You may want to output the substitution first to see what its empty value would be though as it maybe null or just blank. Again, I don't know if this will work or not. Your alternative would be to use CB Query Field to grab their subscription and check if it is paid and output either 1 or 0 depending on its status then use the query field in an IF statement.

Unfortunately IF statement seem to be not taken in consideration. I tried also with [cb:if PAYMENT_STATUS="Completed"]Paid![/cb:if] but without success.

So I will see to use CB query but is a bit annoying to setup. Too bad conditions don't work in invoice..I suggest to you to implement this in future release...

thank