QuickBase Scripting & Data Field Validation
I understand that there is ability to use ... is it Javascript? ...scripting in QBase to accomplish things that are not straight out of the UI. First question, is this Javascript or something els...
Forum Discussion
An example of a formula is a formula field called Valid? of type formula checkbox
IF([entry field] >=91.5 and [entry field] <= 94.8,true, false)
which is equialent to
IF([entry field] >=91.5 and [entry field] <= 94.8,true)
which is also equivalent to
[entry field] >=91.5 and [entry field] <= 94.8
ie with a boolean you can make a statement and the system either says its true or called Bullshit on you and says its false.
IF([entry field] >=91.5 and [entry field] <= 94.8,true, false)
which is equialent to
IF([entry field] >=91.5 and [entry field] <= 94.8,true)
which is also equivalent to
[entry field] >=91.5 and [entry field] <= 94.8
ie with a boolean you can make a statement and the system either says its true or called Bullshit on you and says its false.