Set Required Fields
A column property can set whether a field is required.
Records containing fields that are Hard Required cannot be saved until the field is populated. Records with Soft Required fields can be saved but are not considered valid until the designated field is populated.
Applying the Soft Required column property automatically creates a view in SQL. DSP® then registers the view as a Validation Rule to the page and creates a default message that displays to the end user.
This feature is available for these control types:
- Combo Box
- HTML Area
- Text Box
- DateTime
- Numeric
- List Box
- Text Area
Any field in a table that does not allow NULLS automatically displays as a Hard Required field in DSP®. In many cases it will be the Primary Key field. For example, the Order Detail page displays the Product ID field as required because it is a Primary Key, the Quantity fields and Discount fields are not automatically required because the table requirement allows NULLS.
To make a field required:
-
Access the Page Columns page’s Vertical View for the field.
-
Click Edit.
-
Select Yes (hard) or Yes (soft) from the Required list box.
-
Click Save.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.