Formula Fields in Cumulus

You can use Cumulus formula based fields values to automatically change the label colour of a database record based on the value of another field such as, in this case, “Copyright Status”. This greatly helps identify digital assets where the copyright has either expired or needs to be defined.

To edit the properties of the label field within Cumulus navigate to the field properties button and field values tab:

Cumulus -> Preferences -> Catalog Settings -> Record Fields -> Label -> Properties -> Field Values.

Choose “Use formula based field values” for the Field Value Mode.

Insert the following code into the Field Values Formula dialog box.

(fieldValue("Copyright Status",true)) == "Royalty Free
Stock Images" ? "4" : (fieldValue("Copyright Status"
true)) == "Commissioned Images" ? "5" : (fieldValue(
"Copyright Status", true)) == "Partner Images" ? "2"
: 1

The numerical value referenced within the formula code represents the colour that the label field will be changed to. i.e. RED = 1, GREEN = 4, BLUE = 5 and ORANGE = 2.

Set the “On Formula Error” setting.

The Copyright Status field is of type string list with three pre-defined values.

  1. Commissioned Images
  2. Partner Images
  3. Royalty Free Stock Images