Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Extender Filter Lookups


Within Extender you can create lookups to look up data from an Extender form. It would be nice to be able to filter that list to exclude let’s say inactive codes for an example, or filter based on a value on the extender form or window you are using the lookup. Let’s start with creating a form with a checkbox to show the record is inactive. Here is my form showing a task code, with the Inactive checkbox marked.

Once that is created, and data added, you need to create a lookup on an Extender window or form to exclude any task code where the Inactive checkbox is marked. On my window I have created this lookup for the task codes, then click the Restrictions Button, then click the Add button.

Once you have clicked the add button, select the Inactive field, and set the other values as shown and save this restriction.

Once you have saved the field and the extender window/form, you can test this restriction. Note TASK2 does not show in my lookup as it is inactive.

Now for a little harder example. I want my lookup to only show records based on a value on the window. For this example, I created a form listing cities and have a field for the state.

Once that is created, and data added, you need to create a lookup on an Extender window or form to exclude any city where the State is the state on the window/form. On my window I have created this lookup for the list of cities, then click the Restrictions Button, then click the Add button.

Once you have clicked the add button, select the State field, the restriction type of equals, the value from is Field and the restriction value is one of the fields on the window/form.

Now the list of cities will be limited to the cities that have the “my state” value match the state value on the city form.

A very quick and easy way to limit the acceptable values within a lookup.

Happy Coding!

1 Comment

  1. Moreen on October 12, 2016 at 2:35 pm

    Restrictions is greyed out on my lookups

Leave a Comment





RECENT POSTS


2021 Q4 Promotions
Connect with us at Directions EMEA 2021 in Milan!
eOne at Summit North America 2021
Employee Spotlight: Megan Tripp, Business Development Representative
eOne is now compatible with Microsoft Dynamics GP October 2021 Release

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.