How to format a form field so it has to meet X format - specifically fax number with "1"
Hi, we have a field we need users to enter the fax number with the 1 in front of it. We can't use the QuickBase phone number format because we can't have the additional characters () etc in our API. ...
Turn custom data rules on? and enable Custom Rules.
Then assuming that you have set the phone number field to to be a numeric field,
var text Fax = ToText([Fax Number]);
IF(Trim($Fax<>"") and Left($Fax,1)<>"1", "Sorry but please Enter the Fax number with a leading 1, such as 12345678900")
That will block the save in forms mode or Grid Edit mode and display the error message. It will allow a blank Fax#.
------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com markshnier2@gmail.com ------------------------------
Thanks for your help with this! Is it ok if we have this field set to number? I keep getting an error message of "expecting text but found number". Is there a way around this?
I'm not understanding where you are seeing this error message. Is it in the box where yo are entering the Custom data rule in Advanced Properties?
------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com markshnier2@gmail.com ------------------------------
