Copying the text value from a field that also has calculation values

  • SunbridgeInstitute
    Asked on January 6, 2016 at 12:03 PM

    In the first question on my form, I'm asking users to select which course they want to take. I've also added in calculation values so that I can easily calculate the total tuition.

    However, I would also like to use the course names selected as an "invoice number" so that it will pass through my payment tool and identify every purchase with the course(s) purchased on the payment receipts from Authorize.net.

    I've created a field called "You've chosen:" and I was hoping that the calculation logic I applied here would bring in the course names selected, but it is giving me the calculation values instead.

    Is there any way to obtain the text value in this copying logic, rather than the calculation value?

    Thank you for your help!

  • Charlie
    Replied on January 6, 2016 at 3:12 PM

    Unfortunately, it seems like it is fetching the calculation value by default.

    Here's a possible workaround that I can think of.

    I cloned your form, you can check it here: https://form.jotform.com/60054724235954 

    1. First, I'll copy the "Please indicate your choice of course(s)"

    I've have two of this fields.

    "Please indicate your choice of course(s) (Text String)" => This does not have a calculation value on it.

    Copying the text value from a field that also has calculation values Image 1 Screenshot 70

    Here is its properties.

    Copying the text value from a field that also has calculation values Image 2 Screenshot 81

     

     

    The other one is "Please indicate your choice course(s) (With Calculation Value)", this is the current one you have.

    Copying the text value from a field that also has calculation values Image 3 Screenshot 92

     

    2. What we want to do is use them in specific cases. You can hide the second one.

    3. We will then setup the conditional logic like this:

    Basically, what happens is that when check box 1 is selected on "Text String" then check box 1 in "With Calculation Value" will also be ticked or selected.

    Copying the text value from a field that also has calculation values Image 4 Screenshot 103

     

    4. From there, you can get the value of "Text String" check box and pass it to "You've Selected" field. While you can use "With Calculation Value" check box for the other fields that needs to fetch the calculation value.

    Copying the text value from a field that also has calculation values Image 5 Screenshot 114

     

    5. From there, you can now use the "You've selected" text box in the "Invoice Number" 

    Copying the text value from a field that also has calculation values Image 6 Screenshot 125

     

    Let us know if that works.

  • kingfisherweddings
    Replied on January 6, 2016 at 3:30 PM

    Amazing stuff that hepls me too

  • kingfisherweddings
    Replied on January 6, 2016 at 3:33 PM

    How do you get the field to be a text string though?

     

  • Kevin Support Team Lead
    Replied on January 6, 2016 at 9:46 PM

    Hi,

    Following the sample provided by my colleague, I presume you are talking to the You've selected field.

    If so, you can follow this guide, it will help you to add the result as text : http://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-field-using-a-Condition 

    Hope this helps.

    Thanks

  • SunbridgeInstitute
    Replied on January 7, 2016 at 2:28 PM

    Charlie, this is a great solution. Thank you for explaining it so thoroughly.

  • Kevin Support Team Lead
    Replied on January 7, 2016 at 4:03 PM

    Hi,

    On behalf of my colleague, you're most welcome.

    Feel free to contact us anytime if you need more help,we will be more than glad to assist you.

    Regards.