Re: Data validation in a table based on column and row data input

Home Forum Behaviors Data validation in a table based on column and row data input Re: Data validation in a table based on column and row data input

#6047

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).

Workflow software, Process software, Procedure software