- SunbridgeInstituteAsked 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!
- CharlieAnswered 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.
- kingfisherweddingsAnswered on January 06, 2016 at 03:30 PM
Amazing stuff that hepls me too
- kingfisherweddingsAnswered on January 06, 2016 at 03:33 PM
How do you get the field to be a text string though?
- JotForm SupportKevin_GAnswered on January 06, 2016 at 09:46 PM
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.
- SunbridgeInstituteAnswered on January 07, 2016 at 02:28 PM
Charlie, this is a great solution. Thank you for explaining it so thoroughly.
- JotForm SupportKevin_GAnswered on January 07, 2016 at 04:03 PM
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.