November 7, 200322 yr I have 2 layouts with a set of fields created, overall, for both. But one extra field is pertinent to only one of them. I never had this problem before so don't know what has triggered it. Coding needs fixing somewhere, obviously. Error I get on 2nd layout for non-existent field is: "# on page" is defined to require a value, but it is not available on this layout. Use another layout to assign a value to this field." It is unnecessary to assign data to it, via another layout or not. Field has been set to not be empty, but that condition should only apply to the layout it belongs to. What am I looking for to fix this, pls? Thanks!
November 7, 200322 yr "Field has been set to not be empty, but that condition should only apply to the layout it belongs to." No, it applies no matter what layout you're on.
November 7, 200322 yr This is a validation error. If you've defined the field to be not empty, then you'll need to place it on every layout where a new record can be created or data can be modified. If you want the validation to be specific to a layout, you'll have to specify that in the validation calculation. Remove the 'Not empty' check and specify a calculation of Case(Status(CurrentLayoutName) = "whatever", Length(fieldname), 1).
November 8, 200322 yr Author This is great! it seems to be working. I did have it misfire on a couple of tries but it seems to usually bring up the error box when I, on purpose, skip the field. I'll check it out rigourously later today to see if there really is a problem. Thanks! Looking good this end.
Create an account or sign in to comment