I am working on a solution for the following:
We have a multi-select picklist on the Opportunity that (currently) has four values: value1, value2, value3, value4
When a new value is selected and saved, it will need to create a child record; let's call the object valueChildRecord__c.
This is easy enough to do using Process Builder if it was for a single-select picklist. However, if the Opportunity is saved with value1, value2, and value3 selected, it will need to create 3 child records with each respective value stored in a field in its corresponding record.
The next part is slightly more complicated. If the Opportunity is edited and value3 is deselected and saved, the child record that corresponds to value3 needs to be updated with a timestamp. This goes for each value, and only if the value is deselected. If, in the future, value3 is selected and saved, it should create a new record.
I understand that I will need to use Process Builder and have a Flow trigger off of it. However, I have no idea where to begin with creating the Flow. A lot of the Salesforce help pages are very shallow, whereas I need a very indepth step-by-step guide to do something like this.
Can someone verify that using a process and flow in this way is the right approach? Any assistance in the actual building of the flow or a point in the right direction is appreciated!
PRIORVALUE()
supported on multi-selects in Flow formulas? It's not shown in the doc. That doesn't make the Flow impossible, but trickier.