Hi- So I know just enough to be dangerous. To myself. So thanks for any help you can provide.
I am trying to time stamp records when the Status changes to Pending. I figured out the formula, but as soon as the Status changes from Pending to Published (the next step in the process), the time stamp goes away. I am trying to keep track of when writers submit their articles (marked Pending).
Is there any way to keep that time stamp - even when the Status gets changed from Pending to Published? Is there a better/smarter way to accomplish this?
I have figured out the automation, but it looks like the only thing I can do is "Run a script." But I have no idea how to do that. I need to know Java to achieve my goal? I must be doing this wrong. Any thoughts?
I may have over thought this - as you can have a "Last Modified Time" column tied to your status column.
The result is a time updated everytime specified columns are updated;
That date could then be stamped into another date column using an Automation, say if you wanted to only capture a "Record First Modified" date/time - but not subsequent changes. The Automation would look something like this.
I really appreciate your help on this. I'm so close. I'm just having an issue with the Update Record Configuration (see image #3).
I've got the Last Modified Time set. I've got the automation trigger set (see image #2).
It's just the last few steps I keep getting errors on. I want to stamp the Last Modified Time into the Pending column (see image #1) when the Status is changed to Pending. Should this column be formatted as a Date or something else?
Again, I've got the modified time set, when the status changes to Pending it schedules...well, nothing because that's where I'm hung up.
For your circled Screenshot, you're needing to place the Record that's been matched from the Conditional Trigger - basically the automation is needing the details of the record that will have it's fields updated.