I have a 'On New Event' pipeline to create a record in a Review Log table triggered on a change to a checkbox field - either checked or unchecked. If the checkbox is checked, the Approved field in the Review Log table should read 'yes'. If unchecked (was checked), then it should read 'no. However, it is reading 'no' for both checked and unchecked changes. I found the Jinja code somewhere but am unable to find it again so can't compare if I'm missing something. Here is my code for populating the Approved field with the pipeline during the Create Record step:
{% if a.review_food_security_approved == TRUE %}
yes
{% else %}
no
{% endif %}
So if the checkbox is checked, it is still recording a 'no' and I don't know why. What am I missing in my code?
------------------------------
Amy Gosz
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.