IsNull doesn't work with the required fields
Hi, I have a problem with the "IsNull" function and the date field. My date field "Assignment End Date (DD-MM-YYYY)" is required and of course it is visible on the form. I also have a formula - Ri...
Forum Discussion
On the form, I can delete data from the field, or still not complete it when adding a new record.
------------------------------
Jacek Lewandowski
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendMy point is that if you make the field required at the field level, then the form will prevent the record from being saved if the date is blank. So you really do not need that rich text message field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
It's not answer for my question.
As I wrote in the first post, this is just a fragment of the formula. I do not use this field to inform the user that he has an empty required field, because it is a basic QB functionality and there is no point in duplicating it.
I use this calculated field to create JSON which is later used in js which is loaded into the form. Therefore, it needs that if the required field is not completed, the IsNull function will work and I will be able to write to JSON that this field is empty. At the moment, QB is generating an error and does not display the calculated field at all.
------------------------------
Jacek Lewandowski
------------------------------- MarkShnier__YouStrange,
I did a test using this formula
var text RequiredMessage = If(not IsNull([required date]), "OK", "Missing");
$RequiredMessage
and it said "Missing" when the required field for [required date] was blank. So I cannot duplicate your issue.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- This error occurs when you first fill in the date field and then delete the value from that field.
------------------------------
Jacek Lewandowski
------------------------------