Hi All

I have a few fields in my record and I would like to go through the value of each field in the current record that I am submitting. The intention is to create a new record in other form if it detects a certain value.

Something like:

Field1: okay

Field2: require attention

Field3: okay

Field4: require attention

For each field, if value is "require attention", add a new record in other form that contain the field value and the record ID.

Hope someone can help me out.

Thanks in advance