How can I use Workflow to identify the most recent Forms submission timestamp in the "Submission Timestamps" multi-value token?
Question
Question
Replies
replied one day ago
There may be a better way, but you could do the following:
- Create tracking tokens like MostRecentID and MostRecentSubmission
- Use a For Each Value activity on submission timestamps
- Use a conditional activity on the current value to see if MostRecentSubmission is empty or less than the current value. If so, replace MostRecentSubmission with the current value and replace MostRecentID with the value at the current iteration in Submission IDs.
With this method, at the end of the For Each Value loop, you will have MostRecentID with the most recent Submission ID and MostRecentSubmission with the most recent submission timestamp.
0
0
replied one day ago
That logic sounds perfect, but it's not working for me. It's grabbing the first value in the timestamp token list and not replacing it with any greater value. It tried it both ways...assessing whether the *current iteration* was greater than the stored iteration --and-- whether the *current timestamp* value was greater than the stored timestamp value.
0
0
replied one day ago
Thank you for the tips, Kevin!
0
0
You are not allowed to follow up in this post.