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
------------------------------
Hi Doug...this did not work. For some reason it got added to every record, not just the ones with a May birthday. Also, the code didn't like the quotes around May so I removed those. I did try a couple other options, but it still isn't populating only when May is the birth month. The other thing for this is that if the 'month field' already has 'birthday' in it, then I don't want it to add it again. This will be a scheduled pipeline to run daily.
------------------------------
Amy Gosz
------------------------------Hi Amy, can you post your code? The quotes around May are absolutely required for checking equality of strings, so I'm guessing you have another error in your code.
------------------------------
Doug Henning
------------------------------HI Doug...I copied your code, but did go back and shorten the birth month field names. Here is my code that is adding Birthday Month to every record. "May" is in red in the code.
{% if (a.familymem_1_birth_month_3_charac == "May" or a.familymem_2_birth_month_3_charac == "May") and not a.may_touch %}
Birthday Month
{% else %}
{{ a.may_touch }}
Birthday Month
{% endif %}
------------------------------
Amy Gosz
------------------------------