Asjad Aamir

Hi every thing is almost done. One small thing, What is | n in below code?

(function(){
IGNOREFIELD(fieldname3|n);
IGNOREFIELD(fieldname4|n);
IGNOREFIELD(fieldname5|n);
if(AND(fieldname1 == 'A', fieldname1 == 'C')){
    ACTIVATEFIELD(fieldname5|n);
} else if(AND(fieldname1 == 'A')){
    ACTIVATEFIELD(fieldname3|n);
} else if(AND(fieldname1 == 'B')){
    ACTIVATEFIELD(fieldname4|n);
}
})()

This is the code

(function(){
    if(AND(fieldname8 == 'Buy Online', fieldname10 == 'EEA')){
        return fieldname6*0.00;
    } else if(AND(fieldname8 == 'Buy Online', fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0,fieldname6*0.0129);
    } else if(AND(fieldname8 == 'Buy Online', fieldname10 == 'USA & CANADA')){
        return SUM(fieldname6*0,fieldname6*0.0199);
    } else if(AND(fieldname8 == 'Buy Online', fieldname10 == 'All other countries')){
        return SUM(fieldname6*0,fieldname6*0.0299);
    } 
 if (AND(fieldname8 == 'Alternative payment method', fieldname10 == 'EEA')){
        return SUM(fieldname6*0.024,0.35);
    } else if(AND(fieldname8 == 'Alternative payment method', fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0.0369,0.35);
    } else if(AND(fieldname8 == 'Alternative payment method', fieldname10 == 'USA & CANADA')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0199,0.35));
    }
else if(AND(fieldname8 == 'Alternative payment method', fieldname10 == 'All other countries')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0299,0.35));
    } else if(AND(fieldname8 == 'QR code transaction of at least 10,01 EUR', fieldname10 == 'All other countries')){
        return SUM(fieldname6*0.005,SUM(fieldname6*0.0299,0.1));
    }
else if(AND(fieldname8 == 'QR code transaction of at least 10,01 EUR', fieldname10 == 'EEA')){
        return SUM(fieldname6*0.005,SUM(fieldname6*0,0.1));
    } else if(AND(fieldname8 == 'QR code transaction of at least 10,01 EUR', fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0.005,SUM(fieldname6*0.0129,0.1));
    } else if(AND(fieldname8 == 'QR code transaction of at least 10,01 EUR', fieldname10 == 'USA & CANADA')){
        return SUM(fieldname6*0.05,SUM(fieldname6*0.0199,0.1));
    }
else if(AND(fieldname8 == 'QR code transaction up to 10,00 EUR', fieldname10 == 'EEA')){
        return SUM(fieldname6*0.01,SUM(fieldname6*0,0.05));
    } else if(AND(fieldname8 == 'QR code transaction up to 10,00 EUR', fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0.01,SUM(fieldname6*0.0129,0.05));
    } else if(AND(fieldname8 == 'QR code transaction up to 10,00 EUR', fieldname10 == 'USA & CANADA')){
        return SUM(fieldname6*0.01,SUM(fieldname6*0.0199,0.05));
    } else if(AND(fieldname8 == 'QR code transaction up to 10,00 EUR', fieldname10 == 'All other countries')){
        return SUM(fieldname6*0.01,SUM(fieldname6*0.0299,0.05));
    } else if(AND(fieldname8 == 'Invoice purchase with Ratepay', fieldname10 == 'EEA')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0,0.35));
    } else if(AND(fieldname8 == 'Invoice purchase with Ratepay', fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0129,0.35));
    } else if(AND(fieldname8 == 'Invoice purchase with Ratepay', fieldname10 == 'USA & CANADA')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0199,0.35));
    } else if(AND(fieldname8 == 'Invoice purchase with Ratepay', fieldname10 == 'All other countries')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0299,0.35));
    } 
else if(AND(fieldname8 == 'Invoice purchase with Ratepay', fieldname10 == 'All other countries')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0299,0.35));
    } else if(AND(fieldname8 == 'All other business transactions', fieldname10 == 'EEA')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0,0.35));
    } else if(AND(fieldname8 == 'All other business transactions', fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0129,0.35));
    } else if(AND(fieldname8 == 'All other business transactions', fieldname10 == 'USA & CANADA')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0199,0.35));
    } else if(AND(fieldname8 == 'All other business transactions', fieldname10 == 'All other countries')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0299,0.35));
    } 
else if(AND(fieldname8 == 'All other business transactions', fieldname10 == 'All other countries')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0299,0.35));
    } else if(AND(fieldname8 == 'Send and receive money (friends and family members)')){
        return fieldname6*0;
    } 
   
 else if(AND(fieldname8 == 'Donation through listed PayPal Fundraisers', fieldname15 == 'Northern Europe	')){
        return SUM(fieldname6*0.0249,SUM(fieldname6*0.0299,0.35));
    } 
})();

Hi, I’m facing one more issue. Please check this video: https://www.loom.com/share/32f1adf231a5487ba59a31b70668bbdc

Is there any way to convert this complete table into German Language?

Thanks for such a detailed explanation. It worked.

How to overcome this problem?

Hello @asjad492

When you use multiple conditional statements, you must enter them from more specific conditions to most general.

For example, if you have the conditional statement:

} else if(AND(fieldname10 == 'Great Britain')){

before

} else if(AND(fieldname8 == 'Alternative payment method', fieldname10 == 'Great Britain')){

The second conditional statement is never reached because the first one satisfy the same condition and appears first.

Best regards.

So, for

else if(AND(fieldname8 == 'Alternative payment method', fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0.024,SUM(fieldname6*0.0129,0.35))

it is giving same value as

else if(AND(fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0,fieldname6*0.0129);

Hi, I used this code now:

(function(){
    if(AND(fieldname8 == 'Buy Online', fieldname10 == 'EEA')){
        return fieldname6*0.00;
    } else if(AND(fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0,fieldname6*0.0129);
    } else if(AND(fieldname10 == 'USA & CANADA')){
        return SUM(fieldname6*0,fieldname6*0.0199);
    } else if(AND(fieldname10 == 'All other countries')){
        return SUM(fieldname6*0,fieldname6*0.0299);
    } else if(AND(fieldname8 == 'Alternative payment method', fieldname10 == 'EEA')){
        return SUM(fieldname6*0.024,0.35);
    } else if(AND(fieldname8 == 'Alternative payment method', fieldname10 == 'Great Britain')){
        return SUM(fieldname6*0.024,SUM(fieldname6*0.0129,0.35));
    }
})()

Now, the issue is when I select Alternative payment method and Great Britain from drop-down, it does not give correct value for this one.

Thank you so much. It worked like a charm. You’re such a great person:)

Is this correct?

(function(){
if(AND(fieldname8 == ‘Buy Online’, fieldname10 == ‘Great Britain’)){
return SUM(fieldname5*15,10); } else if(AND(fieldname8 == ‘Alternative payment method’, fieldname10 == ‘Great Britain’)){ return fieldname5*2;
}
})()

And can you please tell where to enter formula like addition or multiplication in this code? as it is a caclulated field, so I have to make a calculation

Thanks for your response. Can you please tell where to insert this code?

Really disappointing. No one is replying

Anyone?

Please check: https://www.loom.com/share/8c2a6294fbfa4752b77c8f5af27c1725