Solved: Enum column type - Required is not working properl... - Page 2

John_Henry_Jose · 03-26-2019 12:51 AM

I have an Enum column type in a table which is mandatory (required).
However, the system allows users to save a record without Enum column information.
How to prevent it?
FYI : The Enum column information is coming from other table.

LeventK

Your expression have redundant paranthesises, so you better remove them as it might confuse you. I have removed them away below.

SELECT(INSPECTION TEMPLATE[Checkpoint], [Fleet Type] = [_THISROW].[Fleet Type]) - SELECT(INSPECTION CHECKLIST[Checkpoint], AND([Fleet Type] = [_THISROW].[Fleet Type], [Inspection Code] = [_THISROW].[Inspection Code], [_RowNumber] <> [_THISROW].[_RowNumber]))

Try using above expression in Suggested values property and use below expression in Valid_if
ISNOTBLANK([_THIS])

View solution in original post

Enum column type - Required is not working properly