How to work with dropdown with different values?

  • Resolved UserDG

    (@tenkepadu)


    10 years, 2 months ago

    How to work with dropdown with different values? I have 4 fieldname, 1)total amount of the product 2)down payment of the customer 3)dropdown, contains different terms with different condition (e.g. 6 months with 0.06 interest, 9 months with 0.10 interest) 4)field for displaying the monthly payment. I’m using this to get the monthly payment, I’ve my own formula to get this kind of payment. But I don’t know how to work with dropdown with different interest values. How to determine what terms the customer choose?

    Example:
    25,000 for fieldname1
    10,000 for fieldname2
    Dropdown choices:
    6 months with 0.06 values interest
    9 months with 0.10 values interest
    12 months with 0.12 values interest
    (I choose 9 months)

    https://www.ads-software.com/plugins/calculated-fields-form/

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

    (@codepeople)

    Hi,

    If your Dropdown field is the fieldnameX, and the values of choices are the interest, you only should use the fieldname in the equation as any other field in your form. For example, if your form is A*B*interest selected, it would be A*B*fieldnameX

    Another solution is with dependent fields, but the correct solution is determined by your form structure, and the mathematical equation to apply.

    Best regards.

    Thread Starter UserDG

    (@tenkepadu)

    I have this formula

    product amount*interest – downpayment
    PREC(((fieldname3*fieldname7),2)-fieldname4) but the result is not that I need.

    I want to do is like this:

    product amount – downpayment = remaining amount * interest = monthly payment

    Plugin Author codepeople

    (@codepeople)

    Hi,

    If the equation you need is:

    (product amount – downpayment) * interest

    and

    product amount is the fieldname3,
    downpayment is the fieldname4,
    and interest is the fieldname7

    you only should modify a little the initial equation:

    PREC((fieldname3-fieldname4)*fieldname7,2)

    Best regards.

    Thread Starter UserDG

    (@tenkepadu)

    Great! Thanks =)

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How to work with dropdown with different values?’ is closed to new replies.