user Upsert multiple records in sub-form repeater field.

关注

Rakesh Burde

• 2019年12月26日 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

  • 2019年12月26日 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

  评论操作 固定链接
• 

  Rakesh Burde

  • 2019年12月26日 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

  评论操作 固定链接
• 

  sysberry GmbH

  • 2019年12月26日 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

  评论操作 固定链接

请先登录再写评论。