Duplicating a record based on multiple entries in specific field

[tmcstay]

I have a database of products that can have more than one vendor. So, the vendor field is a multi text field.

When a customer selects a product I want to:

1. Copy the record to ensure that the number of database records equals the number of vendors;
2. Alter the new records (as well as the original) to have just a single vendor in each record - this way, each record is specific to a particular vendor.

The approach that I have taken is to run a recursive workflow on the selected record - this workflow will copy the record x-1 times.

What happens now is that all of the records have all of the vendor names - logically.

Where I am stuck is trying to eliminate vendor names - that is, for record 1, only vendor 1 should remain; record 2, only vendor 2 should remain, etc.

I can’t seem to manage this, so any advice would be very helpful.

[hanan1]

This is doable even without the recursive workflow. Check this out:

It’s a simple matter of using custom states and a conditional. I can explain but it’s easier for you to play with it yourself.