On one of my Nintex forms I want users to enter a series of (variable number) of event dates and other data related to those events in a repeated section. I would like to have users enter the rows in chronological order on the date field, from earliest date to the latest date. I know that normally you can just compare dates like they’re numbers and dates further in the future are treated as greater than dates less far in the future or in the past, but I’m having trouble getting the rule right so that it compares to the control element on the previous row (if present).
Like I want date(row N) > date(row N-1) for N>1
This is for Sharepoint on Prem 2019.
I have tried forcing it on the last row with a validation rule:
and(equals(currentRowNumber(dateField),rows(dateField)),lessThan((dateField),max(dateField)))
then invalidate, but it doesn’t seem to work, the rule inside only takes the field on the current row, it doesn’t look at other rows.
I have also looked at sorting it in workflow, but I want to keep the related data from the other fields connected as well and the sorting operation on Collection operations only works on one Collection at a time, you can't reorder another Collection B based on the reordering when sorting collection A, which makes the problem quite complex.
Anyone have any ideas how to do this?