{"id":243570,"date":"2020-09-26T21:12:48","date_gmt":"2020-09-26T19:12:48","guid":{"rendered":"https:\/\/daylitepro.com\/daylite-crm-software\/individual\/datamanagement\/"},"modified":"2020-10-12T15:13:18","modified_gmt":"2020-10-12T13:13:18","slug":"datamanagement","status":"publish","type":"page","link":"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/","title":{"rendered":"DataManagement"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; disabled_on=&#8221;off|on|on&#8221; module_class=&#8221;orange rays&#8221; _builder_version=&#8221;4.6.0&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#00b7e3&#8243; background_color_gradient_end=&#8221;#008be2&#8243; height=&#8221;400px&#8221; height_tablet=&#8221;&#8221; height_phone=&#8221;659px&#8221; height_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;40px||0px||false|false&#8221; top_divider_color=&#8221;#d6d6d6&#8243; bottom_divider_color=&#8221;#e09900&#8243;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.5.6&#8243; min_height=&#8221;114px&#8221; custom_padding=&#8221;20px||0px|||&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.4.5&#8243; custom_padding=&#8221;4px||||false|false&#8221;][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#ffffff&#8221; text_font_size=&#8221;50px&#8221; text_line_height=&#8221;1em&#8221; header_font=&#8221;||||||||&#8221; header_text_color=&#8221;#ffffff&#8221; header_font_size=&#8221;45px&#8221; header_2_font=&#8221;||||||||&#8221; text_orientation=&#8221;center&#8221; min_height=&#8221;28px&#8221; custom_margin=&#8221;||35px|||&#8221;]<\/p>\n<h1 style=\"text-align: left;\">DataManagement<\/h1>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#ffffff&#8221; text_font_size=&#8221;23px&#8221; header_font=&#8221;||||||||&#8221; header_2_font=&#8221;||||||||&#8221; header_2_text_color=&#8221;#ffffff&#8221; header_2_font_size=&#8221;22px&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;0px||37px||false|false&#8221; custom_padding=&#8221;||0px|||&#8221;]<\/p>\n<h2>Excel-like Editing of Daylite forms<\/h2>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/iosxpert.biz\/wp-content\/uploads\/2020\/10\/datamanagement.png&#8221; title_text=&#8221;datamanagement&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.6.5&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;7px||||false|false&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;][\/et_pb_image][et_pb_button button_url=&#8221;https:\/\/iosxpert-en.acuityscheduling.com\/schedule.php?appointmentType=4473839&amp;_ga=2.158067962.1905187732.1600697629-668753677.1595841383&#8243; button_text=&#8221;Please contact us&#8221; button_alignment=&#8221;center&#8221; module_class=&#8221;acuity-embed-button&#8221; _builder_version=&#8221;4.6.0&#8243; custom_button=&#8221;on&#8221; button_text_size=&#8221;22px&#8221; button_text_color=&#8221;#FE7F51&#8243; button_bg_color=&#8221;#ffffff&#8221; button_border_width=&#8221;2px&#8221; button_border_color=&#8221;#ffffff&#8221; button_border_radius=&#8221;5px&#8221; button_font=&#8221;||||||||&#8221; background_layout=&#8221;dark&#8221; custom_margin=&#8221;||34px|||&#8221; custom_css_main_element=&#8221;color: #FE7F51!important;||border-width: 1px!important;||border-color: #FE7F51!important;||border-radius: 5px!important;||font-size: 20px!important;||background-color: #ffffff!important;&#8221;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#ffffff&#8221; header_font=&#8221;||||||||&#8221; header_2_font=&#8221;||||||||&#8221; header_2_font_size=&#8221;8px&#8221; header_3_text_color=&#8221;#ffffff&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;3px|||||&#8221;]<\/p>\n<h3>Exclusive for Daylite on the Mac<\/h3>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;3.25.4&#8243;][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; disabled_on=&#8221;on|off|off&#8221; module_class=&#8221;orange rays&#8221; _builder_version=&#8221;4.6.0&#8243; use_background_color_gradient=&#8221;on&#8221; background_color_gradient_start=&#8221;#00b7e3&#8243; background_color_gradient_end=&#8221;#008be2&#8243; height=&#8221;400px&#8221; height_tablet=&#8221;&#8221; height_phone=&#8221;659px&#8221; height_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;40px||5px||false|false&#8221; top_divider_color=&#8221;#d6d6d6&#8243; bottom_divider_color=&#8221;#e09900&#8243;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.6.0&#8243; min_height=&#8221;114px&#8221; custom_padding=&#8221;5px||0px||false|false&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.4.5&#8243; custom_padding=&#8221;4px||||false|false&#8221;][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#ffffff&#8221; text_font_size=&#8221;50px&#8221; text_line_height=&#8221;1em&#8221; header_font=&#8221;||||||||&#8221; header_text_color=&#8221;#ffffff&#8221; header_font_size=&#8221;50px&#8221; header_2_font=&#8221;||||||||&#8221; text_orientation=&#8221;center&#8221; min_height=&#8221;28px&#8221; custom_margin=&#8221;||35px|||&#8221;]<\/p>\n<h1 style=\"text-align: left;\">DataManagement<\/h1>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#ffffff&#8221; text_font_size=&#8221;23px&#8221; header_font=&#8221;||||||||&#8221; header_2_font=&#8221;||||||||&#8221; header_2_text_color=&#8221;#ffffff&#8221; header_2_font_size=&#8221;22px&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;0px||37px||false|false&#8221; custom_padding=&#8221;||0px|||&#8221;]<\/p>\n<h2 style=\"text-align: left;\">Excel-like Editing of Daylite forms<\/h2>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/iosxpert-en.acuityscheduling.com\/schedule.php?appointmentType=4473839&amp;_ga=2.158067962.1905187732.1600697629-668753677.1595841383&#8243; button_text=&#8221;Please contact us&#8221; button_alignment=&#8221;left&#8221; module_class=&#8221;acuity-embed-button&#8221; _builder_version=&#8221;4.6.0&#8243; custom_button=&#8221;on&#8221; button_text_size=&#8221;22px&#8221; button_text_color=&#8221;#FE7F51&#8243; button_bg_color=&#8221;#ffffff&#8221; button_border_width=&#8221;2px&#8221; button_border_color=&#8221;#ffffff&#8221; button_border_radius=&#8221;5px&#8221; button_font=&#8221;||||||||&#8221; background_layout=&#8221;dark&#8221; custom_margin=&#8221;||34px|||&#8221; custom_css_main_element=&#8221;color: #FE7F51!important;||border-width: 1px!important;||border-color: #FE7F51!important;||border-radius: 5px!important;||font-size: 20px!important;||background-color: #ffffff!important;&#8221;][\/et_pb_button][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#ffffff&#8221; header_font=&#8221;||||||||&#8221; header_2_font=&#8221;||||||||&#8221; header_2_font_size=&#8221;8px&#8221; header_3_text_color=&#8221;#ffffff&#8221; text_orientation=&#8221;center&#8221; custom_margin=&#8221;3px|||||&#8221;]<\/p>\n<h3 style=\"text-align: left;\">Exclusive for Daylite on the Mac<\/h3>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;3.25.4&#8243;][et_pb_image src=&#8221;https:\/\/iosxpert.biz\/wp-content\/uploads\/2020\/10\/datamanagement.png&#8221; title_text=&#8221;datamanagement&#8221; show_in_lightbox=&#8221;on&#8221; _builder_version=&#8221;4.6.5&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;10px||||false|false&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.5.6&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;15px||3px||false|false&#8221; global_module=&#8221;237192&#8243;][et_pb_row _builder_version=&#8221;4.5.6&#8243; _module_preset=&#8221;default&#8221; width=&#8221;90%&#8221; max_width=&#8221;1160px&#8221; custom_padding=&#8221;3px||3px|||&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.5.6&#8243; _module_preset=&#8221;default&#8221;]<\/p>\n<p>[et_pb_dcsbcm_divi_breadcrumbs_module homebreadcrumbtext=&#8221;Home&#8221; hide_currentbreadcrumb=&#8221;off&#8221; _builder_version=&#8221;4.5.6&#8243; _module_preset=&#8221;default&#8221; body_font_size=&#8221;13px&#8221; body_line_height=&#8221;0em&#8221; custom_padding=&#8221;||||false|false&#8221;][\/et_pb_dcsbcm_divi_breadcrumbs_module]<\/p>\n<p>[\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Features&#8221; _builder_version=&#8221;3.22&#8243; custom_padding=&#8221;24px|0px|30px|0px|false|&#8221;][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; use_custom_gutter=&#8221;on&#8221; gutter_width=&#8221;2&#8243; _builder_version=&#8221;4.6.0&#8243; width_tablet=&#8221;&#8221; width_phone=&#8221;90%&#8221; width_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;0px||6px||false|false&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_image src=&#8221;https:\/\/iosxpert.biz\/wp-content\/uploads\/2020\/09\/menschen-orange.png&#8221; alt=&#8221;or.png&#8221; title_text=&#8221;or.png&#8221; _builder_version=&#8221;4.6.0&#8243; max_width=&#8221;30%&#8221; module_alignment=&#8221;center&#8221;][\/et_pb_image][et_pb_blurb title=&#8221;Table editing function for form data&#8221; _builder_version=&#8221;4.6.0&#8243; header_font=&#8221;|600|||||||&#8221; header_font_size=&#8221;18px&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;25px||||false|false&#8221; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;||||false|false&#8221; custom_padding_tablet=&#8221;&#8221; custom_padding_phone=&#8221;||25px||false|false&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; animation=&#8221;off&#8221; border_color_all_image=&#8221;rgba(0,0,0,0.1)&#8221;]<\/p>\n<p>Faster capture and correction of form data. Each field can be edited directly within the table view.<\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_image src=&#8221;https:\/\/iosxpert.biz\/wp-content\/uploads\/2020\/09\/geld-orange.png&#8221; alt=&#8221;gor.png&#8221; title_text=&#8221;gor.png&#8221; _builder_version=&#8221;4.6.0&#8243; max_width=&#8221;30%&#8221; module_alignment=&#8221;center&#8221;][\/et_pb_image][et_pb_blurb title=&#8221;Totaling of form fields&#8221; _builder_version=&#8221;4.6.0&#8243; header_font=&#8221;|600|||||||&#8221; header_font_size=&#8221;18px&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;25px||||false|false&#8221; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding_tablet=&#8221;&#8221; custom_padding_phone=&#8221;||25px||false|false&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; animation=&#8221;off&#8221; border_color_all_image=&#8221;rgba(0,0,0,0.1)&#8221;]<\/p>\n<p>Totals can be created for individual fields of several forms in table view.<\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;3.25&#8243; custom_padding=&#8221;|||&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_image src=&#8221;https:\/\/iosxpert.biz\/wp-content\/uploads\/2020\/09\/ziel-orange.png&#8221; alt=&#8221;zor.png&#8221; title_text=&#8221;zor&#8221; _builder_version=&#8221;4.6.0&#8243; max_width=&#8221;30%&#8221; module_alignment=&#8221;center&#8221;][\/et_pb_image][et_pb_blurb title=&#8221;Pivot evaluations with diagrams&#8221; _builder_version=&#8221;4.6.0&#8243; header_font=&#8221;|600|||||||&#8221; header_font_size=&#8221;18px&#8221; header_line_height=&#8221;1.4em&#8221; body_font=&#8221;||||||||&#8221; body_line_height=&#8221;1.8em&#8221; text_orientation=&#8221;center&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;25px||||false|false&#8221; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; animation=&#8221;off&#8221; border_color_all_image=&#8221;rgba(0,0,0,0.1)&#8221;]<\/p>\n<p>Graphical pivot evaluations of form data with free assignment of x and y axes.<\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.4.5&#8243; custom_padding=&#8221;27px||5px||false|false&#8221;][et_pb_row _builder_version=&#8221;4.4.5&#8243; width_tablet=&#8221;&#8221; width_phone=&#8221;90%&#8221; width_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;4px||7px|||&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.4.5&#8243;][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#777777&#8243; text_line_height=&#8221;1.8em&#8221; link_font=&#8221;||||||||&#8221; ul_font=&#8221;||||||||&#8221; ol_font=&#8221;||||||||&#8221; quote_font=&#8221;||||||||&#8221; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#000000&#8243; header_font_size=&#8221;32px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;||||||||&#8221; header_2_text_color=&#8221;#000000&#8243; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.3em&#8221; module_alignment=&#8221;center&#8221; text_orientation_last_edited=&#8221;off|desktop&#8221;]<\/p>\n<h2 style=\"text-align: center;\">Excel-like Editing of Daylite forms<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.4.5&#8243; width_tablet=&#8221;&#8221; width_phone=&#8221;90%&#8221; width_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;18px||15px|||&#8221; width__hover_enabled=&#8221;on|desktop&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.4.5&#8243;][et_pb_text _builder_version=&#8221;4.6.5&#8243; text_line_height=&#8221;1.8em&#8221;]<\/p>\n<p>Our customer used thousands of Daylite forms for data collection and analysis. Collecting data via the detailed view of each form was very time consuming. To create graphical evaluations and pivot tables, the Daylite data had to be imported into Excel. And in Excel, the links to further information from Daylite were missing. The goal was to perform the entire data analysis in Daylite and to speed up the collection of data.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.4.5&#8243; custom_padding=&#8221;27px||5px||false|false&#8221;][et_pb_row _builder_version=&#8221;4.4.5&#8243; width_tablet=&#8221;&#8221; width_phone=&#8221;90%&#8221; width_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;4px||7px|||&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.4.5&#8243;][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#777777&#8243; text_line_height=&#8221;1.8em&#8221; link_font=&#8221;||||||||&#8221; ul_font=&#8221;||||||||&#8221; ol_font=&#8221;||||||||&#8221; quote_font=&#8221;||||||||&#8221; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#000000&#8243; header_font_size=&#8221;32px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;||||||||&#8221; header_2_text_color=&#8221;#000000&#8243; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.3em&#8221; module_alignment=&#8221;center&#8221; text_orientation_last_edited=&#8221;off|desktop&#8221;]<\/p>\n<h2 style=\"text-align: center;\">Development of a Data Management Plugin for Daylite<\/h2>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.4.5&#8243; width_tablet=&#8221;&#8221; width_phone=&#8221;90%&#8221; width_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;18px||15px|||&#8221; width__hover_enabled=&#8221;on|desktop&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.4.5&#8243;][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_line_height=&#8221;1.8em&#8221;]<\/p>\n<p>In order to meet the customer&#8217;s requirements, we developed a separate view for Daylite forms. This allows the editing of each cell in a form directly in the table view. The familiar sorting, fade in and fade out functions of Daylite remain unchanged. With a slide switch, you can switch from the table view to a pivot\/graph view. Here, any values from the form can be placed on the x- or y-axis and different diagram representations can also be selected. This allows dynamic, graphical evaluations, similar to those from Excel, within Daylite. The settings of the table view as well as the graphical analysis can be saved as a template and can be changed quickly or shared by all team members.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.4.5&#8243; custom_margin_tablet=&#8221;&#8221; custom_margin_phone=&#8221;||10px||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;29px||40px||false|&#8221;][et_pb_row _builder_version=&#8221;4.4.5&#8243; background_color=&#8221;rgba(0,0,0,0.05)&#8221; width_tablet=&#8221;&#8221; width_phone=&#8221;90%&#8221; width_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;||40px|||&#8221; border_width_all=&#8221;1px&#8221; border_color_all=&#8221;#ef8b23&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.4.5&#8243;][et_pb_text _builder_version=&#8221;4.4.5&#8243; text_font=&#8221;||||||||&#8221; text_text_color=&#8221;#777777&#8243; text_line_height=&#8221;1.8em&#8221; link_font=&#8221;||||||||&#8221; ul_font=&#8221;||||||||&#8221; ol_font=&#8221;||||||||&#8221; quote_font=&#8221;||||||||&#8221; header_font=&#8221;|600|||||||&#8221; header_text_align=&#8221;left&#8221; header_text_color=&#8221;#000000&#8243; header_font_size=&#8221;32px&#8221; header_line_height=&#8221;1.4em&#8221; header_2_font=&#8221;||||||||&#8221; header_2_text_color=&#8221;#000000&#8243; header_2_font_size=&#8221;35px&#8221; header_2_line_height=&#8221;1.3em&#8221; module_alignment=&#8221;center&#8221;]<\/p>\n<h2 class=\"margin-bottom\" style=\"text-align: center;\">Most Important Features<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; text_line_height=&#8221;1.8em&#8221; custom_margin=&#8221;||14px||false|false&#8221; custom_padding=&#8221;|20px||20px|false|false&#8221;]<\/p>\n<div style=\"margin-bottom: 20px;\">\n<ul>\n<li class=\"bulleted-list__item\"><strong>Table view with editing function for Daylite forms<\/strong><\/li>\n<\/ul>\n<\/div>\n<div style=\"margin-bottom: 20px;\">\n<ul>\n<li class=\"bulleted-list__item\"><strong>Summation of form fields in the table view<\/strong><\/li>\n<\/ul>\n<\/div>\n<div style=\"margin-bottom: 20px;\">\n<ul>\n<li class=\"bulleted-list__item\"><strong>Columns can be added or hidden as desired<\/strong><\/li>\n<\/ul>\n<\/div>\n<div style=\"margin-bottom: 20px;\">\n<ul>\n<li class=\"bulleted-list__item\"><strong>Views can be saved as templates<\/strong><\/li>\n<\/ul>\n<\/div>\n<div style=\"margin-bottom: 20px;\">\n<ul>\n<li class=\"bulleted-list__item\"><strong>Selection of forms via smart lists possible<\/strong><\/li>\n<\/ul>\n<\/div>\n<div style=\"margin-bottom: 20px;\">\n<ul>\n<li class=\"bulleted-list__item\"><strong>Pivot evaluations with freely definable values<\/strong><\/li>\n<\/ul>\n<\/div>\n<div style=\"margin-bottom: 20px;\">\n<ul>\n<li class=\"bulleted-list__item\"><strong>Evaluations can be saved as templates<\/strong><\/li>\n<\/ul>\n<\/div>\n<div style=\"margin-bottom: 20px;\">\n<ul>\n<li class=\"bulleted-list__item\"><strong>Display of different diagram types via drag &amp; drop<\/strong><\/li>\n<\/ul>\n<\/div>\n<div style=\"margin-bottom: 20px;\">\n<ul>\n<li class=\"bulleted-list__item\"><strong>Direct filtering of values during display<\/strong><\/li>\n<\/ul>\n<\/div>\n<div style=\"margin-bottom: 20px;\">\u00a0<\/div>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; module_id=&#8221;appointment&#8221; _builder_version=&#8221;4.5.1&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;2px||45px|||&#8221;][et_pb_row _builder_version=&#8221;4.4.2&#8243; custom_padding=&#8221;30px||5px||false|false&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.0.6&#8243;][et_pb_text admin_label=&#8221;1&#8243; _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;||||||||&#8221; text_font_size=&#8221;20px&#8221; text_line_height=&#8221;1.6em&#8221; header_font=&#8221;||||||||&#8221; header_text_align=&#8221;center&#8221; header_text_color=&#8221;#000000&#8243; header_font_size=&#8221;45px&#8221; header_line_height=&#8221;1.3em&#8221; header_2_text_align=&#8221;center&#8221; header_2_text_color=&#8221;#000000&#8243; header_2_font_size=&#8221;35px&#8221; background_layout=&#8221;dark&#8221; module_alignment=&#8221;center&#8221; custom_margin=&#8221;||25px||false|false&#8221; custom_padding=&#8221;||0px||false|false&#8221; custom_padding_tablet=&#8221;&#8221; custom_padding_phone=&#8221;||30px||false|false&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; header_font_size_tablet=&#8221;&#8221; header_font_size_phone=&#8221;35px&#8221; header_font_size_last_edited=&#8221;on|desktop&#8221; locked=&#8221;off&#8221;]<\/p>\n<h2>Make an Appointment<\/h2>\n<p>[\/et_pb_text][et_pb_blurb title=&#8221;Free Consultation Appointment&#8221; image=&#8221;https:\/\/iosxpert.biz\/wp-content\/uploads\/2020\/04\/rocket-r.png&#8221; _builder_version=&#8221;4.6.0&#8243; header_level=&#8221;h2&#8243; header_font=&#8221;|600|||||||&#8221; header_text_color=&#8221;#777777&#8243; header_font_size=&#8221;20px&#8221; body_text_color=&#8221;#777777&#8243; text_orientation=&#8221;center&#8221; animation=&#8221;off&#8221;]<\/p>\n<p style=\"text-align: center;\">We are happy to advise you free of charge if you have individual requirements for Daylite.<\/p>\n<p>[\/et_pb_blurb][et_pb_button button_url=&#8221;https:\/\/iosxpert-en.acuityscheduling.com\/schedule.php?appointmentType=4473839&amp;_ga=2.158067962.1905187732.1600697629-668753677.1595841383&#8243; url_new_window=&#8221;on&#8221; button_text=&#8221;Make an appointment&#8221; button_alignment=&#8221;center&#8221; module_class=&#8221;acuity-embed-button btn_ga_beratungstermin&#8221; _builder_version=&#8221;4.4.8&#8243; custom_button=&#8221;on&#8221; button_text_size=&#8221;20px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2da940&#8243; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;5px&#8221; button_icon_color=&#8221;#ffffff&#8221; background_layout=&#8221;dark&#8221; custom_margin=&#8221;||0px|||&#8221; background_layout_tablet=&#8221;dark&#8221; background_layout_last_edited=&#8221;off|desktop&#8221; custom_css_main_element=&#8221;background-color: #2da940 !important&#8221; background_layout__hover_enabled=&#8221;on|desktop&#8221;][\/et_pb_button][et_pb_code _builder_version=&#8221;4.4.2&#8243;]<script src=\"https:\/\/embed.acuityscheduling.com\/embed\/button\/14471582.js\" async><\/script>[\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DataManagementExcel-like Editing of Daylite formsExclusive for Daylite on the MacDataManagementExcel-like Editing of Daylite forms &nbsp;Exclusive for Daylite on the MacFaster capture and correction of form data. Each field can be edited directly within the table view.Totals can be created for individual fields of several forms in table view.Graphical pivot evaluations of form data with free [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"parent":243393,"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":""},"dipi_cpt_category":[],"class_list":["post-243570","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Pivot Tables and Form Summation - Daylite, CRM for Mac<\/title>\n<meta name=\"description\" content=\"Use Daylite forms with Excel features. Form totals, enter data in list view or create dynamic pivot tables with graphics.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DataManagement\" \/>\n<meta property=\"og:description\" content=\"Use Daylite forms with Excel features. Form totals, enter data in list view or create dynamic pivot tables with graphics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/\" \/>\n<meta property=\"og:site_name\" content=\"iOSXpert\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/iosxpertbiz\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-12T13:13:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/iosxpert.biz\/wp-content\/uploads\/2020\/10\/iO.png\" \/>\n\t<meta property=\"og:image:width\" content=\"980\" \/>\n\t<meta property=\"og:image:height\" content=\"513\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/\",\"url\":\"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/\",\"name\":\"Pivot Tables and Form Summation - Daylite, CRM for Mac\",\"isPartOf\":{\"@id\":\"https:\/\/iosxpert.biz\/en\/#website\"},\"datePublished\":\"2020-09-26T19:12:48+00:00\",\"dateModified\":\"2020-10-12T13:13:18+00:00\",\"description\":\"Use Daylite forms with Excel features. Form totals, enter data in list view or create dynamic pivot tables with graphics.\",\"breadcrumb\":{\"@id\":\"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/iosxpert.biz\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Daylite CRM for Mac, iPhone &#038; iPad\",\"item\":\"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Daylite Individual\",\"item\":\"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"DataManagement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/iosxpert.biz\/en\/#website\",\"url\":\"https:\/\/iosxpert.biz\/en\/\",\"name\":\"iOSXpert\",\"description\":\"Business auf Mac &amp; iPhone\",\"publisher\":{\"@id\":\"https:\/\/iosxpert.biz\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/iosxpert.biz\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/iosxpert.biz\/en\/#organization\",\"name\":\"iOSXpert Business auf Mac & iPhone GmbH\",\"alternateName\":\"iOSXpert\",\"url\":\"https:\/\/iosxpert.biz\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/iosxpert.biz\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/iosxpert.biz\/wp-content\/uploads\/2025\/06\/iO_Logo_696x696.png\",\"contentUrl\":\"https:\/\/iosxpert.biz\/wp-content\/uploads\/2025\/06\/iO_Logo_696x696.png\",\"width\":696,\"height\":696,\"caption\":\"iOSXpert Business auf Mac & iPhone GmbH\"},\"image\":{\"@id\":\"https:\/\/iosxpert.biz\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/iosxpertbiz\",\"https:\/\/www.linkedin.com\/company\/iosxpert\/\"],\"email\":\"hallo@iosxpert.biz\",\"telephone\":\"+49 2622 9780000\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Pivot Tables and Form Summation - Daylite, CRM for Mac","description":"Use Daylite forms with Excel features. Form totals, enter data in list view or create dynamic pivot tables with graphics.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/","og_locale":"en_US","og_type":"article","og_title":"DataManagement","og_description":"Use Daylite forms with Excel features. Form totals, enter data in list view or create dynamic pivot tables with graphics.","og_url":"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/","og_site_name":"iOSXpert","article_publisher":"https:\/\/www.facebook.com\/iosxpertbiz","article_modified_time":"2020-10-12T13:13:18+00:00","og_image":[{"width":980,"height":513,"url":"https:\/\/iosxpert.biz\/wp-content\/uploads\/2020\/10\/iO.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/","url":"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/","name":"Pivot Tables and Form Summation - Daylite, CRM for Mac","isPartOf":{"@id":"https:\/\/iosxpert.biz\/en\/#website"},"datePublished":"2020-09-26T19:12:48+00:00","dateModified":"2020-10-12T13:13:18+00:00","description":"Use Daylite forms with Excel features. Form totals, enter data in list view or create dynamic pivot tables with graphics.","breadcrumb":{"@id":"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/datamanagement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/iosxpert.biz\/en\/"},{"@type":"ListItem","position":2,"name":"Daylite CRM for Mac, iPhone &#038; iPad","item":"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/"},{"@type":"ListItem","position":3,"name":"Daylite Individual","item":"https:\/\/iosxpert.biz\/en\/daylite-crm-software\/individual\/"},{"@type":"ListItem","position":4,"name":"DataManagement"}]},{"@type":"WebSite","@id":"https:\/\/iosxpert.biz\/en\/#website","url":"https:\/\/iosxpert.biz\/en\/","name":"iOSXpert","description":"Business auf Mac &amp; iPhone","publisher":{"@id":"https:\/\/iosxpert.biz\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/iosxpert.biz\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/iosxpert.biz\/en\/#organization","name":"iOSXpert Business auf Mac & iPhone GmbH","alternateName":"iOSXpert","url":"https:\/\/iosxpert.biz\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/iosxpert.biz\/en\/#\/schema\/logo\/image\/","url":"https:\/\/iosxpert.biz\/wp-content\/uploads\/2025\/06\/iO_Logo_696x696.png","contentUrl":"https:\/\/iosxpert.biz\/wp-content\/uploads\/2025\/06\/iO_Logo_696x696.png","width":696,"height":696,"caption":"iOSXpert Business auf Mac & iPhone GmbH"},"image":{"@id":"https:\/\/iosxpert.biz\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/iosxpertbiz","https:\/\/www.linkedin.com\/company\/iosxpert\/"],"email":"hallo@iosxpert.biz","telephone":"+49 2622 9780000","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}}]}},"_links":{"self":[{"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/pages\/243570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/comments?post=243570"}],"version-history":[{"count":9,"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/pages\/243570\/revisions"}],"predecessor-version":[{"id":246549,"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/pages\/243570\/revisions\/246549"}],"up":[{"embeddable":true,"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/pages\/243393"}],"wp:attachment":[{"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/media?parent=243570"}],"wp:term":[{"taxonomy":"dipi_cpt_category","embeddable":true,"href":"https:\/\/iosxpert.biz\/en\/wp-json\/wp\/v2\/dipi_cpt_category?post=243570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}