You are viewing limited content. For full access, please sign in.

Question

Question

Identify the *Most Recent* Submission Timestamp

asked on November 19, 2024

How can I use Workflow to identify the most recent Forms submission timestamp in the "Submission Timestamps" multi-value token?

0 0

Answer

SELECTED ANSWER
replied on November 19, 2024

The timestamps should be in sequential order, so you can use the token editor to get the last item.

1 0
replied on November 19, 2024

Thank you, Jason!

0 0

Replies

replied on November 19, 2024

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 on November 19, 2024

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 on November 19, 2024

Thank you for the tips, Kevin!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.