Validating dates between rows in a repeating section

Applies to Infiniti v9.2 or later
 

With Infiniti you can easily gather complex information chronologically. This handy feature could be applied to create travel itineraries, leave requests, to create schedules, employment or residence history forms - just to name a few possibilities!

It’s achieved by creating a repeating section where each section contains a start and end date question, together with any other questions relevant to your business process.  When the user adds additional questions Infiniti will automatically calculate the defaults and ensure the specified dates are in order and if necessary ensure that there are no gaps.

It’s simple - just reference a question in the previous row of a repeater!  

Here’s an example   

Here is a basic project where we use the [previous] function to calculate and validate values based other rows in a repeating section.

The label ‘Segment Start’ has the following formula.

This checks to see if the current row is the first row or not. If it is the first row the label’s value could be today’s date or another date relevant to your process. In the above example an overall start date was specified on the previous page. For subsequent rows the label will resolve to its previous row’s Segment End + 1 Day question.

Below is the formula in Segment End + 1 day. The formula takes the date for Segment End and adds an additional day. This is done to ensure that there are no overlapping days when it comes to validation.

Be sure to add any possible validations to all your date questions to help your user where you can. For example ensure all days are in the future.

Additionally in the above example we validate the last segment end to ensure it matches a value collected earlier in the form using the formula below. This variable will check to see if End Date is equal to the Segment End of the final row. If this is true it will return with a value of 1. If not it will return with a value of 0.

Related Articles

 

How to reference a question in the previous row of a repeater

Date validation

Repeating Sections

 

Keywords

 

Matching Dates fer Repeating formulae Section Itinerary Schedule Plan Start End Date Last Row Previous Validation Consecutive adddate