Conditionally Calculate Fields base on users selection

  • vintageconnection
    Gefragt am 23. März 2024 um 04:48

    Hallo,

    ich habe ein Mehrfachauswahl Modul,

    z.B

    Opt 1

    Opt 2

    Opt 3

    Opt 4


    Ich möchte spezifische Checkboxen in spezifischen Ergebnissen zählen.

    z.B.

    Opt 1 - Positiv

    Opt 2 - Positiv

    Opt 3 - Negativ

    Opt 3 - Positiv


    Zählung:

    Ergebnis 1 (Opt1, Opt2, Opt 3)= 2

    Ergebnis 2 ( Opt 3, Opt4) = 1


    Bis jetzt habe ich nur die Möglichkeit bekommen Einzelauswahlfehler auf diese Art zusammenzählen zu können, gibt es auch die Möglichkeit das mit dem Mehrfachauswahl Modul hinzubekommen?

  • Sheena Jotform Support
    Geantwortet am 23. März 2024 um 07:08

    Hi vintageconnection,

    Thanks for reaching out to Jotform Support. Unfortunately, our German Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Germa, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. Yes, you can count the specific option in multiple choice field. Let me show you how to set that up:

    1. Add a multiple choice field and enable the calculation value for each option assigning 1 to the positive and 0 to negative. Conditionally Calculate Fields base on users selection Image 1 Screenshot 40
    2. Add a Form Calculation Widget and insert the multiple choice field. Click on Save. Conditionally Calculate Fields base on users selection Image 2 Screenshot 51

    We also have a guide on How to Perform Calculations Using a Widget that you can check out.

    Result: Conditionally Calculate Fields base on users selection Image 3 Screenshot 62

    Give it a try and let us know if you need any other help.


  • vintageconnection
    Geantwortet am 23. März 2024 um 07:16

    Sorry I think you misunderstood me. The positive and negative addition is to simulate the checkbox Status.

    All Checkbox option have the value of 1. But when counted I don't want all of the checkboxes counted. I want to be able to select which checkbox I want to add to what calculation modul.

    For example I have multiple checkboxes for food:

    -pizza

    -burger

    - soup

    And then I want multiple calculation modules, for example for:

    Food container

    Fork+knive

    Spoon


    That means for all food checkboxes I need food container but only for snoop I need to calculate the spoons.

    I hope you understand my needs

  • Sheena Jotform Support
    Geantwortet am 23. März 2024 um 07:35

    Hello vintageconnection,

    Thanks for getting back to us. I'm sorry but I don't understand your concern. Can you please share the link to your form so we can see how it is set up? You may also provide an example of how a calculation will work in the form so we can help create conditions to achieve your requirements.

    After we hear back from you, we’ll have a better idea of what’s going on and how to help.

  • vintageconnection
    Geantwortet am 23. März 2024 um 08:04

    Does this link work for you?

    https://form.jotform.com/240784124803050

    So you can see the modul "Burger" and a little bit below the modul "Paletten" and "Zange"

    What i want is, if i check the box "Vintage Burger" (in Burger modul), the box "BBQ Burger" i want to get up the count in "Paletten" by 1.

    When i also check the box "Pulled Pork Burger" i dont want to get the "Paletten" count up but the "Zange" count (next to Paletten).

    This mechanismus should also work for the modus below such as "Hauptgang". When i check the box "Mini Beef Burger" (in Hauptgang) i want the same count of "paletten" be affecten as when i check the "Burger" boxes.

    I also for example need the "1/1 GN" modul go up when the "Vintage Burger" box is checked by 3 for each 30 "PAX" (different modul above).


    I really hope you can provide me a solution for my problem. thanks it advance!

  • Kris Ann Jotform Support
    Geantwortet am 23. März 2024 um 10:29

    Hi vintageconnection,

    Thanks for reaching out to Jotform Support. I’ll need a bit of time to look into this. I’ll get back to you as soon as I can.

    Thanks for your patience, we appreciate it.

  • vintageconnection
    Geantwortet am 25. März 2024 um 06:55

    Hi I just wanted to check if you got any further with my problem. Cheers

  • Kris Ann Jotform Support
    Geantwortet am 25. März 2024 um 10:50

    Hi vintageconnection,

    We really appreciate your patience and understanding while we’re looking into this. You can achieve this flow but setting Conditional logics using the Update/Calculate Field element. Let me show you how to do it:

    1. Let's add fields using a Short Text element where we can pass the value of 1 for Burger options which will show to Paletten/Zange fields.

    • In Form Builder, click on the Add Form Element button, scroll down and select Short text element.

    Conditionally Calculate Fields base on users selection Image 1 Screenshot 150

    Conditionally Calculate Fields base on users selection Image 2 Screenshot 161

    2. Next set these recommended conditions:

    • In Form Builder, go to Settings.
    • Click on the Conditions tab, then click on the Add condition button.
    • Select the Update/Calculate Field from the options.

    Conditionally Calculate Fields base on users selection Image 3 Screenshot 172

    For Vintage Burger:

    Conditionally Calculate Fields base on users selection Image 4 Screenshot 183

    For BBQ Burger:

    Conditionally Calculate Fields base on users selection Image 5 Screenshot 194

    For Pulled Pork Burger:

    Conditionally Calculate Fields base on users selection Image 6 Screenshot 205

    For Mini Beef Burger under Hauptspeise:

    Conditionally Calculate Fields base on users selection Image 7 Screenshot 216

    Conditionally Calculate Fields base on users selection Image 8 Screenshot 227

    To Calculate Palleten based on your criteria:

    Conditionally Calculate Fields base on users selection Image 9 Screenshot 238

    To Calculate Zange based on your criteria:

    Conditionally Calculate Fields base on users selection Image 10 Screenshot 249

    To Calculate 1/1 GN based on your criteria:

    Conditionally Calculate Fields base on users selection Image 11 Screenshot 2510

    View screencast below to see my results:

    Conditionally Calculate Fields base on users selection Image 12 Screenshot 2611

    Conditionally Calculate Fields base on users selection Image 13 Screenshot 2712

    Conditionally Calculate Fields base on users selection Image 14 Screenshot 2813

    You can check out the demo form. If you want, you can easily clone the demo form. This guide will show you how to do that. You can also hide the unnecessary fields from your form, You might also want to check out this guide about How to Hide Form Elements. We also have a guide to help you learn How to Insert Text or Calculation Into a Field Conditionally.

    Give it a try and reach out again if you have any other questions.


  • vintageconnection
    Geantwortet am 25. März 2024 um 12:11

    Wow thanks a lot for your help! I had something similar in mind but your solution looks much cleaner! I appreciate it a lot!