Unique Repeater Values

Hi Ben,

Do you just need to number the rows? If that's it you can use a calculated value control in your repeating section and use formula currentRowNumber. See the attached link with Manfred Lauer's comment at the bottom of the page, Nintex Forms - Numbering a Repeating Section - Vadim Tabakman

Jan

Hi Ben.

You should be able to use jquery to achieve this.

-assign a css class for the repeater control

- assign a css class for the control that needs to have unique value in the repeater control

-in your jquery code, On Repeater control change loop through the values already entered in the control and ensure they are all unique

if one value is duplicated then disable the submit button and have a onscreen error or show a error label.

Thomas

Hi Ben.

See below for my quick proof of concept.

Nintex Form Settings:

Hey Thomas,

I'm trying to use array.length() in one of my forms, but keep getting the error that items.length is not a valid function. I'm sure I'm missing something simple, perhaps you can assist? The relevant code looks like this:

var options = [];
function showMe() {
{
var items = NWF$('#' + multiChoices + ' :checkbox:checked');
console.log(items);
var count = items.length();

for (i = 0; i < count; i++)
{
     var currentValue = items[i];
     console.log(currentValue);

     if (currentValue.endsWith(0))
     {
     options.push(1);
     }
     else if (currentValue.endsWith(1))
     {
     options.push(2);
     }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I was doing like your example and just having for (i=0; i < items.length(); i++) and only declared the count variable to see if that helped anything. I'm in O365 if that makes a difference.

I have a question going here   and Aaron has been helping, but I didn't know if you could assist on the .length() not working.

I have responded to your original question ‌

Yeah, as ‌ mentioned, .length is what you need is you want to check the length of an array. 

Yep, I realized that shortly after I asked the question. Thank you! This is my first Javascript adventure, so I was figuring it was something silly and then I finally found it. Thanks for the help on my original question, Thomas!

Hi shaker alzo3bi‌

In your case you need to adjust the code where it gets the existing repeated choice control values as they are rendered a bit differently from text controls.

You need to loop through your choice control values and add the radio button values that are selected. 

I am assuming you have assigned the cssclass myBudget to your SQL request choice control within your repeating section. 

Code Snippets below should do the trick.

NWF$(document).ready(function()
{
  //event will be fired every time the new repeater textbox value is entered
  NWF$(".myBudget input").change(function() {
       EnsureUniqueValue()
     });
});




function EnsureUniqueValue()
{
  var duplicateValueFound=false;
  var rpArray= NWF$(".myBudget input")
  var rpArrayValues=[]

//Push all non-empty values from repeating section to another array
  for (var i = 0; i < rpArray.length; i++)
  {
  if(rpArray[i].checked ==true)
  {
  rpArrayValues.push(rpArray[i].value)

  }
  }
  
  
  //remaining code should remain as is
  
  ....
  
  ....
  
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hishaker alzo3bi‌. 

Please kindly mark my answer as helpful it they are  

You can modify the following part of my original code to delete the duplicate row. You may want to modify the popup message so that user knows the duplicate row will be deleted automatically.

You need to add a cssclass to your repeating section , i have used .rpSection in my example below. And then replace the cssclass name in the code below with yours.

if(duplicateValueFound)
  {
  //NWF$(".nf-repeater-addrow").hide()
var indexToDelete=NWF$(".rpSection .nf-repeater-deleterow-image").length-1 
NWF$(".rpSection .nf-repeater-deleterow-image")[indexToDelete].click()
  }
  else
  {
  NWF$(".nf-repeater-addrow").show()
  }‍‍‍‍‍‍‍‍‍‍

hi Thomas Xu as long as only two rows will be duplicated only out of n.. rows, then

if you know how to disable the (submit & save) action, on the form level, then this will be a great workaround, rather than the deleting the duplicated row.

Yeah ,

NWF$(".yourSubmitButtonCssClassName").hide()

From memory there should be a property on the button setting itself that lets you conditionally show/hide the image button on the ribbon.

I don't have access to a computer at the moment to verify which property it is.

BTW, is there a well known NWF$ scripting reference that can be used to to know all methods events,... for Nintex forms and controls.

I have a similar validation request. In my case I have a list lookup control in a repeating section and my goal is to make sure that only one time it was selected. But I cannot find a way how to pull selected value of the control. I try to use NWF$(".FieldCss").options.selectedIndex);. Did anyone had this issue? How you got selected values of the lookup

Thomas Xu‌ 
Thank you for any help in advance!