AnsweredAssumed Answered

Field Validation doesn't work

Question asked by ClickWorks on Aug 21, 2012
Latest reply on May 21, 2014 by lordhellfire

Summary

Field Validation doesn't work

Product

FileMaker Pro

Version

12v2

Operating system version

Mac OS 10.7.4

Description of the issue

Field validation warning shows ' is defined to require a value, but it is not available on this layout…' while the field is well present on the active layout.
I can reproduce this issue, but only under the following conditions: 1) separation of data and interface file 2) 'Allow Override' must be turned ON.

Steps to reproduce the problem

Set field validation to 'ot Empty' or any other validation.
Leave the option 'Allow User to override…' ON
(optional) specify a custom message.
From another file, create a file reference to the databse.
Create a layout based on the external table and add the field to the layout.
Create a record and violate the validation rule.

Expected result

I expect to see my custom message or the default validation message. I expect not to be able to commit the record unless I confirm to override the validation.

Actual result

The message ' is defined to require a value, but it is not available on this layout…' while my field is present. I am able to commit the record without being asked to override the validation.

Exact text of any error message(s) that appear

is defined to require a value, but it is not available on this layout…

Workaround

Turning the option 'Allow Users to override…' OFF solves the problem.

Screen_Shot_2012-08-21_at_17.52.31.png

Outcomes