{"id":657,"date":"2025-01-29T18:26:21","date_gmt":"2025-01-29T17:26:21","guid":{"rendered":"https:\/\/woisoft.de\/woi-mvl-dyn\/"},"modified":"2025-12-20T10:52:02","modified_gmt":"2025-12-20T09:52:02","slug":"woi-mvl-dyn","status":"publish","type":"page","link":"https:\/\/woisoft.de\/en\/woi-mvl-dyn\/","title":{"rendered":"WOI-MVL-DYN"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; custom_padding_last_edited=&#8221;on|tablet&#8221; next_background_color=&#8221;#ffe4c6&#8243; admin_label=&#8221;Hero&#8221; _builder_version=&#8221;4.27.4&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_type=&#8221;circular&#8221; background_color_gradient_direction_radial=&#8221;top right&#8221; background_color_gradient_stops=&#8221;rgba(255,255,255,0) 20%|rgba(1,77,183,0.9) 100%&#8221; background_color_gradient_overlays_image=&#8221;on&#8221; background_color_gradient_start=&#8221;rgba(255,255,255,0)&#8221; background_color_gradient_start_position=&#8221;20%&#8221; background_color_gradient_end=&#8221;rgba(1,77,183,0.9)&#8221; background_image=&#8221;https:\/\/woisoft.de\/wp-content\/uploads\/2025\/01\/Datenerfassung.png&#8221; custom_padding=&#8221;110px|0px|110px|0px|true|false&#8221; custom_padding_tablet=&#8221;50px||50px||true&#8221; custom_padding_phone=&#8221;|||&#8221; bottom_divider_style=&#8221;asymmetric&#8221; bottom_divider_height=&#8221;50px&#8221; bottom_divider_flip=&#8221;horizontal&#8221; bottom_divider_height_tablet=&#8221;90px&#8221; bottom_divider_height_phone=&#8221;80px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;2_3,1_3&#8243; _builder_version=&#8221;4.16&#8243; custom_width_px=&#8221;1280px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; text_font=&#8221;Montserrat||||||||&#8221; text_text_color=&#8221;rgba(255,255,255,0.7)&#8221; text_font_size=&#8221;20px&#8221; text_line_height=&#8221;1.8em&#8221; header_font=&#8221;Montserrat|700|||||||&#8221; header_font_size=&#8221;44px&#8221; header_line_height=&#8221;1.4em&#8221; header_6_font=&#8221;Montserrat|600||on|||||&#8221; header_6_text_color=&#8221;rgba(255,255,255,0.7)&#8221; header_6_font_size=&#8221;16px&#8221; header_6_letter_spacing=&#8221;2px&#8221; header_6_line_height=&#8221;1.5em&#8221; background_layout=&#8221;dark&#8221; max_width=&#8221;780px&#8221; text_font_size_tablet=&#8221;&#8221; text_font_size_phone=&#8221;15px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_font_size_tablet=&#8221;&#8221; header_font_size_phone=&#8221;28px&#8221; header_font_size_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6><\/h6>\n<h1>Filemaker\u00a9 Add-Ons<\/h1>\n<p><span>Dynamic Value Lists, MVLs, Client\/Parent<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; use_custom_gutter=&#8221;on&#8221; gutter_width=&#8221;2&#8243; admin_label=&#8221;Features&#8221; _builder_version=&#8221;4.16&#8243; custom_margin=&#8221;30px|||&#8221; custom_width_px=&#8221;1280px&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;About&#8221; _builder_version=&#8221;4.27.4&#8243; background_color=&#8221;#ffe4c6&#8243; background_enable_image=&#8221;off&#8221; background_position=&#8221;center_left&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.27.4&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; text_font=&#8221;Montserrat||||||||&#8221; text_font_size=&#8221;16px&#8221; text_line_height=&#8221;1.8em&#8221; link_font=&#8221;Montserrat|700|||||||&#8221; link_text_color=&#8221;#fa546d&#8221; link_font_size=&#8221;22px&#8221; link_line_height=&#8221;1.5em&#8221; header_font=&#8221;||||||||&#8221; header_line_height=&#8221;1.3em&#8221; header_2_font=&#8221;Montserrat|700|||||||&#8221; header_2_font_size=&#8221;40px&#8221; header_2_line_height=&#8221;1.4em&#8221; header_6_font=&#8221;Montserrat|600||on|||||&#8221; header_6_text_color=&#8221;#ffb342&#8243; header_6_font_size=&#8221;16px&#8221; header_6_letter_spacing=&#8221;2px&#8221; header_6_line_height=&#8221;1.5em&#8221; max_width_last_edited=&#8221;off|desktop&#8221; module_alignment=&#8221;left&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;|||&#8221; header_2_font_size_tablet=&#8221;&#8221; header_2_font_size_phone=&#8221;24px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6>Filemaker Add-On WOI-MVL-DYN<\/h6>\n<h1><\/h1>\n<h1><span class=\"diyfeDecoration\">  The parameterizable, context-independent MVL  <\/span><\/h1>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/02\/MVL-DYN2.png&#8221; title_text=&#8221;MVL-DYN; Source: private&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; box_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_divider show_divider=&#8221;off&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; height=&#8221;132px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Montserrat||||||||&#8221; text_font_size=&#8221;16px&#8221; text_line_height=&#8221;1.8em&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p><strong>Here are some advantages over a \u201cnormal\u201d value list:<\/strong><\/p>\n<ul>\n<li>The number of displayed rows can be set using parameters.<\/li>\n<li>You can scroll forwards and backwards in blocks.<\/li>\n<li>When an element is selected, the corresponding Sys_ID<\/li>\n<li>or UUID of the source table is also output for further use.<\/li>\n<li>2 fields from the source table can be displayed next to each other.<\/li>\n<li>The display can be filtered. This makes WOI-MVL-DYN suitable for large databases. <\/li>\n<li>Thanks to the add-on format, no installation is necessary.<\/li>\n<li>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.<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_cta title=&#8221;Article MVL-DYN&#8221; button_url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9hdHRhY2htZW50Iiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM3MiJ9fQ==@&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _dynamic_attributes=&#8221;button_url&#8221; _module_preset=&#8221;default&#8221; header_font=&#8221;Montserrat||||||||&#8221; header_text_color=&#8221;rgba(0,0,0,0.69)&#8221; header_font_size=&#8221;28px&#8221; body_font=&#8221;Montserrat||||||||&#8221; body_text_color=&#8221;rgba(0,0,0,0.56)&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#000000&#8243; button_border_width=&#8221;0px&#8221; button_icon=&#8221;&#xf1c1;||fa||900&#8243; button_icon_color=&#8221;#E02B20&#8243; button_alignment=&#8221;center&#8221; width=&#8221;100%&#8221; button_on_hover_tablet=&#8221;&#8221; button_on_hover_phone=&#8221;&#8221; button_on_hover_last_edited=&#8221;on|desktop&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Read my article &#8216;MVL-DYN, the dynamic value list in add-on format&#8217; here.<\/p>\n<p>Click here to download:<\/p>\n<p>[\/et_pb_cta][et_pb_icon font_icon=&#8221;&#xf1c1;||fa||900&#8243; icon_color=&#8221;#E02B20&#8243; icon_width=&#8221;53px&#8221; url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9hdHRhY2htZW50Iiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM3MiJ9fQ==@&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _dynamic_attributes=&#8221;url&#8221; _module_preset=&#8221;default&#8221; custom_margin=&#8221;-72px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_icon][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider color=&#8221;#014db7&#8243; divider_weight=&#8221;4px&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_enable_color=&#8221;off&#8221; border_radii=&#8221;on|8px|8px|8px|8px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Trusted By&#8221; _builder_version=&#8221;4.27.4&#8243; background_color=&#8221;#ffe4c6&#8243; module_alignment=&#8221;right&#8221; custom_margin=&#8221;-3vw||||false|false&#8221; custom_padding=&#8221;0px|0px|0px|0px|true|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.27.4&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; text_font=&#8221;Montserrat||||||||&#8221; text_font_size=&#8221;16px&#8221; text_line_height=&#8221;1.8em&#8221; header_font=&#8221;||||||||&#8221; header_2_font=&#8221;Montserrat|700|||||||&#8221; header_2_font_size=&#8221;40px&#8221; header_2_line_height=&#8221;1.4em&#8221; header_6_font=&#8221;Montserrat|600||on|||||&#8221; header_6_text_color=&#8221;#ffb342&#8243; header_6_font_size=&#8221;16px&#8221; header_6_letter_spacing=&#8221;2px&#8221; header_6_line_height=&#8221;1.5em&#8221; custom_margin=&#8221;|||&#8221; header_2_font_size_tablet=&#8221;&#8221; header_2_font_size_phone=&#8221;24px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6>Update<\/h6>\n<h1>Child\/Parent Function<\/h1>\n<p>The new update includes two interesting extensions:<\/p>\n<p>1. A general filter. This filter value is specified in the parameters and generates, for example, a selection of all data records with the \u201cactive\u201d identifier and <\/p>\n<p>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.<\/p>\n<p>Example:<\/p>\n<p>In a customer table, the employees and telephone numbers of a supplier selected in the parent MVL can be displayed and selected.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_divider show_divider=&#8221;off&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; height=&#8221;111px&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/02\/MVL-DYN1.png&#8221; title_text=&#8221;MVL-DYN; Source: private&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; box_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.27.4&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; text_font=&#8221;Montserrat||||||||&#8221; text_font_size=&#8221;16px&#8221; text_line_height=&#8221;1.8em&#8221; header_font=&#8221;||||||||&#8221; header_line_height=&#8221;1.1em&#8221; header_2_font=&#8221;Montserrat|700|||||||&#8221; header_2_font_size=&#8221;40px&#8221; header_2_line_height=&#8221;1.4em&#8221; header_6_font=&#8221;Montserrat|600||on|||||&#8221; header_6_text_color=&#8221;#ffb342&#8243; header_6_font_size=&#8221;16px&#8221; header_6_letter_spacing=&#8221;2px&#8221; header_6_line_height=&#8221;1.5em&#8221; custom_margin=&#8221;|||&#8221; header_2_font_size_tablet=&#8221;&#8221; header_2_font_size_phone=&#8221;24px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h1>You can download the English version for free here:<\/h1>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjU3OCJ9fQ==@&#8221; button_text=&#8221;to free download&#8221; _builder_version=&#8221;4.27.5&#8243; _dynamic_attributes=&#8221;button_url&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;14px&#8221; button_bg_color=&#8221;rgba(1,77,183,0.9)&#8221; button_border_width=&#8221;12px&#8221; button_border_color=&#8221;rgba(0,0,0,0)&#8221; button_border_radius=&#8221;100px&#8221; button_font=&#8221;Montserrat|700|||||||&#8221; button_use_icon=&#8221;off&#8221; background_layout=&#8221;dark&#8221; hover_enabled=&#8221;0&#8243; box_shadow_style=&#8221;preset3&#8243; button_border_radius_hover=&#8221;100px&#8221; button_bg_color_hover=&#8221;#ff6b86&#8243; global_colors_info=&#8221;{}&#8221; button_text_size__hover_enabled=&#8221;off&#8221; button_one_text_size__hover_enabled=&#8221;off&#8221; button_two_text_size__hover_enabled=&#8221;off&#8221; button_text_color__hover_enabled=&#8221;off&#8221; button_one_text_color__hover_enabled=&#8221;off&#8221; button_two_text_color__hover_enabled=&#8221;off&#8221; button_border_width__hover_enabled=&#8221;off&#8221; button_one_border_width__hover_enabled=&#8221;off&#8221; button_two_border_width__hover_enabled=&#8221;off&#8221; button_border_color__hover_enabled=&#8221;off&#8221; button_one_border_color__hover_enabled=&#8221;off&#8221; button_two_border_color__hover_enabled=&#8221;off&#8221; button_border_radius__hover_enabled=&#8221;on&#8221; button_border_radius__hover=&#8221;100px&#8221; button_one_border_radius__hover_enabled=&#8221;off&#8221; button_two_border_radius__hover_enabled=&#8221;off&#8221; button_letter_spacing__hover_enabled=&#8221;off&#8221; button_one_letter_spacing__hover_enabled=&#8221;off&#8221; button_two_letter_spacing__hover_enabled=&#8221;off&#8221; button_bg_color__hover_enabled=&#8221;on|desktop&#8221; button_bg_color__hover=&#8221;#e09900&#8243; button_one_bg_color__hover_enabled=&#8221;off&#8221; button_two_bg_color__hover_enabled=&#8221;off&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; text_font=&#8221;Montserrat||||||||&#8221; text_font_size=&#8221;16px&#8221; text_line_height=&#8221;1.8em&#8221; header_font=&#8221;||||||||&#8221; header_line_height=&#8221;1.1em&#8221; header_2_font=&#8221;Montserrat|700|||||||&#8221; header_2_font_size=&#8221;40px&#8221; header_2_line_height=&#8221;1.4em&#8221; header_6_font=&#8221;Montserrat|600||on|||||&#8221; header_6_text_color=&#8221;#ffb342&#8243; header_6_font_size=&#8221;16px&#8221; header_6_letter_spacing=&#8221;2px&#8221; header_6_line_height=&#8221;1.5em&#8221; custom_margin=&#8221;|||&#8221; header_2_font_size_tablet=&#8221;&#8221; header_2_font_size_phone=&#8221;24px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h3>How do I activate this add-on?<\/h3>\n<ul>\n<li>Unzip the zip file \u201cWOI_MVL_DYN.zip&#8221; ==&gt; A folder &#8220;MVL_DYN&#8221; and a file \u201cWOI_MVL_DYN.fmaddon&#8221; will appear<\/li>\n<li>Double-clicking on the file \u201cWOI_MVL_DYN.fmaddon&#8221; copies the folder \u201cWOI_MVL_DYN&#8221; into the add-on directory of FM<\/li>\n<li>Open the layout in which the add-on is to be activated<\/li>\n<li>Create a new layout<\/li>\n<li>Go to layout mode<\/li>\n<li>On the left sidebar, next to the Fields and Objects tabs, you can now click on the Add-ons tab<\/li>\n<li>Click on &#8220;+&#8221; at the bottom and the available add-ons will be listed<\/li>\n<li>Scroll down until the name \u201cWOI_MVL_DYN&#8221; becomes visible<\/li>\n<li>Drag the icon onto the empty layout and the start button will appear<\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider color=&#8221;#014db7&#8243; divider_style=&#8221;groove&#8221; divider_weight=&#8221;15px&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#0C71C3&#8243; border_radii=&#8221;on|8px|8px|8px|8px&#8221; box_shadow_style=&#8221;preset2&#8243; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;About&#8221; module_id=&#8221;Dynamics&#8221; _builder_version=&#8221;4.27.4&#8243; background_color=&#8221;#ffe4c6&#8243; background_enable_image=&#8221;off&#8221; background_position=&#8221;center_left&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.27.4&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; text_font=&#8221;Montserrat||||||||&#8221; text_font_size=&#8221;16px&#8221; text_line_height=&#8221;1.8em&#8221; link_font=&#8221;Montserrat|700|||||||&#8221; link_text_color=&#8221;#fa546d&#8221; link_font_size=&#8221;22px&#8221; link_line_height=&#8221;1.5em&#8221; header_font=&#8221;||||||||&#8221; header_line_height=&#8221;1.3em&#8221; header_2_font=&#8221;Montserrat|700|||||||&#8221; header_2_font_size=&#8221;40px&#8221; header_2_line_height=&#8221;1.4em&#8221; header_6_font=&#8221;Montserrat|600||on|||||&#8221; header_6_text_color=&#8221;#ffb342&#8243; header_6_font_size=&#8221;16px&#8221; header_6_letter_spacing=&#8221;2px&#8221; header_6_line_height=&#8221;1.5em&#8221; max_width_last_edited=&#8221;off|desktop&#8221; module_alignment=&#8221;left&#8221; custom_margin=&#8221;|||&#8221; custom_padding=&#8221;|||&#8221; header_2_font_size_tablet=&#8221;&#8221; header_2_font_size_phone=&#8221;24px&#8221; header_2_font_size_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<h6>Find records in excerpts faster<\/h6>\n<h1><\/h1>\n<h1><span class=\"diyfeDecoration\">  Dynamic Selection<\/span><\/h1>\n<p>In this article I will show how to use suitable<br \/>scripts to influence the selection of addresses,<br \/>so that, for example, only those are taken into account<br \/>whose initial letters in the alphabet are behind<br \/>the entered letter, or which begin with<br \/>a specific sequence of letters or a<br \/>certain chain of letters (characters).<\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_divider show_divider=&#8221;off&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; height=&#8221;63px&#8221; custom_padding=&#8221;||24px|||&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_cta title=&#8221;Article Dynamic Selection&#8221; button_url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9hdHRhY2htZW50Iiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM3MiJ9fQ==@&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _dynamic_attributes=&#8221;button_url&#8221; _module_preset=&#8221;default&#8221; header_font=&#8221;Montserrat||||||||&#8221; header_text_color=&#8221;rgba(0,0,0,0.69)&#8221; header_font_size=&#8221;28px&#8221; body_font=&#8221;Montserrat||||||||&#8221; body_text_color=&#8221;rgba(0,0,0,0.56)&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#000000&#8243; button_border_width=&#8221;0px&#8221; button_icon=&#8221;&#xf1c1;||fa||900&#8243; button_icon_color=&#8221;#E02B20&#8243; button_alignment=&#8221;center&#8221; width=&#8221;100%&#8221; button_on_hover_tablet=&#8221;&#8221; button_on_hover_phone=&#8221;&#8221; button_on_hover_last_edited=&#8221;on|desktop&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>Read my article &#8216;Dynamic Selection: Find records in excerpts faster&#8217; here.<\/p>\n<p>Click here to download:<\/p>\n<p>[\/et_pb_cta][et_pb_cta button_url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9hdHRhY2htZW50Iiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM2OSJ9fQ==@&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _dynamic_attributes=&#8221;button_url&#8221; _module_preset=&#8221;default&#8221; header_font=&#8221;Montserrat||||||||&#8221; header_text_color=&#8221;rgba(0,0,0,0.69)&#8221; header_font_size=&#8221;28px&#8221; body_font=&#8221;Montserrat||||||||&#8221; body_text_color=&#8221;rgba(0,0,0,0.56)&#8221; body_font_size=&#8221;16px&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#000000&#8243; button_border_width=&#8221;0px&#8221; button_icon=&#8221;&#xf1c1;||fa||900&#8243; button_icon_color=&#8221;#E02B20&#8243; button_alignment=&#8221;center&#8221; width=&#8221;100%&#8221; button_on_hover_tablet=&#8221;&#8221; button_on_hover_phone=&#8221;&#8221; button_on_hover_last_edited=&#8221;on|desktop&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_cta][et_pb_icon font_icon=&#8221;&#xf1c1;||fa||900&#8243; icon_color=&#8221;#E02B20&#8243; icon_width=&#8221;53px&#8221; url=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9hdHRhY2htZW50Iiwic2V0dGluZ3MiOnsicG9zdF9pZCI6IjM2OSJ9fQ==@&#8221; url_new_window=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _dynamic_attributes=&#8221;url&#8221; _module_preset=&#8221;default&#8221; custom_margin=&#8221;-36%||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_icon][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; prev_background_color=&#8221;#ffe4c6&#8243; admin_label=&#8221;Trusted By&#8221; _builder_version=&#8221;4.27.4&#8243; background_color=&#8221;#014db7&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_stops=&#8221;#014db7 0%|#ffe4c6 100%&#8221; module_alignment=&#8221;right&#8221; custom_padding=&#8221;100px|0px|100px|0px|true|false&#8221; top_divider_style=&#8221;mountains&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Filemaker\u00a9 Add-Ons Dynamic Value Lists, MVLs, Client\/ParentFilemaker 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 \u201cnormal\u201d 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. Read my article &#8216;MVL-DYN, the dynamic value list in add-on format&#8217; here. Click here to download:Update Child\/Parent Function The new [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-657","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/pages\/657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/comments?post=657"}],"version-history":[{"count":5,"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/pages\/657\/revisions"}],"predecessor-version":[{"id":664,"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/pages\/657\/revisions\/664"}],"wp:attachment":[{"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/media?parent=657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}