Apex Code Development You need to sign in to do that
Don't have an account?
charchit nirayanwal How to make validation use a coupon single time by individual customer
For this we need to use trigger :
trigger checkalready on "order object" (before insert) {
order object a=trigger.new[0];
integer d=[select count() from "order object" where "Customer field" = :a."customer field" and "coupon field"=:a."coupon field"];
if(d>0){
a.addError('Coupons already used');
}
}
If anyone have any other answer without using trigger then must post
trigger checkalready on "order object" (before insert) {
order object a=trigger.new[0];
integer d=[select count() from "order object" where "Customer field" = :a."customer field" and "coupon field"=:a."coupon field"];
if(d>0){
a.addError('Coupons already used');
}
}
If anyone have any other answer without using trigger then must post
Not possible wihout trigger.
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh
We can give prime number to every coupon and when user use that coupon update the inner field of customer multiply by that prime number.
When customer use coupon next time then we check it by finding remainder and if it show remainder 0 that means he already used it.
we show validation error.