Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Field formula.

Page Tree
rootFormula field - script field

The calculated field. The value of this field is the result of the formula. The value can be further processed before display.

...

Field settings include three parts.

1 - The formula for calculating the value.

This value will fall into the search index and should correspond to the selected field type.

...

Code Block
languagejs
function calc(){
	return cfValues[10011] / cfValues[10010]
}

calc()

2 - Formula for preparing data for display

Available Variables:

  • issue

  • cfValues

  • formulaValue - value of formula

...

Code Block
languagejs
function timeFormat(sec_num) {
    var hours   = Math.floor(sec_num / 3600);
    var minutes = Math.floor((sec_num - (hours * 3600)) / 60);
    var seconds = sec_num - (hours * 3600) - (minutes * 60);

    if (hours   < 10) {hours   = "0"+hours;}
    if (minutes < 10) {minutes = "0"+minutes;}
    if (seconds < 10) {seconds = "0"+seconds;}
    return hours+':'+minutes+':'+seconds;
}

timeFormat(formulaValue)

3 - Html formatting the result

if specified, then this html will be displayed as the value of the field. In the indices, this will be the value of formula 1.