I have a problem where users can circumvent data validation rules using certain tricks explained below. How do i restrict users from doing so.
I have a form where the user selects and item from a referenced dropdown and inputs the quantity. Only for a particular item can the quantity be greater than 1. For all other items, the quantity can only be one.
I have set the validation rule as such:
not(and(if([_Thisrow].[Item]<>"Apple",True,False),[Quantity]>1))
This validation fails when the user performs actions in this sequence:
Solved! Go to Solution.
You may want to elaborate which column you are using this validation expression.
In general, based on understanding of your requirement, you could try the below expression in the valid_if of the [Quantity] column
IF([Item]="Apple", [_THIS]>=1, [_THIS]=1)
Here it is assumed that only item "Apple" can have quantity greater than zero.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |