Tip #1181: Filtered lookups on editable grids

Today’s tip is from Nick “Benchpress” Doelman. Technically it’s from his wife which proves that all of us, MVPs, are mere mortals and the real knowledge still belongs to the users.

She only wanted to see contacts that belonged to an account on the record but the lookup view was showing all the contacts. Turns out, the editable grid lookup will only filter if the ‘filter by’ field is also on the view. For instance:

  1. Without the “Account” being visible on the editable grid view:
    clip_image001
  2. Now with the “Account” being added to the editable grid view:
    clip_image002

Don’t have a tip but your spouse works with Dynamics? Ask them and send the tip to jar@crmtipoftheday.com!

(Facebook and Twitter cover photo by Tyler Nix on Unsplash)

2 thoughts on “Tip #1181: Filtered lookups on editable grids

  1. Brigitte Maheu says:

    Finally, MVP wives being recognized for their contributions! 😉

  2. Jack says:

    Hi. Could you please share a screenshot of how to set this up in the view?

Leave a Reply

Your email address will not be published. Required fields are marked *