Datalist Properties

Datalist

The program comes with several predefined Datalists. To access the predefined lists, select the ellipsis button in the Datalist field. The Search screen appears. To view a list of all Datalists available, select Search. A list of all Datalists appears with a brief description. If you know the name or part of the name of the list to use, enter the information in the Name field and select Search. You can also restrict your search based on Record type. After you find the list, select it and select Select. You return to the properties screen.

ContextType

You must identify the context of the record to display in this Datalist. Most Datalists require a “PageContext.” You can also select a “PageExpressionField” or “Expression.” For more information about ContextTypes, see Select ContextType.

PageExpressionField

If you select “PageExpressionField” in the ContextType field, you must select the PageExpressionField to use.

Expression

If you select “Expression” in the ContextType field, you must select the Expression to use. For more information, see Use Expressions In Design Mode.

ShowBorder

Visibility status of the section border: False = not visible; True = visible.

Style

Select how to arrange your datalist. If you select “GroupedView,” all data is grouped into one list, as on the Catalog Browser page in Administration; if you select “StandardGrid” view, the data is listed in a grid format, as on the Names tab on the constituent record; if you select “RepeaterView,” the data is listed in a repeated format, as on the Occurrences tab on the Job page in Volunteers and the Addresses frame on the Contact tab in a constituent record.

ExpandFirstLevelNodes

Select” True” for the program to expand the immediate children of the root when it loads the Datalist. By default, the program collapses the entire list and only exposes the top level.

ExpandAllOnLoad

Select” True” for the program to expand all children of the root when it loads the Datalist. By default, the program collapses the entire list and only exposes the top level.

ViewDataForm

Select data to view in the Datalist. For example, on the Occurrences tab of a Job record, you probably want to view job occurrence information; therefore, you would select the “Job Occurrence View Dataform.” The program then pulls occurrence data for the job and displays it on this tab. You can use an existing ViewDataForm or an expression. To use an expression, in the drop-down menu in the ViewDataForm field, select “Expression.” The Expression screen appears. To use an existing form, in the drop-down menu in the ViewDataForm field, select “Browse.” The Search screen appears. To view a list of all ViewDataForms available, select Search. A list of all forms appears with a brief description. If you know the name or part of the name of the form to use, enter it in the Name field and select Search. You can also restrict your search based on Record type. After you find the form, select it and select Select. You return to the properties screen.

Record ID

Appears if you select a ViewDataForm. The ViewDataForm column to use as a source for the record ID.

HeaderCaption

Appears if you select a ViewDataForm. A header for the new ViewDataForm section.

Groups

If in the Style field, you select “GroupedView,” the Groups field appears. To select a field to group data by, select the ellipsis at the end of the field. The Select Group Fields screen appears. In the Available Fields box, select the field to use. In the Default Grouping field, you can select a group for the program to use as a default. Select OK to return to the properties screen.

HeaderBackColor

If in the Style field, you select “RepeaterView,” the HeaderBackColor field appears, allowing you to select a background color to appear behind each header on the page.

HeaderGradientBackColor

If in the Style field, you select “RepeaterView,” the GradientBackColor field appears, allowing you to select a gradient background color to appear behind each header on the page.

CaptionColor

Select a color for your header text.

AutoSize

If in the Style field, you select “StandardGridView,” the AutoSize field appears, allowing you to select to automatically size the grid based on the amount of data retrieved; you can select False = not automatically sized or True = automatically sized.

AutoLoadList

Select” True” for the program to automatically load the data into the Datalist when the section is accessed. If you select “False,” the data does not load; a link appears asking you to select to load the data.

AutoDisplayFilters

Select “True” for filter controls to appear when the section opens. If you select “False,” no filters appear.

Legend

Use this option to customize the color and font in a grid, such as the Giving History grid. For example, for a giving history you can designate amounts > $120 = italic and violet red, pledges = bold and yellow, and gifts > $1000 = green. The change is system-wide not per user.

To make this change, from the Legend field on the property screen select the ellipsis at the end of the field. The Legend screen appears. From this screen, you can add multiple expressions that evaluate to “True” and “False.” If the expression is “True” the font and color indicated are applied to the row. Select OK to return to the properties screen.