With workflow, I'm performing a search for all documents that have the word "Monthly" in a particular field. This field is a multi-value, and some of the values do NOT have the word "Monthly". So within my workflow, I then specify "for each entry" (from my search results), "retrieve field values", and then I have a "For Each Value".
I use tokens because this field has 3 items in each. A condition, a date, and cycle. An example would be:
Insurance document;03/14/2015;Monthly
My tokens extract all 3 of those items nicely. I then use a conditional sequence to verify that the current value of the date is today's date.
I want to update the one multi-value field that has a date equal to today and then use a date token generator to add 1 month to it, but I cannot find a way to just change that one, it changes all of the multi-value fields.
Example:
Before Workflow runs:
Insurance document;03/14/2015;Monthly
Signing document;08/10/2015;Weekly
Court document;01/20/2015;Monthly
After workflow runs:
Insurance document;04/14/2015;Monthly
Insurance document;04/14/2015;Monthly
Insurance document;04/14/2015;Monthly
You've only got a choice of Append to existing values, which creates a new multi-value field.
Replace existing values wipes out the other multi-values.
Clear all values - clears everything.
I'm sorry I cannot post a pic it's a customers and it's confidential. I hope I explained it well enough.
Thanks for your help!