Does Upper() and ABS() work in google docs email templates? I am trying to create pdfs via workflow.
Thanks.
All expressions should work in templates, to my knowledge. Certainly ABS() and UPPER(). Are you having problems?
Hi Steve, yes I had <<ceiling([amount])>> which worked, but when I tried upper on my text column and abs on the [amount] column, it didnt work.
Please provide a screenshot of the non-working portions of the template.
ABS() does not work on quantity, unit price, discount, tax, and total amount. They are all price type columns. I managed to get upper() to work. Also, do I need to use <<if: for each column? I couldnt get it to work when I put it at the beginning and at the end of the table.
I would suggest removing the <<If:>>
and <<EndIf>>
tags in favor of replacing your <<Start>>
expression with:
<<Start: SELECT([Related Invoice Details], ("item" = [type]))>>
Thanks Steve, what about abs? Any idea why itโs not working? Ceiling works fine.
I need to look into this more. Iโll try to do so tomorrow.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |