Method:Classic General Q&A

Re: Mark activities as completed in batch or delete within selected date range?

scottaskinosie — Tue, 14 Jul 2015 20:00:57 GMT

That worked like a charm!

Thank you Mortaza! I really really really appreciate the help!!!!!!!!!!

Re: Mark activities as completed in batch or delete within selected date range?

Method_Morty — Tue, 14 Jul 2015 19:05:40 GMT

Hey,

Using the filters do you now have a Grid that has all the Activities you want to be deleted?

Make sure the Grid has a list of all the Activities you want to have deleted and no other ones. All that step 15 is going to do is loop through each row of the grid and delete the record. The filter should have two options attached:

> Where ActivityStatus Not Equal to Completed.

> Where Activity is within XX-XX-XXX and XX-XX-XXXX date range.

Once you have a Grid with a list of Activities you want to have deleted, add the Field RecordID to the Grid.

The Action Properties for Delete Record From Table will be:

Under Select Table: select Activity.

Under Where Field select RecordID.

Under the next drop down select Equal To.

Under Value: select Value From Row.

Under the next drop down select RecordID.

In the box Internal Note: type in what this action does.

Click Save & Close.

What is happening here it’s going to delete every Activity from the Activity table that matches the RecordID that is listed in your Grid you created. It's crucial you confirm the Grid meets the Activities you want to have deleted.

Let me know if you need me to elaborate any steps here.

- Mortaza

Re: Mark activities as completed in batch or delete within selected date range?

scottaskinosie — Tue, 14 Jul 2015 18:35:12 GMT

Thanks again Mortaza,

I do have a question. When I get to step 15 I am not sure how to set up the delete rules. I have two variables, activity status and date range. How do I set up the delete from table rules?

Thanks again!!!

Re: Mark activities as completed in batch or delete within selected date range?

scottaskinosie — Tue, 14 Jul 2015 16:41:33 GMT

Thank you Mortaza! I'll give that a shot.

Re: Mark activities as completed in batch or delete within selected date range?

Method_Morty — Tue, 14 Jul 2015 15:16:01 GMT

Also since you want it to be within a specific date range, make sure you add that to the filter as per step 10.

The fields will be: DueDateStart and DueDateEnd which is the Due On & Due Ending as listed on New Activity screen.

- Mortaza

Re: Mark activities as completed in batch or delete within selected date range?

Method_Morty — Tue, 14 Jul 2015 15:11:28 GMT

Hey,

Following THIS Help Center article it explains how to delete multiple records while looping through a grid. This article is geared toward deleting customers but following the same steps you can complete the process for Activities not equal to Completed.

In your case on step 4: choose the Activities table. On step 10: for filter you will want to set it up so it lists any activity that is NOT completed.

Let me know if you need me to further explain the different options you will be choosing as you will be working with the Activities table.

- Mortaza

Re: Mark activities as completed in batch or delete within selected date range?

scottaskinosie — Tue, 14 Jul 2015 14:58:54 GMT

I created a loop that includes activities within a date range but now I am not sure how to use that loop to only delete the activities within it:(

Mark activities as completed in batch or delete within selected date range?

scottaskinosie — Tue, 14 Jul 2015 13:55:10 GMT

We have recently had some personel changes and due to training time for our new sales rep we have many activities that have not been completed that we would like to either mark as completed or simply delete from CRM. We have about 300 in total. Is there an easy way to make a button to either of these things?