Automatically generating edit messages
quickbase seems to be generating validation messages based on the dynamic rules created as part of a form. Since my field names are designed for understand the table layout, they usually do not make f...
Forum Discussion
Well actually there is a Plan B if "the juice is worth the squeeze".
You can make any kind of crazy formula you like with any name you like to replicate the compound conditions of the form rule. The have the form rule work off that one field. Then you can control the message to a large extent. I suggest that you put the calculated field on the form to be sure that the form evaluates the formula in real time during data entry.
The field does not have to show on the form, it can be in a section or field hidden by a form rule. Like when customer name is not equal to 99999 hide ....
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
You can make any kind of crazy formula you like with any name you like to replicate the compound conditions of the form rule. The have the form rule work off that one field. Then you can control the message to a large extent. I suggest that you put the calculated field on the form to be sure that the form evaluates the formula in real time during data entry.
The field does not have to show on the form, it can be in a section or field hidden by a form rule. Like when customer name is not equal to 99999 hide ....
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
That's a very creative solution. I'll try it. Thanks.
------------------------------
Lee Baughman
------------------------------
------------------------------
Lee Baughman
------------------------------
