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
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
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
------------------------------