Formula Calculated fields

  • Resolved wguillemain1

    (@wguillemain1)


    3 years, 11 months ago

    Hi,

    Is it possible to create an instant quote for my website using this plugin?

    Length + Width = $
    I would like buyers to put in their custom Length + Width Measurements. And have Preset values to give custom amount $ value.

    Something like this for example:

    if fieldname1 (Length) + fieldname2 (width) = (Between 4000 to 6000) then the answer is $850; })();
    if fieldname1 (Length) + fieldname2 (width) = (Between 2000 to 3999) then the answer is $650; })();

    Hope you can answer my question.

    Kind Regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @wguillemain1

    Yes, of course. However, there are two cases you don’t have considered in the project’s description, when the sum is less than 2000, or over 6000

    I’ll try to describe the solution for the ranges in your description.

    The equation would be similar to:

    
(function(){
var n = fieldname1+fieldname2;

if(AND(2000<=n, n<4000)) return 650;
if(AND(4000<=n, n<=6000)) return 850;
})()

    Best regards.

    Thread Starter wguillemain1

    (@wguillemain1)

    Thankyou so much for your help! Much appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Formula Calculated fields’ is closed to new replies.