- 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 #6025
I think I found my solution. Thanks.March 29, 2012 at 1:45 pm #6045
i 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 #6047
Dennis @ PerfectFormsBlocked
The 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 #6048
This worked perfectly. Thanks for your help
You must be logged in to reply to this topic.