The Data Source Table shows the rows of a Data Source field as a grid. Used plainly it lists the rows with one line each. With a Group By column it becomes a summary: one line per vendor, status, month or any other value, with statistics computed for each group, such as the number of invoices and the total amount, and a Total row at the bottom. It is a display field for dashboards and report-style forms; nothing in it is typed or saved. For rows that people enter, use the Table field. For a live list of records with open, edit and download actions, use the Search Results field.


Settings

Title - An optional heading above the grid. {field} and [variable] tokens are replaced when the form loads.


Data Source - The Data Source field that gathers the rows. Add a Data Source field to the form first, then pick it here. The same Data Source can also feed Stat Tiles and Data Source Charts, so one query drives a whole dashboard.


Group By Column - Leave it blank to show one line per row. Enter a column name to show one line per distinct value of that column, with the Statistic columns computed over the rows in each group. Values that differ only in capitalization are the same group. When the Data Source holds chart data, the label and value pairs the chart variables produce, use a position such as 1 or the words label, value or grouping.


Columns - Leave the list empty for the defaults: with a Group By column, the group value and a Count; without one, every column of the Data Source. Otherwise add the columns you want, in order, and drag them to reorder. Each column has a Header and is one of two types. A Column value shows the value from the row, or from the first row of the group. A Statistic totals the rows of the group with Sum, Count (rows), Average, Minimum or Maximum over the named column; Count ignores the column. A Statistic can also have a Filter so it counts or totals only some of the group's rows, written the same way as the DSCALC calculation, for example Paid=YES or Amount>100, with several conditions joined by ^. This is how one line can carry Invoices, Total and Paid side by side. Format shows the value as Text, as a Number, or as Currency, with the number of Decimal places you choose, and Alignment overrides the automatic alignment, which puts numbers and statistics on the right.


Filters - The same Filters as the Stat Tile: rows that do not match every line are left out before the grid is built, so a table of unpaid invoices only is the same Data Source with the filter Paid Equals NO.


Sort By - The initial order: the source order, or one of the configured columns, ascending or descending. Blank cells sort last and numbers sort before text. People can still click a column header to re-sort unless Allow header sorting is turned off in Display.


Top N - Show only the first lines after sorting, for example the top 10 vendors. 0 shows every line. The Total row still covers every row, not only the lines shown.


Row Click - What happens when someone clicks a line. Nothing is the default. Open the record works on ungrouped lines whose rows carry a RECORDID column, which the record lookup variables always include, and can open the record in a new window. Set a field writes the group value of the clicked line, or for ungrouped lines the record ID or the first cell, into the field you pick, so a Multi-Action on that field can run a search, refresh another Data Source or open something else.


Display

Show column headers, Allow header sorting and Show the Total row turn those parts of the grid on and off. The Total row appears only when the grid has at least one Statistic column; it shows each statistic computed over every row, with that statistic's own filter applied, and the word Total under the first column. A Sum or Count over no rows shows 0, and an Average, Minimum or Maximum over no rows is left blank.


Striped rows, Compact rows, Cell borders and Do not wrap cell text control the look of the grid.


Empty Text - The message shown when no rows remain, No data unless you change it.


Header Text Color and Header Background Color color the header row. The Height and Max Height settings on the common display card give the grid a scrolling body.