Make Fields Mandatory

(0) Share

Report

Posted on by AQureshi

194

I apologize if this questions has been asked and answered but I was unable to find it.

I will like to make certain fields mandatory to fill in forms. e.g. "Customer Type" or "State/Prov" in the Customer card must have a value otherwisethe form errors.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Daniele Rebussi 2,480 on at

Like
a
(0)

Report
Copy link

Link copied!

Please open the table from object designer and set NotBlank property to Yes of the fields you consider mandatory.

Was this reply helpful? Yes No
AQureshi 194 on at

Like
a
(0)

Report
Copy link

Link copied!

I guess I need a Dev license for that since I don't see the "NotBlank" property anywhere?

Was this reply helpful? Yes No
BobB 100 on at

Like
a
(0)

Report
Copy link

Link copied!

The NotBlank property is only used for fields in the primary key, and then only when they are validated through the UI. It shouldn't be used on fields that aren't part of the primary key.

Was this reply helpful? Yes No
Verified answer

BobB 100 on at

Like
a
(0)

Report
Copy link

Link copied!

The only way to do this is to put code in the OnModify trigger of the table to check that the fields in question have values. Even then, that solution could have unintended consequences.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!
User on Insert TESTFIELD(Mandatoryfield);

Was this reply helpful? Yes No