Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoYou can make a formula checkbox field called [Policy Length Valid?]
IF(Length(Trim([Policy number]))=10, true)
Then have that be on the form in a field hidden by a form rule.
Then have a form rule that says.
When the record is saved
and
[Policy Length Valid?] is not checked
Action
Abort the save with message "Sorry, but Policy numbers must be 10 digits"
I'm assuming here that the Policy # is a text field. if its a numeric field then the formula will need to be
IF(Length(ToText([Policy number]))=10, true)
If data is entered by Grid Edit or by import, then you will need to use a Custom Data Rule.
IF(not [Policy Length Valid?], "Invalid Policy Number Length")
Here is some help on Custom Data Rules https://help.quickbase.com/user-assistance/custom_data_rules.html
I find that in this case the help text is not very helpful as they leave out the most important part that says how to enable Custom Data Rules. You go to the Advanced Properties for the table and here is a checkbox at the bottom. The also don't explicitly say that the save will be blocked when the error message calculates to non blank.
I did report this to Quick Base just now and they have told me that they will update the documentation :)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
IF(Length(Trim([Policy number]))=10, true)
Then have that be on the form in a field hidden by a form rule.
Then have a form rule that says.
When the record is saved
and
[Policy Length Valid?] is not checked
Action
Abort the save with message "Sorry, but Policy numbers must be 10 digits"
I'm assuming here that the Policy # is a text field. if its a numeric field then the formula will need to be
IF(Length(ToText([Policy number]))=10, true)
If data is entered by Grid Edit or by import, then you will need to use a Custom Data Rule.
IF(not [Policy Length Valid?], "Invalid Policy Number Length")
Here is some help on Custom Data Rules https://help.quickbase.com/user-assistance/custom_data_rules.html
I find that in this case the help text is not very helpful as they leave out the most important part that says how to enable Custom Data Rules. You go to the Advanced Properties for the table and here is a checkbox at the bottom. The also don't explicitly say that the save will be blocked when the error message calculates to non blank.
I did report this to Quick Base just now and they have told me that they will update the documentation :)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
StephanieHarris
5 years agoQrew Assistant Captain
This works perfectly!
Thanks Mark!
------------------------------
Stephanie Stephanie
------------------------------
Thanks Mark!
------------------------------
Stephanie Stephanie
------------------------------