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

Question

Question

Identify the *Most Recent* Submission Timestamp

asked one day ago

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 one day ago

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

1 0
replied one day ago

Thank you, Jason!

0 0

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.

Sign in to reply to this post.