{"id":3094,"date":"2018-07-13T02:14:44","date_gmt":"2018-07-13T02:14:44","guid":{"rendered":"http:\/\/himbap.com\/blog\/?p=3094"},"modified":"2018-07-13T02:14:44","modified_gmt":"2018-07-13T02:14:44","slug":"no-code-solution-for-filtering-subgrid-based-on-the-lookup","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=3094","title":{"rendered":"No Code solution for Filtering Subgrid based on the Lookup"},"content":{"rendered":"

There is a common requirement to filter subgrid based on the lookup field, but there is no easy way to implement it without writing code. In this post I am going to discuss a quick workaround to implement this requirement. Let’s see how we can implement this.<\/p>\n

Requirement<\/strong>: We want to show marketing list for accounts in contact form based on the account lookup.<\/p>\n

Solution<\/strong>: We can implement this requirement with the help of the quick view form \ud83d\ude42 using following steps:<\/p>\n

1. Open default solutions by Navigating to Settings->Customizations->Customize<\/strong> the Systems or create your custom solution and add Account and Contact entity to your custom solution.
\n2. Navigate to Forms under Account entity
\n3. Create New Quick View form and change form name “AccountMarketingListQuickViewForm<\/strong>” using Form Property button on the top<\/p>\n

\"quickcreate1\"<\/a><\/p>\n

4. Click on Insert and add a subgrid and set following options<\/p>\n

\"quickcreate2\"<\/a>
\n5. Save and Publish your changes
\n6. Open Contact form and Insert a Quick View form by navigating to Insert->Quick View Form<\/strong>, we need to set following properties<\/p>\n

\"quickcreate3\"<\/a>
\n7. Save and Publish your changes.<\/p>\n

Now let’s say we have one marketing list Current Resellers having “Hewlett Packard” account
\n\"quickcreate4\"<\/a><\/p>\n

Now open contact having Hewlett Packard in company name lookup and you will be able to see related marketing list like below<\/p>\n

\"quickcreate5\"<\/a><\/p>\n

Hope it will help someone !!<\/p>\n","protected":false},"excerpt":{"rendered":"

There is a common requirement to filter subgrid based on the lookup field, but there is no easy way to implement it without writing code. In this post I am going to discuss a quick workaround to implement this requirement. Let’s see how we can implement this. Requirement: We want to show marketing list for accounts in contact form based… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[402,522,6,8,275],"tags":[547,546,548],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3094"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3094"}],"version-history":[{"count":3,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3094\/revisions"}],"predecessor-version":[{"id":3102,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3094\/revisions\/3102"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}