Method Community

Can anyone please tell me how I can mass assign a sales rep to our current leads? 

Thanks!

Hi Dan_AA, 

The only way to do this is by adding a button on any screen that will have an action where you would have to loop though the customer tables where IsLeadStatusOnly = True and update the salesreps for those leads. 

The webinar titled “Advanced Actions: Looping and Conditional Statements” in our Method Community http://www.methodintegration.com/cs/blogs/methodblog/pages/Method-Community-Webinars.aspx will explain to you how to put in that action. You can also review our other webinars there to help you with preparation for this customization.  

In addition, you can also use the import/export tool to export out the information from the customer table and update it in excel where you can import it back in. 

I hope that helps.

Ronen

Hi Dan,

I just thought of another solution for your question. The import/export feature will also help you out in this situation:

1. Export the customer table (be sure to export RecordID) and Sales Rep field

2. Update the Sales Rep

3. Import the revised excel back into the customer table

4. It should then prompt you to update instead of adding new records. 

Ronen