Column Types and their Settings

Last updated May 18, 2022
Written by Princess Luzadas

You can configure the settings of a column either you created a template of your own or used a standard or a client specific template.


Column TypeDescriptionUsed CasesColumn Setting
Short TextCaptures small amount of information
  • Has a limit of characters and is returned in a single line
  • Alphanumeric characters
  • Default column width is M.
  • Text is left aligned.
Long Text
Captures more amount of information
  • Comments
  • Descriptions
  • No limit of characters and wraps around according to the length of the text
  • Alphanumeric characters
  • Default column width is M.
  • Text is left aligned.
Single Select
Allows you to create a dropdown list of options and select only one option at a time
  • Contract Type
  • Risk Profile
  • Has an Add Option and can be deleted
  • No limit of the number of options that can be added
  • Default column width is M.
Multi Select
Allows you to create a dropdown list of options and select multiple options at the same time
  • Region
  • Has an Add Option and can be deleted
  • No limit of the number of options that can be added
  • Default column width is M.
Date
Allows you to select the date and has an option to add into the weekly digest 
  • Date format is dd/mm/yyy.
  • Include this date in weekly digests - This allows you to receive a summary of packages and dates that are coming up for the week and is generated every Monday.
  • Default column width is M.
Number
Captures numbers
  • Allow decimals - This will show the numbers in decimal
  • Show as percentage - This will show the numbers in percentage
  • Show column SUM - This will show the sum of the numbers in the column located at the package group title.
  • Default Value - This allows you to set a standard interval between key dates and it is automatically populated based on the value you have set. Only applies to new packages.
  • Default column width is M.
  • Number is right aligned.
Currency
Allows you to enter a symbol which will be displayed next to the numerical value

This is not tied to project currency.

  • Symbol - Enter the symbol in this text box and it will show up in the table as default. Default symbol is $ but this can be updated.
  • Allow decimals - This will show the numbers in decimal
  • Show column SUM - This will show the sum of the numbers in the column located at the package group title.
  • Default column width is M.
  • Currency is right aligned.
Calculation
Allows you to calculate between two columns

Certain columns allow certain calculations.

  • First Column and Second Column - These are the columns to be calculated which should be preselected first before the Operator.
  • Operator - Select the required operator to perform the calculation between the columns. Default symbol is + but this can be updated. 
  • Display as comparison - Positive value will be in green and negative value will be in red.
  • Show column SUM - This will show the sum of the numbers in the column located at the package group title.
  • Default column width is M.
  • Calculation is right aligned.
Category
Allows you to add categories enabled for your organisation to a package
  • Default column width is M.
Package Group
Allows you to switch packages between package groups
  • Required column
  • Default column width is M.
Package Status
Describes the status of a package

There is a standard status used but can be configured.

  • Required column
  • You cannot change the status of a package if required columns are not populated.
  • Default column width is M.
Package Owner
Allows you to select a user as the owner of the package
  • Notify user when added to a package - The user will be notified via email.
  • Send weekly digest - The user will receive a summary of packages and dates that are coming up for the week and is generated every Monday. 
  • Default column width is M.
RFQ
Allows you to add RFQs
  • This is a hyperlink to the RFQ.
  • Default column width is M.
RFA

Allows you to recommend vendor for award

This is an internal approval process which includes the basic information of the package and the value of the award to be approved by managers before the contract is executed.

  • This is a hyperlink to the RFA.
  • Default column width is M.
User
Allows you to select one or multiple users and assign tasks

This is a list of users in the organisation.

  • Notify user when added to a package - The user will be notified via email.
  • Send weekly digest - The user will receive a summary of packages and dates that are coming up for the week and is generated every Monday.
  • User is Single Select. To add multiple users, add multiple columns.
  • Default column width is M.
Vendor
Allows you to select a vendor
  • Default column width is M.
Contract
This is a list of contracts.
  • Default column width is M.
LookupAllows you to pull information from an object based on a certain field
  • Entity Column - This is the object where you would need the information.
  • Field - This is where the information is pulled.
  • Default column width is M.


Was this article helpful?