cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
michuk
Nintex Newbie

fn formula required for Nintex form

Jump to solution

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. 

Reply
7 Replies
Automation Master
Automation Master

Re: fn required for nintext form

Jump to solution

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

0 Kudos
Reply
michuk
Nintex Newbie

Re: fn required for nintext form

Jump to solution

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.

0 Kudos
Reply
fhunth
Nintex Newbie

Re: fn formula required for Nintex form

Jump to solution

Use validations rules instead it.

Reply
Automation Master
Automation Master

Re: fn required for nintext form

Jump to solution

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

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

Reply
michuk
Nintex Newbie

Re: fn formula required for Nintex form

Jump to solution

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.

0 Kudos
Reply
fccrous
Nintex Newbie

Re: fn formula required for Nintex form

Jump to solution

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.

Reply
michuk
Nintex Newbie

Re: fn formula required for Nintex form

Jump to solution

It worked - Many thanks All.

0 Kudos
Reply