Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoYou could go to the Advanced settings for the table and
Build custom data rules for this table:
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Build custom data rules for this table:
Learn more about using custom data rules here
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#.
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
------------------------------
StephanieMalang
6 years agoQrew Member
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?
------------------------------
Stephanie Malanga
------------------------------
Thanks!
Steph
------------------------------
Stephanie Malanga
------------------------------