How to create a custom enum (enumerated data type)
Enum (also called enumeration or enumerated type) is a data type consisting of a set of named values. For example, enum Priority can consist of the following values: Low, Normal and High.
One enum can be used as a property of several entities within the same database. For example, enum Priority can be used in such entities as: Project, Task, Appointment, etc.
To add an Enum you need to connect to the database in Configurator, right-click on database Enums, and select the Add Enum option:
Give a name to the new Enum and save the changes:
Important! If you leave the Flags checkbox empty, the new enum will allow users to select only one value, while if you check the Flags option, the new enum will allow to select several values:
Right click on the new Enum and select the Add Enum Value option:
Enter the Enum Value settings and save the changes:
Important! “Flag Enum” values should be entered the following way: 1, 2, 4, 8, 16, etc. (i.e. “2” raised to the power of “N”), while value “All” (which allows users to check all the values in the drop down list in one click) should be entered as a sum of all values, i.e. 1+2+4+8+16=31:
Hint! By default, enum values are sorted the way they were entered. If you want to arrange your enum values in a different order, you need to use the Sorting field:
When you add all of the new enum values, you need to commit the changes:
Related articles:
