Custom Collection Field Overview

A collection is a type of field that you can add to any form in ProjectTeam.com. Collections are a powerful way to track similar data in a table-like view. 

For the collection, you can define its field label, help text, and columns. You also have the option to include extra columns such as "Row #" or "Related".

  • Row # - Checking the box to include Row # adds a read-only column to the beginning of your collection. This column starts at 1 and increments as you add new rows. 

  • Related - Under the "Include Related Item Types" label, you have three options; Attachments, Reference Links, and Action Items. You can check any combination of these boxes and they will be added as the last column of your collection. The Related column only appears on view mode when viewing your forms. Once the Related column is added, you can associated Attachments, Reference Links, and Action Items to a row. If you add a related item type to a row, it also gets added to the overall form and will be shown in the appropriate panel. 

Below is an example of what a collection looks like in view mode after checking the "Include Row #" box and checking Attachments and Reference Links boxes under "Include Related Item Types":

When adding a new custom collection to a form, you have the opportunity to define each column's properties and access.

Column Properties

For each column that you add to your collection, you can choose a type and define a label. 

If you choose a simple column type, there is nothing more to do besides defining the column label. Simple column types include:

  • Account code

  • Checkbox

  • Date

  • Email

  • Phone Number

  • Project Directory, 

  • Text (Multiline)

  • Text (Single Line)

  • URL

In addition to the simple column types, there are other types you can add that give you more properties to setup. They are listed below:

Currency
If you add a currency column to the collection, you can choose to also include a total that shows up at the bottom of the column. 

Number
If you add a number column to the collection, you can choose to also include a total that shows up at the bottom of the column. 

Picklist
If you add a picklist column to the collection, you must define the options for the picklist. Options can come from a Picklist Option Set that may already be setup, or you can define new options. 

Picklist (Cascading)
If you add a cascading picklist to the collection, you are able to define subfields and options for your subfields. Each subfield of the picklist will show up as a separate column. You can learn more about cascading picklists here.

Column Access

Each column in the collection can have its own unique access. Similar to adding any other field to your form, you can grant different types of access to Share Groups or Users. Access types include:

  • No Access: The Share Group or User does not have any access to the field. They will not be able to view or edit the field.

  • Read Only: The Share Group or User will be able to see the field but will not be able to edit the field.

  • Read/ Write: The Share Group or User will have full access meaning they can both view and edit the field.