issue in loop activity

Follow

Rakesh Burde

• January 17, 2020 08:08

I follow the below steps to create ExampleNew App

1. I create the main form and repeatable subform in it.
2. I map the main form with the data model So it saves the record in the main table.

3. Then I use "Query Record" activity to get the last inserted ID and store it in process data variable.

4. Then I initiate a loop for subform and use insert record activity to save the record in table.

 

My loop is working correctly. But it always takes values from the first form.
For example 
My subform has a textbox labeled as "OnetoOne" I repeat it for three time and put value ie "aaaaa", "bbbbb" and "ccccc"
So It inserts one record in main table correctly.

and three records in the child table but with the wrong value. All three value entry has "aaaaa" in child table.

0

• 

  sysberry GmbH

  • January 17, 2020 09:21

  Hi Rakesh,

  can you please make a screenshot of process model, of the configuration of the Initiate Loop activity, of the data in repeated subform and of insert activity configuration. With that one could understand, where is the error.

  Regards,

  Alexey

  0

  Comment actions Permalink
• 

  Rakesh Burde

  • January 17, 2020 09:40

  

  0

  Comment actions Permalink
• 

  Loren Bratzler

  • January 20, 2020 21:34
  • Edited

  It looks like your "Insert Record" activity (in your first screen-shot) is not using the Current Row Variable that is mapped in your Loop Configuration (third screen-shot).

  Your Insert Record activity is using the field named "OneTwoOneNew" but it should be using the "OneToOne" field.

  1

  Comment actions Permalink
• 

  Rakesh Burde

  • January 21, 2020 10:07

  Thanks. It is working now.

  0

  Comment actions Permalink

Please sign in to leave a comment.