Pipeline code using 'or' and 'and'
We need to populate a 'month' field if family member 1 or family member 2 has a birthday that month. Each month has its own field. In this example, I am using the MAY TOUCH field. So, if (family membe...
Forum Discussion
Yes, there is one field for each month. These fields are used as prompts for what type of contact may be needed. We do not capture full dates for the birthday and in many cases only know the month. If there is already text in the month field, then we don't want to overwrite that, only add on additional note about it being a birthday month. If there is no text, then we will just populate it noting that it is a birthday month.
12 Month fields - text, multiple lines
3 charac Month field - text
Family Member 1 and 2 fields - text
I am trying to figure out how the pipeline can check for values in the month field and if no value, populate with 'Birthday Month'. If there is a value, then keep current value and add 'Birthday Month'.
------------------------------
Amy Gosz
------------------------------
Don's original reply is correct, you need to use == for the comparison and put quotes around the value to compare. This will add to the may_touch field if a value exists, or set it to "Birthday Month" if empty.
{%- if (a.account_number_family_1_birth_month_3_charac == "May" or a.account_number_family_2_birth_month_3_charac == "May") and not a.may_touch %}
Birthday Month
{% else %}
{{ a.may_touch }}
Birthday Month
{%- endif %}
------------------------------
Doug Henning
------------------------------