What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by SunbridgeInstitute on January 06, 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!

    Page URL:
    http://www.jotform.com//?formID=60007126527952

    calculation values values a purchase payment tool selected select
  • Profile Image
    JotForm Support

    Answered by Charlie on January 06, 2016 at 03: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.

    Here is its properties.

     

     

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

     

    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.

     

    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.

     

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

     

    Let us know if that works.

  • Profile Image

    Answered by kingfisherweddings on January 06, 2016 at 03:30 PM

    Amazing stuff that hepls me too

  • Profile Image

    Answered by kingfisherweddings on January 06, 2016 at 03:33 PM

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

     

  • Profile Image
    JotForm Support

    Answered by Kevin_G on January 06, 2016 at 09: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

  • Profile Image

    Answered by SunbridgeInstitute on January 07, 2016 at 02:28 PM

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

  • Profile Image
    JotForm Support

    Answered by Kevin_G on January 07, 2016 at 04: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.