cancel
Showing results for 
Search instead for 
Did you mean: 
TrishW
Occasional Member - Level 3

Audit Rule - user must enter a value between eg 1000 to 9999 for a certainfield

Hi everyone

 

Looking for assistance - has anyone been able to use a function like between in the audit rules ( I know that between is not available)

 

I am looking for a way that if a user enters a value in a certain field

Then they must enter a value between 2 numbers for another field

 

Eg Field A value entered is CC

then field B must contain a number between 1000 and 9999

 

Any assistance greatly appreciated

1 Solution
Solution
PoojaKumatkar
Frequent Member - Level 2

Hi @TrishW ,

 

Can you please close this post as well since you have already accepted solution given in your below post in Admin Group.

 

Solved: Re: Audit Rule - user must enter a value between e... - SAP Concur Community

 

 

Thanks!
Regards,
Pooja

View solution in original post

3 REPLIES 3
PoojaKumatkar
Frequent Member - Level 2

Hi @TrishW ,

You can try writing conditions as below:

 

If field A = CC (if field A is list then select CC value from list, if it is text them type proper exact text value)

And 

(

Field B is less than 1000

Or

Field B is greater than 9999

)

 

 

Error - Field B value must be between 1000 and 9999

 

It should work. Let me know the results.

 

 

If this answers your query, then please mark solution as accepted.

Thanks!
Regards,
Pooja
Solution
PoojaKumatkar
Frequent Member - Level 2

Hi @TrishW ,

 

Can you please close this post as well since you have already accepted solution given in your below post in Admin Group.

 

Solved: Re: Audit Rule - user must enter a value between e... - SAP Concur Community

 

 

Thanks!
Regards,
Pooja
TrishW
Occasional Member - Level 3

Thankyou