DusanJ
Design Dabbler

Nintex Forms Designer - Date validation in repeating table

Jump to solution

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:

DusanJ_0-1620824875361.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

Labels: (1)
0 Kudos
Reply
3 Replies
kunalpatel
Automation Master
Automation Master

Re: Nintex Forms Designer - Date validation in repeating table

Jump to solution

@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

 

View solution in original post

0 Kudos
Reply
DusanJ
Design Dabbler

Re: Nintex Forms Designer - Date validation in repeating table

Jump to solution
Thanks very much. I will try it and give feedback.
0 Kudos
Reply
DusanJ
Design Dabbler

Re: Nintex Forms Designer - Date validation in repeating table

Jump to solution
Thanks, it works.)
0 Kudos
Reply