Solved

Nintex Forms Designer - Date validation in repeating table


Badge +1

Hi, the purpose is to have the possibility to add dates rows in a repeating table. Each date can`t be more then 365 days from current date. I should include the function currentRowNumber in the formula. But i dont know how.

 

This is, what i already have:

17731i4157E31B3507999B.png

I can add date to repeating table. In the first colummn is a calculated value of days, second colummn is the number of row.

 

Now, i need to add a Validation Rule. If the value(dayscount) in concrete row is greather then 365, show an error message. My problem is, i don`t know how to write down the condicion/formula into the rule. Also i don`t known if I have to add the rule to the repeating table or to date/time form control.

Can somebody help me please?

Thanks

DJ

icon

Best answer by kunalpatel 18 May 2021, 08:44

View original

3 replies

Badge +12

@DusanJ  apply below steps:


 



  • Add always hidden calculated control in your repeating section, name it "calc_ctrl_datediff" and add below formula:

    • dateDiffDays(dt_ctrl_date, Current Date) 


      • dt_ctrl_date ----> is the name of your date control in your repeating section



    • Apply a validation rule on dt_ctrl_date:

      • greaterThan(calc_ctrl_datediff, '365')



    • You DO NOT need row count for this




 

Badge +1
Thanks very much. I will try it and give feedback.
Badge +1
Thanks, it works.)

Reply