Forum Discussion

JacekLewandowsk

Qrew Member

5 years ago

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...

Formulas and functions

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

If the field is required at the field properties level, then how can it be empty? Or is this just a one time cleanup of existing data?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

JacekLewandowsk
Qrew Member
5 years ago
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
  5 years ago
  My 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
  ------------------------------
  - JacekLewandowsk
    Qrew Member
    5 years ago
    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
    ------------------------------