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
Amy,
I am not a Jinja guru. @Prashant Maheshwari @Doug Henning are the kings of this. However I think your expression has the wrong operator and the text value needs quotes.
a.account_number_family_1_birth_month_3_charac == 'May'
------------------------------
Don Larson
------------------------------
I am not a Jinja guru. @Prashant Maheshwari @Doug Henning are the kings of this. However I think your expression has the wrong operator and the text value needs quotes.
a.account_number_family_1_birth_month_3_charac == 'May'
------------------------------
Don Larson
------------------------------
== is a comparison operator to compare two objects so I don't thnk it would be used in this case.
------------------------------
Amy Gosz
------------------------------
------------------------------
Amy Gosz
------------------------------
- Amy,
I looked at this again and may have a non Jinja solution for you.
FID 111 is a Date
FID 112 is a Date
FID 113 is a Text
# Character Date Search
#
# Account slugs:
# - quickbase[XXXX]: Pipeline Token <None>
---
- META:
name: Character Date Search
- QUERY quickbase[XXXXX] record search -> a:
inputs-meta:
export_fields: '"Touch, OneCharacter, TwoCharacter" <113, 111, 112>'
query: ({111.EX.'May'}OR{112.EX.'May'})AND{113.EX.''}
table: '"Parents: Parent" <bp4igy3re>'
- a<>LOOP:
- DO:
- a<>ACTION quickbase record update -> b:
inputs:
touch: May
...
------------------------------
Don Larson
------------------------------- All fields are text fields, the '3 charac' field is capturing the 3 letter abbreviation used for months. I am not querying or using date fields for this.
------------------------------
Amy Gosz
------------------------------- My apologies for typing without thinking. In the App where I built the Pipeline I did use Text fields
I tested this on multiple records. If [Touch] is null and either [OneCharacter] or [TwoCharacter] has the value of "May", then the [Touch] field is written with the value.
------------------------------
Don Larson
------------------------------