user Upsert multiple records in sub-form repeater field.

Follow

Rakesh Burde

• December 26, 2019 09:17

Problem statement.
Ex. I have a company form and have subforms to add multiple employees. Like vice, I have the table with the relation. Like each employee have company id.

I want to save multiple employee records by upsert multiple records activities after form submission.

I don't want to use drag and drop activity to map filed with entity element. 

How can I POST all fields value to upsert multiple records after a click on form submit?

Is there any other way to do this without ( drop activity to map filed )?

Can you please share some reference links or video URL to help me out?

0

• 

  sysberry GmbH

  • December 26, 2019 09:29

  Hi Rakesh,

  The easiest way is to map fields in the form. If it is not possible by your requerements you will need to use initiate loop and next loop activities to go throw all subforms rows and add them manually to the db.

  Regards,
  Alexey

  0

  Comment actions Permalink
• 

  Rakesh Burde

  • December 26, 2019 10:54

  I understand.  Thanks for quick reply
  Could you please explain to me. Which activity should I use to manage form submit? How to handle it. and keep persisting subform post value in loop activity. 

  0

  Comment actions Permalink
• 

  sysberry GmbH

  • December 26, 2019 11:43

  Hi Rakesh,

  On submit you don't need anything to handle. All data in subforms is saved in subforms (repeating nodes in xml). Aftre the form you will need to initiate loop to loop throw subform(s). See https://documentation.agilepoint.com/00/appbuilder/cloudenvInstructionsConfigureLoop.html for configuration.

  Regards,
  Alexey

  0

  Comment actions Permalink

Please sign in to leave a comment.