Hi,
I have a product in my products table that is a discount. The User has to enter a negative number so it is deducted from the order total. We want to have a seperate entry so the customer can see the discount.
Can I specify that only negative entries are allowed?
Thanks
Phil
If you click on the pencil on the column for the discount you can scroll to the section data validity.
From here you can write an expression that says the discount must be less than or equal to 0 forcing it to be zero or a negative number.
[discount]<=0
There is also a message you can make it display, so you can say “Invalid number, discount must be a negative number or percentage”
It could look like this.
Hope this helps.
Craig
QREW Technologies
Hello,
In Data Validity:
Thank you - I’ve never looked at the Valid if bit properly before.
Phil
