Skip to content

Column Advanced Settings: Option List

Overview

Specify the options when displaying "Class Column" in a "Select Box". Options are specified with line breaks. In addition, the option list can be set to the "Lookup" function that transfers values ​​from a linked table, and options can be controlled using Filter, Sort, Display Format.

Limitations

  1. Cannot be used with "Status Column", "Owner Column" and "Manager Column", or "Class Column".
  2. A numerical value must be used for "Value to Save" in "Status Column".
  3. Only "User List" can be used in "Owner Column" and "Manager Column".
  4. Columns with the same "Value" will not be displayed even if they are set.

Prerequisites

  1. "Site Administration Permission" is required to configure settings.

Description Examples

Example 1

This is a description example that displays the simplest string options. It is only available for "Class Column".

Requirements Definition
Design
Construction
Testing
Release & Deployment
Initial Support
Operation

Example 2

This is an example of how to distinguish between "Value to Save" and "Display on Screen". Specify "Value to Save" and "Display on Screen" in that order, separated by a comma. If you change the "Display on Screen" string while leaving the "Value to Save" string as is, you can change the "Display on Screen" without editing the record. This example cannot be used with "Status Column", "Owner Column" and "Manager Column".

AC7459, Product A
UW9336, Product B
PX1223, Product C

If you want to include a comma (,) in the "Display on Screen", escape it with a backslash.
Up to 1\,000 yen
Up to 2\,000 yen
Up to 3\,000 yen

Example 3

In addition to Example 2, this is an example of how to specify "Short Name Displayed on Screen" and "Style Sheet Class Name". Specify them with a comma as in Example 2. "Short Name Displayed on Screen" is effective for saving the display width of the "Screen Index". "Style Sheet Class Name" allows you to apply the style of the specified class name (background color, text color, etc.). The class name must start with "status-". The original style must be set separately in "Style" of "Manage Table". This example cannot be used with "Owner Column" and "Manager Column".

100,not started,not started,status-new
150,in preparation,in preparation,status-preparation
200,Running,Running,status-inprogress
300,Under review,Under review,status-review
900,Done,Done,status-closed
910,on hold,on hold,status-rejected

Other Examples

Other options include "Department Option List", "Group Option List", "User's Option List", and "Link". You can also use Filter, Sort, Display Format. For more information, please refer to Related Information.