New field type: Boolean
M
Michael Jarvis
(*NOTE: It's possible this feature may have already been suggested, though I have not been able to find another example.)
My vision is that this field could be set manually (as "TRUE" or "FALSE") or set automatically by simple comparisons to other fields (e.g. <, ≤, =, ≥, >, ≠). The Boolean field should be able to compare Number, Money, and Dropdown Fields, but having the ability to compare ANY two fields might be useful as well.
This field may need an option to update automatically when a task is modified/updated.
---
For example:
Custom Field (Money) "Total Budget" = 100.00
Custom Field (Money) "Expenditures Running Total" = 70.75
NEW Custom Field (Boolean) "Over Budget?" = "Expenditures Running Total" > "Total Budget"
In this case, the "Over Budget?" Field would be set to "FALSE" as the Expenditures value would be less than the total budget value.
---
*I understand that you can produce some true/false values using the "Formulas" field using the advanced editor. HOWEVER, you cannot compare all types of fields via Formulas (see attached screenshot comparing two Dropdown fields).
The Boolean field would be specifically for simple comparisons between specific fields and a True/False set value. Ideally, you could select fields of the same type in two separate dropdowns—selecting the "Operator" (e.g. <, ≤, =, ≥, >, ≠) to use between them.
Possible solution:
The "Checkbox" Field is technically a Boolean value of True/False. If you add the ability to use the aforementioned logic on this field, this functionality could be implemented without creating a new field (see attached screenshot).
Log In