Conditional printing : QuoteWerks Support Portal

D

Dara Bettencourt

started a topic about 5 years ago

Hi, I am trying to print the contract term on the proposal as a phrase rather than a number but it does not work correctly. The code I placed in a formula field is

.if.documentitems->customtext06="12".then."1 YEAR TERM".else.

.if.documentitems->customtext06="24".then."2 YEAR TERM".else.

.if.documentitems->customtext06="36".then."3 YEAR TERM"

It only prints when it reads the 36. Are multiple else statements allowed in the formula field or just level?

Thank you!

Best Answer

S

Steve Siggs said about 5 years ago

Multi-level should definitely be possible and what you've got looks good. I think that it could be just a couple of brackets that you need. Try the following:

.if.documentitems->customtext06="12".then."1 YEAR TERM".else.(.if.documentitems->customtext06="24".then."2 YEAR TERM".else.(.if.documentitems->customtext06="36".then."3 YEAR TERM"))

I've not tried it and so if that doesn't work, then let me know and I'll give it a try myself.

Matt Rose ([email protected])

said about 5 years ago

Yeah, that formula won't work.

https://www.quotewerks.com/kbase/showArticle.asp?articleid=5458

Take a look at the KB article above, that should help.

Steve Siggs

said about 5 years ago

Answer

Multi-level should definitely be possible and what you've got looks good. I think that it could be just a couple of brackets that you need. Try the following:

.if.documentitems->customtext06="12".then."1 YEAR TERM".else.(.if.documentitems->customtext06="24".then."2 YEAR TERM".else.(.if.documentitems->customtext06="36".then."3 YEAR TERM"))

I've not tried it and so if that doesn't work, then let me know and I'll give it a try myself.

How can we help you today?