I have SPD 2010, but do not have access to additional coding options. Any help would be greatly appreciated.
Scenario: Users enter items in a list through an OOTB SP "Add New Item" form. For simplicity, here is the scenario.
Column 1 is Name (Choice, DROP DOWN menu, options are: John, Mary, Bob, only one choice is allowed)
Column 2 is Pets (Choice, CHECKBOX, options are: Dog, Cat, Fish, MULTIPLE choices can be selected)
Bob chooses Dog, Cat
Mary chooses Dog, Cat and Fish
John chooses Fish
The result of the entries are:
Name | Pets
Bob | Dog, Cat
Mary | Dog, Cat, Fish
John | Fish
I would like a Workflow to run (upon new entry) to insert items into new list (OR update the CURRENT list) WITH THE RESULT being:
Two (2) indentical items for Bob, except one item has only Dog and one has only Cat (in Pets field)
Three (3) indentical item for Mary, except one item has only Dog and one has only Cat and one has only Fish (in Pets field)
One (1) item for John, item has Fish (in Pets field) - NOTE: no change from INITIAL ENTRY because the intial entry only had 1 pet from the start.
Can someone please help with this?