CJ2
Nintex Observer

Add Rule Responsive Designer

Jump to solution

Need some assistance.

 

I have two fields - 'Completed' (Yes/No) and 'Date Completed' (Date and Time).

I need to add a rule if the 'Completed' field is marked Yes that the 'Date Completed' field would be required to be entered by the user. The date would not be able to be less than today.  Below is what I wrote and the form is not returning any error if I mark the 'Completed' field and do not enter a date or enter a date in the past. 

When:

Then:

Invalidate and produce the Validation Message

 

After the rule is written: I do need to have the ability to for a manager or approver to backdate the Date Completed.

0 Kudos
Reply
2 Replies
Jake
Nintex Employee
Nintex Employee

Re: Add Rule Responsive Designer

Jump to solution

Hi there,

This is actually quite a tricky one but I believe I have it working now.

There are a few things to keep in mind.

 

  1. Rules do not require an if statement unless it is nested, when you are comparing multiple values you should use and/or
  2. You will need to make sure the date value is also filled so it will require a isNullOrEmpty() check

  3. You will need a date and time to compare to, sadly there is no quick and easy way to get this so you have to build form variables to allow this.

With that in mind this is the formula I used.

 

and(equals(Completed,true),or(greaterThanOrEqual({Self},DateTimeNow),isNullOrEmpty({Self})))

 

Completed is the same variable you use

{Self} is the preferred method to refer to the control the rule is running on, similar to a this()

DateTimeNow is a construct form variable built that combines Date and Time together into a single variable, to make that, follow the steps below.

 

  1. Open the forms variables panel
    Jake_0-1627046153686.png

     

  2. Add a new variable and call it DateTimeNow str and configure as follows:
    Jake_1-1627046197002.png

    Formula used: formatDate(Current Date,'ddMMyyyy')+ formatDate(Current Time, 'HHmm;')

  3. Add another variable called DateTimeNow and configure as follows:
    Jake_2-1627046266044.png

    Formula used: date(subString(DateTimeNow str,0,2), subString(DateTimeNow str,2,2),subString(DateTimeNow str,4,4),subString(DateTimeNow str,8,2),subString(DateTimeNow str,10,2))

As you can see with the rule used I get validation error when trying to submit.

 

Jake_3-1627046463333.png

 

Kind regards

Jake

0 Kudos
Reply
CJ2
Nintex Observer

Re: Add Rule Responsive Designer

Jump to solution

Thank you so much, Jake! 

View solution in original post

0 Kudos
Reply