Passing calculation values to another field using conditions

  • Profile Image
    STMNGB
    Asked on March 27, 2018 at 11:41 AM

    I assigned numerical field values for multiple choice text fields and I need the numerical values to appear in the submissions results instead of text. Can you advice on the best way to achieve this, as spent hours trying to figure it out with no luck?

  • Profile Image
    Jan
    Answered on March 27, 2018 at 01:03 PM

    I suggest you create another field where you can pass the calculation values of the options. Here's how:

    1. In the Form Builder, insert a Short Text Entry field that will be assigned for a specific checkbox.

    152216992411.png

    2. After that, create a condition wherein if the checkbox is filled, the calculation value of that option will be copied to the Short Text Entry field. You can use the Update/Calculate Field Condition for that. Here's a guide: How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic.

    152216993622.png

    Here's the result:

    1522170169wokvld.gif

    Here's a screenshot of the email alert:

    152217015103-28-scjck.png

    Hope that helps. Thank you. 

  • Profile Image
    STMNGB
    Answered on March 27, 2018 at 01:52 PM

    That's a brilliant solution. Thank you very much. I hid the additional fields and they come up in the submissions report but not on the actual form.

  • Profile Image
    Jan
    Answered on March 27, 2018 at 02:30 PM

    Glad to hear that. You are welcome. If the fields are hidden, then it will not appear in the actual form.

    If you have any help, please do not hesitate to contact us. Thank you.

  • Profile Image
    STMNGB
    Answered on March 27, 2018 at 02:33 PM

    Thank you. That's exactly what I needed - numerical values in hidden fields so that they are not clattering the form itself, but still appearing on submission reports for analytics and total scores.

  • Profile Image
    Jan
    Answered on March 27, 2018 at 02:50 PM

    My understanding is that you want to hide the checkbox field (texts) and just show the numerical value (passed data).

    152217610103-28-t5af0.png

    If that is correct, then you can just disable that field on the Submissions page. Just click the "Options" icon and uncheck that field. After that, click the "Options" icon to save the changes.

    152217608203-28-3gr8d.png

    Hope that helps. Thank you.

  • Profile Image
    STMNGB
    Answered on March 27, 2018 at 03:10 PM

    You just made it even better for me. Great advice! Much appreciated. Brilliant!