Formula assistance
This works... If(ToText([Job - Related Sub Payroll22 - 2nd COAT (DAY 1) DATE])<ToText(Today()), "<img src=\"https://images.quickbase.com/si/24/221-point_red.png\" title=\"DONE\">", "<img src=\"http...
Forum Discussion
Worked perfectly.
I thought I needed to convert date field to TEXT because field type is RICH TEXT FORMULA? Evidently not. Thx
------------------------------
BuildPro
------------------------------
I thought I needed to convert date field to TEXT because field type is RICH TEXT FORMULA? Evidently not. Thx
------------------------------
BuildPro
------------------------------
Actually I am surprised it worked, it should be
var date PayrollField = .... (instead of var text)
The type of field only determines what the final OUTPUT of the formula is. Meaning, in this case the outcome is a picture/text of 'Alert', 'Done', etc. So your outcome is rich text, so that works.
You can test and manipulate anything you want (dates, numbers, etc) as long as the final OUTPUT is text
------------------------------
Mike Tamoush
------------------------------
var date PayrollField = .... (instead of var text)
The type of field only determines what the final OUTPUT of the formula is. Meaning, in this case the outcome is a picture/text of 'Alert', 'Done', etc. So your outcome is rich text, so that works.
You can test and manipulate anything you want (dates, numbers, etc) as long as the final OUTPUT is text
------------------------------
Mike Tamoush
------------------------------