Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Great, glad it's working.
Just a tip. The IsNull will NOT work to check if a text field is blank.
To check for that use those
If(Trim([My text field])="", "missing text field")
The IsNull is documented to not work on text fields and that is not intuitive and will make you crazy trying to debug a formula if you don't understand that.
Just a tip. The IsNull will NOT work to check if a text field is blank.
To check for that use those
If(Trim([My text field])="", "missing text field")
The IsNull is documented to not work on text fields and that is not intuitive and will make you crazy trying to debug a formula if you don't understand that.