JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Copying the text value from a field that also has calculation valuesAsked 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!
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.
Amazing stuff that hepls me too
How do you get the field to be a text string though?
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.
Charlie, this is a great solution. Thank you for explaining it so thoroughly.
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.