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 - Rich Text field with formula (finally the formula is longer but I shortened it to check the IsNull function):
var text assignmentEndDate = If(IsNull([Assignment End Date (DD-MM-YYYY)]),"Is NULL","Not NULL");
var text assignmentEndDate = If(IsNull([Assignment End Date (DD-MM-YYYY)]),"Is NULL","Not NULL");$assignmentEndDate
On the form, I can delete data from the field, or still not complete it when adding a new record.
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.
Thank you for your answer.So this is another bug workaround. It allows you to keep the fields required at the level of its properties, but it forces adding "unnecessary" fields to the entire table.
Do you know if and when this bug will be fixed in QB?