Skip to main content

How to use Default and Pre-filled Tables on Dashpivot Web

Learn how to choose between Default and Pre-filled tables when editing templates on Dashpivot Web

Adriana De Souza avatar
Written by Adriana De Souza
Updated today

Default and Pre-filled tables in Dashpivot Web templates control how table rows appear when a form is created. A Default table starts empty and requires users to add rows manually when filling out the form. A Pre-filled table contains rows that are already added at the template level, allowing users to complete or update information without adding rows themselves. These table types are selected during template editing.

Video Walkthrough

Prerequisites

Before you begin make sure you have the following:

  • Plan: Standard (or higher)

  • Permission: Org Controller or Project Controller

  • Skills Required: Dashpivot

  • Device Type: Computer

  • Subscription: Dashpivot

Step-by-Step Instructions

  1. Open the template you want to edit in the Template Editor.

  2. Drag a Table field into the template.

  3. Select the table to open the table editor.

    Default Table

  4. Select the Default table option.

  5. Add the required fields into the table columns. To keep the header visible while users enter data, hover over Field Settings and select Freeze Header Row.

  6. Hover directly through the Field Settings and click 'Freeze Header Row'.

    Note: If required, adjust the table layout using the Display on mobile option.

    Pre-filled Table

  7. Select the Pre-filled table option.

  8. Add the required fields into the table columns.

  9. Add rows to the table at the template level so they appear when the form is created.

  10. To keep reference information visible while scrolling, use Field Settings to freeze either the header row or the first row.

  11. Populate any fixed or reference data in the pre-filled rows if required.

  12. Click directly into the table field label to update it from the default value if needed.

Notes and Tips

  • Default tables require form users to add rows manually when completing a form.

  • Pre-filled tables include rows by default and guide users to complete predefined rows.

  • Pre-filled rows can be edited by form users but cannot be removed.

  • Use Pre-filled tables when a consistent set of rows is required across all forms.

  • Use Default tables when the number of rows varies between forms.

  • Freeze Header Row is available only for Default tables displayed horizontally.


Available Table Field Types

There are multiple field types available within both Default & Prefilled Tables - this specifies how the user can input the information

Type

Description

Text

Allows users to input alphanumeric characters and symbols

Prefilled Text

Text field with pre-existing content, often used for reference e.g Company Address. Allows some of the formatting options available in Prefilled Text Fields: bold text, underlined text, metrics symbols, text colour, list formatting, image upload, hyperlink

Number

Accepts numerical values only

Date

Enables input of a specific date

Time

Enables input of a specific date in hours and minutes

List

Provides a dropdown for choosing items from predefined list (see article on the different list types available for more info)

List Property

Allows list property values to be populated in a table column when a List item is selected.

Only available for default tables (see article on how to how to set up list property table cells for more info)

Signature

This field will automatically record the name, date, time & signature of the user logged into Dashpivot/Sitemate

Signature Manually

Allows users to input their first name, last name, company & signature manually

Attachment

Enables users to upload PDF documents

Photo/Video Reference

Allows users to attach photos and/or videos

Formula

Computes values based on predefined formula

To change the field type, click on the dropdown arrow (underneath the column name) to reveal the available options


Display size of photos in tables

Photo display size can be set for both Default and Pre-filled tables. Available sizes depend on the column width:

  • Small columns: XS, S

  • Medium columns: XS, S, M

  • Large columns: XS, S, M

  • Extra-large columns and above: XS, S, M, L


Adjusting column widths

Column widths can be adjusted using the dropdown at the top left of each column, with sizes ranging from XS (Extra Small) to XXXL (Extra Extra Extra Large). All column widths are compatible with all cell types except XS, which supports only Text, Number, Prefilled Text, and Formula fields. If selected column widths exceed the printable page width, an error message is displayed.


Managing rows and columns

To add, remove, or reorder columns or rows, select the … menu within the table field. For XS columns, columns can be expanded or collapsed in the Template Editor to improve visibility.


Display Size of Photos in Tables

You can set the display size of photos inside default and prefilled tables. Choose between XS, S, M, and L to ensure images are displayed at the right level of detail in your forms.

Note: There available size options depends on the column width:

  • Small columns: XS, S

  • Medium columns: XS, S, M

  • Large columns: XS, S, M


Adjusting Column Widths

Column widths can be adjusted using the dropdown at the top left of each column, with sizes ranging from XS (Extra Small) to XXXL (Extra Extra Extra Large). All column widths are compatible with all cell types except XS, which supports only Text, Number, Prefilled Text, and Formula fields. If selected column widths exceed the printable page width, an error message is displayed.


Managing rows and columns

To add, remove, or reorder columns or rows, select the … menu within the table field. For XS columns, columns can be expanded or collapsed in the Template Editor to improve visibility.

Did this answer your question?