Skip to main content
Question

Pipeline help

  • December 7, 2022
  • 0 replies
  • 65 views
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/time.
The use case is:

1) If the attempt= first, update first attempt=current date/time
2) if the attempt=second, update second attempt= current date/time
3) if the attempt=third, update third attempt= current date/time

So all three pipelines are having the data but sometime it is recording incorrectly. Could you please advise if I am able to use this case in only one pipeline. Let me know.

Thank You

------------------------------
XYZ
XYZ
------------------------------
    This topic has been closed for replies.

    @XYZ

    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
    ------------------------------
    Terms & ConditionsAccessibility statement