Skip to main content
Nintex Community Menu Bar
Solved

Auto populate Repeating Section based on the SQL Request

  • Sep 12, 2022 11:50 AM UTC
  • 3 replies
  • 213 views
  • Translate All

Dipeshh
Nintex Partner
Forum|alt.badge.img+2

Hi Folks,

I have a form with a repeating section and I want the user to select the chosen value from the selecting field. The selecting choose value comes from the SQL Request. Once the user selects a Transaction Limit the repeating section populates and adds two other Rows in the Repeating Section. I am using JavaScript to auto-populate the rows and values in the field. 

 

I have attached the photo of the Repeating Section table below:

  • My question is if I select the field in Application Name i.e. field value "Transaction Limit".
  • JS code auto-populate and add two other new rows with Application Name "Transaction Limit" and in "Role Type" two another value is shown with the help of JS.

26083i2C776C706FCFFE55.png

 

 

 

My JS code looks like this...

 

  function addRowToMySection() {

   NWF$(".classRptSection.nf-repeater-row:last.classText").val('ABC');

   alert("done");

   };

  1. a repeating section, with CSS class = classRptSection
  2. a text box inside the repeating section, CSS class = classText
 

Calling on some past Nintex Heroes to see if they can respond!  @MegaJerk, @nico, @TomaszPoszytek, @cassymfreeman, @SimonMuntz, @mlauer

Any assistance with this would be greatly appreciated!

 

Thanks and Kind Regards,

Dipesh

 

Best answer by bamaeric

Check out this blog post: How To: Populate Repeating Section with SQL Data 

View original

3 replies

bamaeric
Nintex Partner
Forum|alt.badge.img+15
  • Nintex Partner
  • Answer
  • Sep 12, 2022 2:11 PM UTC

Check out this blog post: How To: Populate Repeating Section with SQL Data 

Translate

Dipeshh
Nintex Partner
Forum|alt.badge.img+2
  • Author
  • Nintex Partner
  • Sep 13, 2022 11:54 AM UTC

@bamaeric Thank you for this article. 

Translate

Dipeshh
Nintex Partner
Forum|alt.badge.img+2
  • Author
  • Nintex Partner
  • Sep 16, 2022 9:51 AM UTC

Hi @bamaeric 

In the article, you have shared. I have tried every step in the form, but the data auto-populates by clicking a button.

  • My logic is auto-add a repeating section by selecting the value i.e.; Finacle from the drop-down list.
  • And show the value parameters in another side field also.
  • There must add 3 more repeating section rows in the panel.

 

Please see the design below for what I need.

 

 

Translate