Forum Discussion

Qrew Trainee

4 years ago

Jinja2 Pipelines question, so nothing if field is empty

Hi All, I'm trying to get a pipelines email step to only show the text "Call Rating:" if the call rating field is not blank. I've tried: {% if c.call_rating != '' %} Call Rating: {{c.call_rat...

SeanConnaughto1

Qrew Cadet

4 years ago

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
------------------------------

DanielJohnson2
Qrew Trainee
4 years ago
Hey 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
------------------------------
- DanielJohnson2
  Qrew Trainee
  4 years ago
  I just tried:
  
  {% set rating = 'Call Rating: ' %} {% if c.call_rating is defined %} {{rating}}{{c.call_rating}} {% else %} {{CLEAR}} {% endif %}
  and got the same result. The output email still has "Call Rating:" with nothing after it.
  
  ------------------------------
  Daniel Johnson
  ------------------------------
- SeanConnaughto1
  Qrew Cadet
  4 years ago
  Does this work?
  
  {%- if c.call_rating %} Call Rating: {{c.call_rating}} {% else %} {{CLEAR}} {% endif -%}
  
  ------------------------------
  Sean Connaughton
  ------------------------------
  - DanielJohnson2
    Qrew Trainee
    4 years ago
    It'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
    ------------------------------