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

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
Super User
Super User

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

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