Pipeline help
Hello, currently I have 3 pipeline set to updates the dates. I am using the workflow of record updated and update records, but I am running into issue where it isn't properly recording the date/tim...
Forum Discussion
I am going to make an assumption and say that the first attempt, second attempt, and third attempt Date/Time fields are in the same record. In this case, I would use structure the pipeline so that it used Jinja2 Expressions (more specifically, Logic Conditions) to determine if the value in a field should be updated to the current date/time or not:
Trigger: Record Updated
When: Attempt is changed AND (Attempt == "first" OR Attempt == "second" OR Attempt == "third")
Action: Update Record (from trigger)
Update field values to:
First Attempt:
{% if a.attempt = "first" %}
{{time.now}}
{% else %}{% endif %}Second Attempt:
{% if a.attempt = "second" %}
{{time.now}}
{% else %}{% endif %}Third Attempt:
{% if a.attempt = "third" %}
{{time.now}}
{% else %}{% endif %}------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------
- Hello Justin,
Thank you for the answer. I am still running into validation issue for this pipeline. Not sure what might be the reason. It says expected token 'end of statement block', got"="
My code is:
{% if a.number_of_attempts = "First Attempt" %}
{{time.now}}
{% else %}{% endif %}
Please let me know if you have any idea regarding this.
Thank you,
Fanil
------------------------------
XYZ
XYZ
------------------------------- The comparison of equals in Jinja is ==, like this:
{% if a.number_of_attempts == "First Attempt" %}
------------------------------
Doug Henning
------------------------------- Thank you that works
------------------------------
XYZ
XYZ
------------------------------
