Tagged: Table, validation
This topic contains 4 replies, has 0 voices, and was last updated by 
- AuthorPosts
- March 1, 2012 at 7:54 pm #966
I would like to know how to implement validation logic to enforce data input in a table? The requirement is, if the data input from Column A (selecting from a predefined drop-down list) contains “*”, then Column C for the same row is required and cannot be blank. If the selected entry for Column A does not contain “*”, then there is no restriction on Column C of the same row.
Thank you.
March 1, 2012 at 10:16 pm #6025I think I found my solution. Thanks.
March 29, 2012 at 1:45 pm #6045i wouldnt mind an answer to this myself. i am trying to do the same thing, but when a row meets the criteria for makin a colum mandatory, all of the colums become mandatory in the table regardless if the row meets the criteria for this or not.. is there a way around this?
March 29, 2012 at 4:12 pm #6047The trick is building a behavior that loops through your table and at each row checks column A. If column A (current row) = not empty AND Column C (current row) = empty then use a Show Message object (Something like if column A has a value, column C cannot be left empty).
Here is how:
Set Table Rows (move to first row). Simple Branch (is column A current row not empty AND is Column C current row empty?). If True Show Message, if False go to another Set Table Rows object (move to next row). Then another Simple Branch object (was last command successful?). If True loop back to first Simple Branch, if False go to an Exit behavior object (you have reached the bottom of the table).
March 30, 2012 at 2:52 pm #6048This worked perfectly. Thanks for your help
- AuthorPosts
You must be logged in to reply to this topic.