User Tools

Site Tools


fields

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
fields [2018/02/22 22:03]
sroehling [Calculated Fields]
fields [2018/02/24 00:52] (current)
sroehling
Line 25: Line 25:
  
 There are also calculated fields, which automatically calculate their values from other fields'​ values. The values for calculated fields are determined from the calculated field'​s [[formulas|formula]]. There are also calculated fields, which automatically calculate their values from other fields'​ values. The values for calculated fields are determined from the calculated field'​s [[formulas|formula]].
 +
 +===== Undefined Values =====
 +
 +Before a field'​s value has been set in a [[forms|form]] or [[table-views|table views]], its value is considered "​undefined"​.
 +
 +Calculated fields which reference other fields with undefined values may in turn result in an undefined value. However, functions such as ISTRUE() can be used to test for an undefined value inside a formula.
 +
 +In [[forms]], there is also the capability to clear an existing field value, making it undefined again. For trackers, clearing a value takes on a special meaning. For example, if a project task includes a "​target completion date" field, explicitly clearing this field'​s value could mean the task initially had a specific completion date, but a completion date is no longer known.
fields.txt ยท Last modified: 2018/02/24 00:52 by sroehling