Hi ByronMSEC,
here are 2 ways you could achieve this, I'll go through them both for you. The first way would be through import/export:
- Export your Activities table, with the fields RecordId and AssignedTo selected.
- Modify the AssignedTo field to the new salesperson's name (make sure this matches exactly to the value from the dropdown), save the spreadsheet.
- Import the the spreadsheet.
They key here is that when you import the spreadsheet, the existing records will be updated (and AssignedTo changed), based on the corresponding RecordId field in the speadsheet.
The second approach would be to use Method actions by adding a button to the Activities screen. If you havent customized the Activities screen, please start by copying that screen (which allows it to be modified). You can place the copy of that screen in whatever tab you like. The approach here is that the user would select the records to update by searching in the filter row at the top of the grid. (A similar article that deletes instead of modifies records is available here: http://www.methodintegration.com/method/kb.aspx?folder=methodcrm&article=How-to-delete-multiple-records-while-looping-through-a-grid&id=194.) In your case, you would type the old sales person in the AssignedTo filter.
Next, you would add a button doing the following:
- Loop through all rows in the Activities grid, using the "Start Loop Through Grid" action. (To be extra careful, you could loop through "only checked rows" if you wanted to check off the records to modify. You would have to enable the checkbox column)
- Set the current record's AssignedTo to the new salesperson's name, using the "Update Field in Table" action.
- End the loop through the table.
This button would allow you to assign Activities to a new sales person, depending on whatever filter critieria you would like.
Please let us know if you have any further questions.
-Russell