Support » Plugin: Calculated Fields Form » Dropdown dependency upon dependency

  • Resolved Mr. Peri

    (@mr-peri)


    Hi,

    Is it possible to, within the dropdown fieldset, to have a dependency upon a dependency. Example:
    I have a dropdown to select a TYPE of wood. Once a type is selected it opens fields for THICKNESS and WIDTH. Once a width is selected a field must open with a PRICE that correlates with that specific width.
    Example:
    Type is Clear Pine, thickness 25.4mm or 38.1mm, width 114mm or 152mm.
    IF selection is made for 25.4mm thickness and 114mm width then price is 7800
    IF selection is made for 25.4mm thickness and 152mm width then price is 8000
    IF selection is made for 38.1mm thickness and 114m widht price is 8100
    If selection is made for 38.1mm thickness and 152mm width price is 8300.

    In other words, I need the price field to adjust according to the values selected in the thickness and width dropdowns

    The page I need help with: [log in to see the link]

Viewing 12 replies - 1 through 12 (of 12 total)
  • Thread Starter Mr. Peri

    (@mr-peri)

    Never mind…figured it out! Thank you

    Plugin Author codepeople

    (@codepeople)

    Hello @mr-peri

    Thank you very much for letting me know you have found the solution.

    Best regards.

    Good day sir,

    I do have a similar problem but not as complex as yours.

    I have an affiliate table that looks like this

    Aff Lev Sal Vol Aff Comm ProdPrice Earnin
    Starter 1000 20%. 100 —
    Advance 2000 40% 100 —

    So I created a numberfield with text “starter” and I gave it a value of 1000 as seen in table above, did same for “Advance”

    Now what I want it is that once I select e.g “Advance” in the drop-down menu it will apply the values of each respective table above to give me a result in the earning column

    Example:
    Advance / (AffComm for Advance * ProdPrice)

    Plugin Author codepeople

    (@codepeople)

    Hello @aimstitute

    There are multiple possible solutions, however assuming there is a DropDown or Radio Button field (fieldname1) with two choices: Starter and Advanced

    You simply should to insert a calculated field in the form with the following equation:

    
    IF(fieldname1=='Advanced', 2000/(0.40*100), 1000/(0.20*100))
    

    Best regards.

    I have a drop down to select a TYPE of number or data. Once a type is selected it opens fields for THICKNESS and WIDTH (for example Concrete Calculator).

    If Someone Changes its Shape or Size like Round to Square or rectangular. It should be change.
    Any Guide or Link to learn more. I need for following section -:
    https://procivilengineer.com/calculator/

    Thanks, that was helpfull

    And what if they are four(4) options instead of two(2), how do I go about doing that using this method below:

    IF(fieldname1==’Advanced’, 2000/(0.40*100), 1000/(0.20*100))

    I created 4 affiliate categories.

    Starter = 20%
    Advance = 40%
    Pro = 60%
    Elite = 80%

    Plugin Author codepeople

    (@codepeople)

    Hello @aimstitute

    You can nesting multiple “IF” operations, but the code is harder to understand, so, you can implement the equation with a function structure and use the “if” conditional statement of javascript:

    
    (function(){
    if(fieldname1 == 'Starter') return 1000/20;
    if(fieldname1 == 'Advanced') return 1000/40;
    if(fieldname1 == 'Pro') return 1000/60;
    if(fieldname1 == 'Elite') return 1000/80;
    })()
    

    Another alternative using the “switch” conditional statement:

    
    (function(){
    switch(fieldname1)
    {
    case 'Starter': return 1000/20;
    case 'Advanced': return 1000/40;
    case 'Pro': return 1000/60;
    case 'Elite': return 1000/80;
    }
    })()
    

    A third alternative nesting the “IF” operations distributed with the plugin:

    
    IF(fieldname1 == 'Starter', 1000/20, IF(fieldname1 == 'Advanced', 1000/40, IF(fieldname1 == 'Pro', 1000/60, 1000/80)))
    

    Best regards.

    Nice one problem solved… Thanks

    But noticed this 2 things as well

    1) i wanted user to be able to edit either “Number of referrals” or “Expected monthly Earnings” and have their input value affect other values within the table

    2) Also i notcied the columns are squeezed together and not spread out taking advantage of the space aavaiable as seen here: http://prnt.sc/s7kubr

    They attached picture shows what i am trying to achieve, incase if there is any advice

    Warm Regards

    Plugin Author codepeople

    (@codepeople)

    Hello @aimstitute

    Responding to your question:

    Q: Also i notcied the columns are squeezed together and not spread out….

    A: You simply should to select the “Large” option for the “Field Size” attribute in the form’s settings.

    Q: i wanted user to be able to edit either “Number of referrals” or “Expected monthly Earnings” and have their input value affect other values within the table.

    A: Insert two numbers or currency fields in the form, and use them in the equations.

    I’m sorry, the support service does not cover the implementation of the users’ projects (forms or formulas). If you need someone that implement your equations, do not hesitate in contact us through our private website: Customization

    Best regards.

    @codepeople

    I get for example 189.00000001

    How do I limit or remove the excessive “0’s” after 189

    Thanks

    Plugin Author codepeople

    (@codepeople)

    Hello @aimstitute

    If you want an integer number as the equation’s result, you should use the ROUND operation: ROUND(X) returns the integer number equal or nearest to X. For example, if you have the equation:

    
    IF(fieldname1 == 'Starter', 1000/20, IF(fieldname1 == 'Advanced', 1000/40, IF(fieldname1 == 'Pro', 1000/60, 1000/80)))
    

    edit it as follows:

    
    ROUND(IF(fieldname1 == 'Starter', 1000/20, IF(fieldname1 == 'Advanced', 1000/40, IF(fieldname1 == 'Pro', 1000/60, 1000/80))))
    

    If you want the result with a specific number of decimals, use the PREC operation: PREC(X, Y) returns the number X rounded with Y decimals. So, if you want the operation’s result with two decimals, the same equation can be edited as follows:

    
    PREC(IF(fieldname1 == 'Starter', 1000/20, IF(fieldname1 == 'Advanced', 1000/40, IF(fieldname1 == 'Pro', 1000/60, 1000/80))), 2)
    

    Best regards.

    Thread Starter Mr. Peri

    (@mr-peri)

    .

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Dropdown dependency upon dependency’ is closed to new replies.