fn formula required for Nintex form

  • 5 January 2018
  • 7 replies
  • 5 views
M
Badge +8

I need a formula for the expression which has the rule the column must have a date (in below format) or TBC. It is text column.

I have the formula in the image but this is not working. 

7 replies

C
Badge +16

you are setting the enabled property of the field there?  did you want validation?

M
Badge +8

Maybe Do I need to use the rules section?

I need the column to only have "TBC" or a date. No other entry should be allowed.

F
Userlevel 6
Badge +16

Use validations rules instead it.

C
Badge +16

yes you need to add a validation rule.  Something like this should do it

and(not(isDate({Self})),not(equals({Self},"TBC")))

‌‌‌‌‌‌‌‌‌‌

M
Badge +8

I can't get it to work?

When I type anything in the column it accepts it. 

I noticed that I put . instead or , in the above. Amending it to , still did the same.

F
Badge +7

I think your validation rule is close to correct.  I have noticed that from the outer layer it should always seem like only one statement, i.e.   and(or(equals(a,b),"abc"),"def") 

In your example you are excluding the last bit not(equals... with a bracket to many behind isdate({Self})))

and(not(isdate({self})),not(equals({self},"TBC")))

So maybe just a bracket to many.  Let me know if this worked.

M
Badge +8

It worked - Many thanks All.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings