Table Properties
There are many fields you can use to customize a table, but they are not required. WEP Forms can generate a table either without these properties or using default values. See each field and its funct…
There are many fields you can use to customize a table, but they are not required. WEP Forms can generate a table either without these properties or using default values. See each field and its functionality below. See bottom this page for examples.
Filed Name | Field Type | Description - How To Use Fields |
Item # Type | Multiple Choice | Use this for displaying Item#(item counter) for each row. You can also select column to display this. Options: First Column, First Column-Reset by Grouping, Last Column, Last Column-Reset by Grouping |
# of Items Per Page | Numeric | Use this, if you want specific number of records to be displayed on each page. Example: If you select 5, on each page there will be 5 rows. |
Headers | Checkbox | Hide or Show table headers. When selected, table column headers will be displayed. |
Borders | Checkbox | Hide or Show table borders. When selected, table borders will be displayed. |
No Split Rows | Checkbox | Select this to prevent rows split into two pages. If last row on page doesn't fit on that page, it will start on second page. |
Row Color Field | Numeric | Field ID of table (subtable) field that holds row background color. This can text field or formula text field. This field shows hexadecimal color value or color name. Field value or formula examples: "#2a85c6" If([Status]="Paid", "#2a85c6", "Red") If you want to use alternate row background color, separate colors by “~” Example 1: "#2a85c6~#4d4dff" ==> Odd rows background color is #2a85c6 and even rows background color is #4d4dff Example 2: "#2a85c6~#4d4dff~#e6e6e6" ==> Defines background colors for three rows; every group of three rows repeats the same color sequence. |
Rows Per Record | Numeric | For Excel templates only. Displays one table record per selected number. Example: If set to 3, skip next two rows or adds two empty rows between records. Use this to combine multiple tables' records. |
Table Alignment | Multiple Choice | This is how the table will be aligned on document. Options: Left, Center and Right |
Cell Spacing | Numeric | For Word templates only. Add space between table cells. Cell Spacing is 1  Cell Spacing is blank  |
Header Vertical Text Direction | Multiple Choice | For Word templates only. Column headers label will be displayed in vertically Options: Bottom To Top, Top To Bottom |
Header Row Height | Numeric | For Word templates only. Use this if you are using “Header Vertical Text Direction” field to control header row height. |
(ALL) Border Style | Multiple Choice | Use this to select border style. Examples: “None”, “Single”, “Double”. |
(ALL) Border Size | Numeric | Use this to select border size. Use integer numbers(No Decimals) |
(ALL) Border Style | Text | Use this to select border color. Examples: “Red”, “"#2a85c6”, “#000000”. |
EXAMPLES: See two different configurations and results for the same below:
Settings 1 below show table properties fields' values in WEP Table record under Table Properties tab. Row will be highlighted if amount is greater than $2,000.00 Formula in field id=17(Row Color Field) is If([Actual Amount]>2000, "#E3F705")
Result 1: Below see the table on document with properties above.
Settings 2: Below shows same table with different properties fields' values in WEP Table record under Table Properties tab. Headers are in vertical format and different border styles and colors selected.
Result 2: Below see the table on document with properties above.
How did we do?
Totals and Total Row For Numeric Fields
Table Columns
