@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------------------------------