Forum Discussion
SeanConnaughto1
4 years agoQrew Cadet
You can use the {{CLEAR}} code:
{% if c.call_rating != '' %}
Call Rating: {{c.call_rating}}
{% else %}
{{CLEAR}}
{% endif %}āā
{% if c.call_rating is defined %}
Call Rating: {{c.call_rating}}
{% else %}
{{CLEAR}}
{% endif %}
Check out the documentation if you have the time, it's very helpful: https://help.quickbase.com/pipelines/transforming_data.html
------------------------------
Sean Connaughton
------------------------------
- DanielJohnson24 years agoQrew TraineeHey Sean,
Thanks for the reply, but that didn't work. I still got "Call Rating:" in the email output with nothing after it.
------------------------------
Daniel Johnson
------------------------------- DanielJohnson24 years agoQrew TraineeI just tried:
and got the same result. The output email still has "Call Rating:" with nothing after it.{% set rating = 'Call Rating: ' %} {% if c.call_rating is defined %} {{rating}}{{c.call_rating}} {% else %} {{CLEAR}} {% endif %}ā
------------------------------
Daniel Johnson
------------------------------ - SeanConnaughto14 years agoQrew CadetDoes this work?
{%- if c.call_rating %} Call Rating: {{c.call_rating}} {% else %} {{CLEAR}} {% endif -%} ā
------------------------------
Sean Connaughton
------------------------------- DanielJohnson24 years agoQrew TraineeIt's possible the {{CLEAR}} is clearing the entire email body because I keep getting an error that says "Validation error: {'body': 'required field'}" even though there's plenty of other text and fields in there before this part. Thoughts?
------------------------------
Daniel Johnson
------------------------------