I have SPD 2010, but do not have access to additional coding options. Any help would be GREATLY appreicated.

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)

Example entries:

1. Bob chooses Dog, Cat

2. Mary chooses Dog, Cat and Fish

3. 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?

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)

Example entries:

1. Bob chooses Dog, Cat

2. Mary chooses Dog, Cat and Fish

3. 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?

I have SPD 2010, but do not have access to additional coding options. Any help would be GREATLY appreicated.

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)

Example entries:

1. Bob chooses Dog, Cat

2. Mary chooses Dog, Cat and Fish

3. 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 becuase the intial entry only had 1 pet from the start.

Can someone please help with this? THANK YOU!

Scott

I have SPD 2010, but do not have access to additional coding options. Any help would be GREATLY appreicated.

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)

Example entries:

1. Bob chooses Dog, Cat

2. Mary chooses Dog, Cat and Fish

3. 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?