QuoteWerks Support Portal

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!

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.

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.