{"id":660,"date":"2025-08-05T09:09:11","date_gmt":"2025-08-05T07:09:11","guid":{"rendered":"https:\/\/woisoft.de\/how-it-works\/"},"modified":"2025-12-20T10:52:02","modified_gmt":"2025-12-20T09:52:02","slug":"how-it-works","status":"publish","type":"page","link":"https:\/\/woisoft.de\/en\/how-it-works\/","title":{"rendered":"How it works"},"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; hover_enabled=&#8221;0&#8243; 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; sticky_enabled=&#8221;0&#8243;]<\/p>\n<h6><\/h6>\n<h1>FM-Easybase<\/h1>\n<p><span>Create your individual database application without programming knowledge<\/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 _builder_version=&#8221;4.27.4&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.4&#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 basic tool FM-Easybase<\/h6>\n<h1><\/h1>\n<h1>Practical implementation of the example project<\/h1>\n<p data-ccp-border-bottom=\"0px none #000000\" data-ccp-padding-bottom=\"0px\" data-ccp-border-between=\"0px none #000000\" data-ccp-padding-between=\"0px\">[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#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_3&#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_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/1_z.png&#8221; title_text=&#8221;1_z; Source: private&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><strong><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">1. Which tables are needed?<\/span><\/span><\/strong><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">An example with multiple tables.<o:p><\/o:p><\/span><\/span><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">The saved tables are classified into three columns below:<o:p><\/o:p><\/span><\/span><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">Column 1: a layout is created in the menu for these tables, with which master data can be entered<o:p><\/o:p><\/span><\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#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_3&#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_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><strong><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">2. Table structure<\/span><\/span><\/strong><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">Column 2: here, the tables that are related to a table in column 1 are selected by mouse click<o:p><\/o:p><\/span><\/span><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">Column 3: in this column, tables can be specified that are related to a table in column 2.<\/span><\/span><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">Main table \u2192 Subtable \u2192 Sub-Subtable<\/span><\/span><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">This is referred to as 1:n <o:p><\/o:p><\/span><\/span><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">relationships.<o:p><\/o:p><\/span><\/span><\/p>\n<p>[\/et_pb_text][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/2_z.png&#8221; title_text=&#8221;2_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#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_3&#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_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/3_z.png&#8221; title_text=&#8221;3_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><strong><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">3. Define table contents<\/span><\/span><\/strong><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">After these preparations, the field names are defined in a service layout for each of the specified tables.<o:p><\/o:p><\/span><\/span><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\"><o:p><\/o:p><\/span><\/span><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">In the following example for the tables Customers and Articles, you can also see in the green area the selection of the fields that are made available for sorting and display in the portals, bookings and reports.<o:p><\/o:p><\/span><\/span><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\"><o:p><\/o:p><\/span><\/span><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">Service layout for the tables Customers and Articles:<o:p><\/o:p><\/span><\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/4_z.png&#8221; title_text=&#8221;4_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#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_3&#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_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/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 _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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;18px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><strong><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">4. Layouts<\/span><\/span><\/strong><\/p>\n<p><span>There are 3 different layout types:<\/span><\/p>\n<p><span><strong>Type A:<\/strong> <\/span><span>Layout for a single (main) table with create \/ <\/span><span>e<\/span><span>dit \/ d<\/span><span>elete<\/span><span> for all fields<\/span><\/p>\n<p><span><strong>Type B:<\/strong> Layout for a main table (6 selected fields are displayed) <\/span><span>and a 2nd table dependent on this table (with create \/ e<\/span><span>dit \/ d<\/span><span>elete<\/span><span> of all fields). In addition, <\/span><span>another table dependent on the 2nd table with 6 fields <\/span><span>can be managed in this layout<\/span><\/p>\n<p><span><strong>Type C:<\/strong> Layout for a main table with a display of up to 4 dependent<\/span><span> sub-tables with 3 selected fields each<\/span><\/p>\n<p>[\/et_pb_text][\/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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><strong><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">Type A<\/span><\/span><\/strong><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">The empty spaces in the layout result from undefined field names.<o:p><\/o:p><\/span><\/span><\/p>\n<p>[\/et_pb_text][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/5_z.png&#8221; title_text=&#8221;5_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; 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; _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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">In this example, the search mask is open. You can see that you can search by <\/span><\/span><span style=\"font-size: 14pt;\">company name, postal code or industry. These fields were defined as <\/span><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">search fields in the service layout (see above).<o:p><\/o:p><\/span><\/span><\/p>\n<p>[\/et_pb_text][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/6_z.png&#8221; title_text=&#8221;6_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; 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; _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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><strong><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">Type B<\/span><\/span><\/strong><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">In this layout type, a sub-table is displayed for a main table <o:p><\/o:p><\/span><\/span><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">with 6 columns. In this example, it is the branches that belong to the customer &#8216;Roggenkamp&#8217;.<o:p><\/o:p><\/span><\/span><\/p>\n<p>[\/et_pb_text][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/7_z.png&#8221; title_text=&#8221;7_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; 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; _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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;18px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\">After selecting a branch, several contact persons can be entered here in the lower part (sub-sub-table). In the upper part, all fields are listed which were defined in the service layout for the table branches. <\/p>\n<p>[\/et_pb_text][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/8_z.png&#8221; title_text=&#8221;8_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; 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; _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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><strong><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">Type C<\/span><\/span><\/strong><\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">In this layout type, up to 4 portals with entries in associated sub-tables can be displayed for a data record from the main table.<o:p><\/o:p><\/span><\/span><\/p>\n<p>[\/et_pb_text][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/9_z.png&#8221; title_text=&#8221;9_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#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_3&#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_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/10_z.png&#8221; title_text=&#8221;10_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;18px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><strong><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">5. Invoice and booking<\/span><\/span><\/strong><\/p>\n<p class=\"TextA\">In order to be able to create an invoice or a booking, a booking schema must first be created. This schema defines which tables are involved in the booking and which fields are necessary. <\/p>\n<p class=\"TextA\">The example shows the booking schema for invoices<\/p>\n<p>[\/et_pb_text][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/11_z.png&#8221; title_text=&#8221;11_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;18px&#8221; custom_margin=&#8221;10vw||||false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><span>After clicking on the displayed invoice header, the desired articles can be added.<\/span><\/p>\n<p>[\/et_pb_text][\/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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;18px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><span>After creating a booking schema, the customer address can be selected. This creates the invoice header. <\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/13_z.png&#8221; title_text=&#8221;13_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;12vw||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,2_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;18px&#8221; custom_margin=&#8221;||||false|false&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">The invoice then looks like this:<\/span><\/span><span class=\"Ohne\"><b><span style=\"font-size: 18.0pt;\"><o:p><\/o:p><\/span><\/b><\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/14_z.png&#8221; title_text=&#8221;14_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_3&#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_3&#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_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;18px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"TextA\"><strong><span class=\"Ohne\"><span style=\"font-size: 14.0pt;\">6. Evaluations<\/span><\/span><\/strong><\/p>\n<p><span>Evaluations are defined very easily using this schema:<\/span><span><strong> <\/strong><\/span><\/p>\n<p><span>The schema contains 3 blocks:<\/span> <\/p>\n<ul>\n<li><span>Selection criteria<\/span><\/li>\n<li><span>Grouping criteria<\/span><\/li>\n<li><span>Total fields (calculations are possible with a formula editor).<\/span><\/li>\n<\/ul>\n<p>Exactly those fields that were specified in the service layouts can be selected.<\/p>\n<p>[\/et_pb_text][\/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_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/15_z.png&#8221; title_text=&#8221;15_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/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_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;18px&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p>With this information you get the following evaluation:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;http:\/\/woisoft.de\/wp-content\/uploads\/2025\/09\/16_z.png&#8221; title_text=&#8221;16_z&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/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>FM-Easybase Create your individual database application without programming knowledgeFilemaker basic tool FM-Easybase Practical implementation of the example project 1. Which tables are needed? An example with multiple tables. The saved tables are classified into three columns below: Column 1: a layout is created in the menu for these tables, with which master data can be entered2. Table structure Column 2: here, the tables that are related to a table in column 1 are selected by mouse click Column 3: in this column, tables can be specified that are related to a table in column 2. Main table \u2192 Subtable \u2192 Sub-Subtable This is referred to as 1:n relationships.3. Define table contents After these preparations, the field names are defined in a service layout for each of the specified tables. In the following example for the tables Customers and Articles, you can also see in the green area the selection of the fields that are made available for sorting and display in the portals, bookings and reports.Service layout for the tables Customers and Articles:4. Layouts There are 3 different layout types: Type A: Layout for a single (main) table with create \/ edit \/ delete for all fields Type B: Layout [&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-660","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/pages\/660","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=660"}],"version-history":[{"count":2,"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/pages\/660\/revisions"}],"predecessor-version":[{"id":665,"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/pages\/660\/revisions\/665"}],"wp:attachment":[{"href":"https:\/\/woisoft.de\/en\/wp-json\/wp\/v2\/media?parent=660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}