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


Modify Excel Templates for compatibility with Excel Add-in
Meet eOne at Summit in Nashville
New Releases of SmartList Builder and Extender
VIP Roundup Party at Summit 2017 in Nashville
Tech Tuesday: Troubleshooting SmartList Builder Lists that Return No Data

POPULAR POSTS


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

CATEGORIES

ARCHIVES

open all | close all

TAGS

#fargo 2017 CRM Demo Dynamics Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender GP GPUG integration integration manager Meet the Team Microsoft Microsoft dynamics crm Microsoft Dynamics GP ODBC Office Relationships partners release SalesForce SalesForce.com scripting SmartConnect SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.