Core FileMaker Blog

Keep up to date with CoreSolutions

Dynamic Value List Filters

With the introduction of the function ExecuteSQL in Filemaker 12, I find it now fairly easy to have dynamic value lists. An instance this may become useful is if you change the values in a value list for future records.

Example
If you have a field teamName, and the original values contained, Montreal Expos, Toronto Blue Jays, Detroit Tigers…
The Montreal Expos now moved to Washington so you will want Montreal removed and Washington added to your value list for new records. However you still have old records which contain Montreal Expos as a value.

In order to find Montreal you will either you need keep 2 lists up to date, or you can use the ExecuteSQL function for calculation field and use that field in a value list so that it will find all teamNames with no need to update it. You will also want this to be distinct values.

Here is the code.

ExecuteSQL ( “SELECT DISTINCT teamName FROM Players”; “”; “”)
This will pull every records teamName and only unique values. Thus making Montreal and Washington both values in the value list.

Leave a comment

CoreSolutions Logo

London Office:
1-1615 N Routledge Park
London, ON N6H 5L6

Toronto Office:
2425 Matheson Blvd East
7th Floor
Mississauga, ON L4W 5K4

Toll Free: (800) 650-8882
London: (519) 641-7727
Toronto: (416) 410-8649
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

SUBSCRIBE

Click the 'Subscribe' button to sign up for news & software tips.

Beyond Software

Copyright © 2018 CoreSolutions Software, Inc. All Rights Reserved