In order to validate content that users enter into data cards, I would like to define some variables as Mandatory Values. If you try to set them to mandatory and there are already blank values, you get a message like this...
I had our IT DBA run a SQL update to place a non-blank value in any existing variables on my list that it finds with a blank value. The query is like this...
SET ValueText='not specified', ValueCache='not specified'
WHERE (VariableID=130 or VariableID=132 or VariableID=143 or VariableID=146)
AND (CAST(ValueText AS nvarchar(max)) IS NULL) OR (CAST(ValueText AS nvarchar(max))=' ')
This was effective for some variables but not for others. I am wondering if anyone has been successful setting the Mandatory constraint after blank values have been added? Can you think of what I may be missing here?
I saw a post with a suggestion to set the minimum text length to 1, but that is only available for Edit Boxes, not for ComboBoxes or Dates.