Calculated task fields
A calculated field is a custom task fields that lets you calculate a value you need, 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:
"
"></a>;
You can also choose the format in which the value of the calculated field will be stored:
<a href="
"></a>;
Formula Calculation — "String" Result
- Output data from variables to the field:
+
<a href="
"></a>;
- Output text and data from variable to the field:
"Task Name:"+" "+{{Task.Parent task.Name}}
<a href="
"></a>;
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
<a href="
"></a>;
As the result, we get the concatenation of "Sum: ", "50" and "70":
<a href="
"></a>;
And if you add brackets — the numbers are summed:
string + (number + number) = string + sum of numbers = string
<a href="
"></a>;
<a href="
"></a>;
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
<a href="
"></a>;
<a href="
"></a>;
Example № 2
<a href="
"></a>;
<a href="
"></a>;
Important
- Calculated fields are calculated when a task is created or modified. 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.
- Calculated fields are not calculated in tasks with the status Draft. 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 automatic 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 package 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 a string.
Useful links
- [<a href="https://planfix.com/ru/blog/vychislyaemye-polya-zadach/">https://planfix.com/ru/blog/vychislyaemye-polya-zadach/</a>; Note about computed task fields in the Planfix blog]
- Text with Variables