Method:Classic General Q&A

Re: Can you filter 2 fields in the same lookup box on a table, such as Activities List?

Anonymous — Tue, 04 Sep 2012 21:59:13 GMT

Method_Chad:
I'll put your suggestion in to the dev team to add that field as hidden by default but until then you'll need to customize the screen on your own.

If we get more requests on this suggestion we'll consider adding but at this time it has not been brought up before.

Re: Can you filter 2 fields in the same lookup box on a table, such as Activities List?

Anonymous — Tue, 04 Sep 2012 21:03:40 GMT

Jcamp0123:
For the purpose of looking up completed activities, another column that would be helpful would be the Completed Date

Hi Justin,

You've got the option to add this column through customization if you wanted. You would need to make a copy of the CRM_ActivitiesList screen first following these steps:

Click Customize > Screens and look for CRM_ActivitiesList.
Rollover the screen and click Copy.
On Step 1 you want to copy from This Account.
On Step 2 you can rename it if needed.
Step 3 is important, select add a tab link and put this screen under the Activities tab.

After you've made a copy of the page you want to now click Edit beside your new screen name. Follow these steps to edit the grid:

Click the little Edit button on the Activity Grid object.
Click next on Step 1 then on Step 2 select the field ActualCompletedDate and click Insert Column.
Scroll down the column list to find the newly added field and click the Advanced link.
Here you can choose to make this field Hidden when the screen first loads so that you need to click the gear icon to temporarily add the field. Alternatively you can skip this step if you prefer to have the field always visible.

Please post back if you have any questions on this customization. I'll put your suggestion in to the dev team to add that field as hidden by default but until then you'll need to customize the screen on your own.

Re: Can you filter 2 fields in the same lookup box on a table, such as Activities List?

Jcamp0123 — Tue, 04 Sep 2012 17:42:53 GMT

The updated version of the activities list does allow the additional filtering that I was looking for in being able to lookup completed activities for a specific user. The optional columns make a variety of other filtering options possible too. For the purpose of looking up completed activities, another column that would be helpful would be the Completed Date, so we could not only see when an activity was due, but allow us to see when it was actually completed too.

Thanks,

Justin

Re: Can you filter 2 fields in the same lookup box on a table, such as Activities List?

Anonymous — Fri, 31 Aug 2012 12:54:59 GMT

@Joseph - these features have now been added to the stock activities list screen. Checkout today's release notes. Looking forward to your feedback.

http://www.methodintegration.com/cs/blogs/releasenotes/archive/2012/08/31/method-crm-updates-august-30-2012.aspx

Danny

Re: Can you filter 2 fields in the same lookup box on a table, such as Activities List?

Anonymous — Thu, 30 Aug 2012 20:39:49 GMT

Jcamp0123:
Is there a way to filter both fields in a single lookup field, without customizing the screen?

Hi Joseph,

Keep a lookout for an updated version of the activities list to be released this week. It will feature the ability for you to filter by more than one column. As always, we'll also make this known in our release notes.

http://www.methodintegration.com/cs/blogs/releasenotes/default.aspx

Danny

Re: Can you filter 2 fields in the same lookup box on a table, such as Activities List?

Anonymous — Tue, 21 Aug 2012 16:57:30 GMT

Method_Chad:
I've put a ticket in with my team to see if we can come up with a better solution for this type of filtering on a SQL Override. I'll keep this thread updated.

Just a quick update on this comment - I've added this as a suggestion update to the stock screen. If or when this suggestion makes it down the pipe we'll let everyone know via our release notes.

Re: Can you filter 2 fields in the same lookup box on a table, such as Activities List?

Anonymous — Tue, 21 Aug 2012 15:59:35 GMT

Jcamp0123:
Is there a way to filter both fields in a single lookup field, without customizing the screen?

At this point, no. The problem is that SQL overrides are not filterable against multiple criteria, you can search for either JSmith or Completed but not both at the same time. There is a work around but it will require you to customize this page a little. You would need to delete the column on this grid for Assigned To/Type/Status then add in the fields for Assigned To and Activity Status. Once those are added in you can add back in the Assigned To/Type/Status field with the SQL Override.

I've put a ticket in with my team to see if we can come up with a better solution for this type of filtering on a SQL Override. I'll keep this thread updated.

Can you filter 2 fields in the same lookup box on a table, such as Activities List?

Jcamp0123 — Tue, 21 Aug 2012 12:56:11 GMT

On the activities list, I would like to use the column Assigned To/Type/Status to allow me to filter activities that are completed for a specific user.

Example: I would like to show activities Assigned To: JSmith where the Status is Completed. If I type in JSmith and Completed, there are no results found.

Is there a way to filter both fields in a single lookup field, without customizing the screen?