Filemaker© Add-Ons
Dynamic Value Lists, MVLs, Client/Parent
Filemaker Add-On WOI-MVL-DYN
The parameterizable, context-independent MVL
Value lists are an important tool in FileMaker development because they can store data from any other table in a current table without being related to it.
Anyone who has worked with these value lists knows that each value list has to be created separately and is therefore not transferable and offers little comfort and presentation options.
Here are some advantages over a “normal” value list:
- The number of displayed rows can be set using parameters.
- You can scroll forwards and backwards in blocks.
- When an element is selected, the corresponding Sys_ID
- or UUID of the source table is also output for further use.
- 2 fields from the source table can be displayed next to each other.
- The display can be filtered. This makes WOI-MVL-DYN suitable for large databases.
- Thanks to the add-on format, no installation is necessary.
- Only a few parameters need to be entered so that the MVL-DYN can be assigned to the WOI-MVL-DYN with the individual names of the target layout and the target table.
Article MVL-DYN
Read my article ‘MVL-DYN, the dynamic value list in add-on format’ here.
Click here to download:
Update
Child/Parent Function
The new update includes two interesting extensions:
1. A general filter. This filter value is specified in the parameters and generates, for example, a selection of all data records with the “active” identifier and
2. there is now a child MVL for the parent MVL, which displays data records that have a relationship to the selected data record of the parent MVL.
Example:
In a customer table, the employees and telephone numbers of a supplier selected in the parent MVL can be displayed and selected.
You can download the English version for free here:
How do I activate this add-on?
- Unzip the zip file “WOI_MVL_DYN.zip” ==> A folder “MVL_DYN” and a file “WOI_MVL_DYN.fmaddon” will appear
- Double-clicking on the file “WOI_MVL_DYN.fmaddon” copies the folder “WOI_MVL_DYN” into the add-on directory of FM
- Open the layout in which the add-on is to be activated
- Create a new layout
- Go to layout mode
- On the left sidebar, next to the Fields and Objects tabs, you can now click on the Add-ons tab
- Click on “+” at the bottom and the available add-ons will be listed
- Scroll down until the name “WOI_MVL_DYN” becomes visible
- Drag the icon onto the empty layout and the start button will appear
Find records in excerpts faster
Dynamic Selection
In this article I will show how to use suitable
scripts to influence the selection of addresses,
so that, for example, only those are taken into account
whose initial letters in the alphabet are behind
the entered letter, or which begin with
a specific sequence of letters or a
certain chain of letters (characters).