Config List Widget: Able to perform calculation within this widget

  • craftlabph
    Asked on September 26, 2016 at 4:19 AM

    With regards to the current Payment Field I'm using, which is the "Purchase Order", it only lets me add 1 option with a special pricing in it. But in my form, I need to add 2 more option which will also enable me to add a special pricing to it.

    Config List Widget: Able to perform calculation within this widget Image 1 Screenshot 20

  • Mike_G JotForm Support
    Replied on September 26, 2016 at 4:59 AM

    First, thank you for explaining this further, however, I would like to apologize, but having more than one option with special pricing doesn't seem to be possible because it would just create conflict. 

    Let's just say, for example, if the user selects an option from Option 1 with special pricing and then selects another option from Option 2 also with special pricing, what special pricing should it show? Would it have the special pricing on Option 1 or the one in Option 2?

    If you would like to have more than one option with special pricing, I would suggest you recreate your product list using basic fields (textbox, radio button, checkbox, and/or dropdown fields) and pass the total or the final output of the computation to a payment field. You may also need to use a Form Calculation widget for the computation.

    The instruction on how you can pass calculations to your payment field is found in this guide: How-to-Pass-a-Calculation-to-a-Payment-Field. However, if you have any further questions or you need clarifications, please feel free to contact us anytime and we will be glad to help you.

  • craftlabph
    Replied on September 27, 2016 at 2:32 AM

    I'm thinking of something like the screenshot below. I used the Configurable List Widget here. I added the "Total" for visualization purposes only.

    Now, I need to configure how I could do the following.

    A. Insert conditions for each field

    Example, the customer chooses:

    Business Card -> Type should only show Regular, Matte and Glossy. The other choices in the dropdown would be hidden. Same goes with the Size and Add-On.

    B. Insert total for each row and the total will vary for different fields.

    Example:

    Business Card, Matte, 1.75" x 2" costs 1.00 then the customer wants it to be back to back. Back to back has an additional price for it which is 2.00. So, the total should be 3.00.

    Business Card, Regular, 3.5" x 2" costs 3.00.

    And so on...

    Config List Widget: Able to perform calculation within this widget Image 1 Screenshot 20

    I am not entirely sure if this is possible. But I hope it is. Please take your time to answer. I will be waiting.

    Thank you so much.

     

     

     

     

  • Elton Support Team Lead
    Replied on September 27, 2016 at 4:26 AM

    Hi,

    I hate to say this but that's not possible with configurable list widget. Unfortunately, all framed widgets does not support calculations and you can't apply insert/update conditions to them due to their nature. They are iframe elements and iframe is considered a separate document and insert conditions only works on the same document level.

    I will raise this to our developers as an enhancement request for the config list widget. Hopefully this will be considered or implemented in the future.

    For now, you may consider what my colleague has suggested about using regular dropdown/textboxes and apply calculation conditions. https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-Conditional-Logic

    You can actually perform calculations on Matrix field too https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

    Thank you!