Calculated task fields

From Planfix
Revision as of 13:16, 11 December 2024 by Dmitri (talk | contribs) (→‎Useful links)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

A calculated field is a custom task fields that lets you calculate a value, using data from various Planfix objects and standard Planfix functions.

Formula Calculation — "Number" Result

The fundamental aspect of the calculated field is determined by the formula used to calculate its value:

Oqca8q.jpg

You can also choose the format in which the value of the calculated field will be stored:

KKBp05.jpg

Formula Calculation — "String" Result

  • Output data from variables to the field:
{{variable_1}}+{{variable_2}}

6C0Me2.jpg

  • Output text and data from variable to the field:
"Task Name:"+" "+{{Task.Name}}

Vfya7g.jpg

Please note that text and spaces must be enclosed in double quotes.

  • Round brackets in calculates field with "String" result type:

A simple rule applies:

string + number + number = string

B2P3HN.jpg

As the result, we get the concatenation of "Sum: ", "50" and "70":

NjT2kw.jpg

And if you add brackets — the numbers are summed:

string + (number + number) = string + sum of numbers = string

6hMkLl.jpg

PH1157.jpg

Calculated field with a "Text with variables" result type.

Text with variables has the following capabilities:

  • You can immediately get an idea of how the field will roughly look.
  • The values will replace the variables.
  • You can apply formatting from the built-in editor:
    • Change appearance
    • Display on a new line.
    • Add a table, link or Planfix object using the corresponding editor buttons.

Example № 1

qBPwjI.jpg


ciLw1Z.jpg

Example № 2

RQmLtk.jpg

7RPJ0Y.jpg

Important

  • The value of the calculated field is calculated when a task is created. The value of the calculated task field is only recalculated if the values of the fields of this task, which are contained in the formula by which the field is calculated, are changed.
  • In tasks with a draft status, calculated fields are not calculated. The values are calculated when the task is changed to one of the working statuses.
  • Formulas for calculated fields can contain values from other calculated fields.
  • If a reference to the current time or date is used in the formula, changing the field containing the formula does not trigger the execution of scripts. This limitation is part of the mechanism to protect against looping and unlimited load.
  • The maximum number of calculated fields that can be added to the account is limited by the plan you are using.
  • If you are using HTML markup, remember:
    • If you need double quotes — use the SYMBOL function." = SYMBOL(34).
    • Using line breaks within quote strings is not supported — enter the data in one string.

Useful links

Tip

  • If you rename a field, update the new name in the variable; otherwise the variable with the old name will not work in the calculated field.


Go To