FileMaker icon indicating copy to clipboard operation
FileMaker copied to clipboard

Primary key is required

Open atikhashmee opened this issue 5 years ago • 1 comments

Hey I am using Filemaker 17 database/server. but the problem is when I am trying to create a new record why would it ask for some field is required to put input? for example PrimaryKey Field, is not supposed to generate autometically? thanks please guide me through thishttps://prnt.sc/ublskd

atikhashmee avatar Sep 04 '20 15:09 atikhashmee

Hi, did you set the "not null" attribute in your field's definition ?

If so, you should disable that option while your field is already auto-entered.

Otherwize, the PHP-API validation process checks for every field presents on a given layout and apply all supported field's validation options, that's why the validation would fail even if its your primary key.

Another option is to create your record using a different layout which does not have your primary key, that way, there will be no validation applied to that field.

I will consider adding an option to override "not null" validation when a field has en auto-enter option activated

airmoi avatar Sep 10 '20 14:09 airmoi