- jotform1939Asked on November 07, 2013 at 02:43 PM
I have created a form with radio buttons for 18 different questions. Each question has four choices and we want to assign a number value to each (1-4) with a calculation adding up the values based on a responder's answers resulting in a total calculated range between 18 to 72.. How can we do that?
- KadeJMAnswered on November 07, 2013 at 04:13 PM
Hello, I think this may be something that might be a possibility so I will see what I can come up with. It would likely have to use the form's source code with a math-based JS Script that will be woven into it as a custom workaround. This would be a programmed expansion from the normal previous Calculated Total Scripts that my colleagues have previously developed. Let me think about this some and I will try my best to get back to you as soon as I can with a possible solution.
- jotform1939Answered on November 07, 2013 at 04:38 PM
Thanks so much Kade. I've been asked for this same thing before but just didn't pursue it.
- CesarAnswered on November 07, 2013 at 05:02 PM
On behalf of my colleague, thank you for your response. Once he has any updates on this, he will let you know through this thread.
- KadeJMAnswered on November 08, 2013 at 10:39 AM
I just wanted to give you an update on what's going on. I'm still working on it and I think I have figured a out a way that this will work now. It's turning into quite the challenge for me so I had to research this some more to get ideas to expand on to make it work. I'm pretty much at a turnaround point where I think I now may be able to plug it into the entire form with the rest of the fields to get it to work but it will take some additional time to do so and work out any kinks that I come across with it.
Here's a small Demo Example of kinda what I have and am going for so far while attempting this just to what I've got in regards to this which I am trying to work more. It's still far from perfected yet and I don't have the full setup of your exhisting form's formatting style plus I gotta add in the rest of the survey fields. But I'm going to try to rebuild it further to work with your current form or at least get it as close to that as I can.
I will try to have something ready later on this evening or the latest being another day or two. I will keep you updated. Also, if I'm going in the wrong direction from what you want then please let me know immediately so that I can fix it now and should that be the case then I do apologize.
- jotform1939Answered on November 08, 2013 at 11:09 PM
Hi Kade. I looked at the demo you prepared for me and it's performing exactly like I need. Thanks for your work. I really appreciate it.
- JotForm SupportEltonCrisAnswered on November 09, 2013 at 04:12 AM
That sounds great! I'm sure my colleague will respond here as soon as he reads this today.
- KadeJMAnswered on November 11, 2013 at 10:28 AM
Hi Again JotForm1939, I'm very sorry about not getting back to you right away due to the fact that it took a little longer then I had anticipated. I also tried doing it a different way to make it more organized but was not working so I have since applied this with everything to rebuild your form. It's working so far so the majority of the form is ready as a whole. However, I am still going to have to work on reconfiguring this some more so that it resembles your original form more. As of right now the form's original CSS for some reason did not center everything so I will have to fix that. The other issue that slightly concerns me is that I'm not entirely sure if the Input I used will carry over into our database so I will work on testing that and then fixing it more if necessary. I will continue to work on this for you and will get back to you as soon as I can.
Here's the Most Recent Version of the Form. Be advised that because of the way I am doing this you will need to embed the whole form's source code so that it will work. This is due to the modifications that have been made to add in the custom calculations.
- KadeJMAnswered on November 13, 2013 at 10:43 AM
I've started working on fixing this some more and I started thinking about the Sum of the Survey Total. Was this something you wanted the Customer/Patient to be able to see or did you want it to be a backend thing where you could only see this when reviewing the form?
- jotform1939Answered on November 13, 2013 at 10:51 AM
Make it visible on the front end so the Customer/Patient can see it as well.
Thanks Kade for all your hard work in making this happen for us.
- jotform1939Answered on November 13, 2013 at 10:53 AM
I know if I sent you the original form that we are replacing with the one I've created with JotForm. https://www.adhdclinicsa.com/index.php?option=com_rsform&view=rsform&formId=17&Itemid=147
- JotForm SupportWelvinAnswered on November 13, 2013 at 02:27 PM
thanks for the working example. I think we can re-use the codes from the your current form. We'll see if we can come of the modified codes later today. I will try to ask Kade as well.
- jotform1939Answered on November 13, 2013 at 02:45 PM
Sorry I didn't provide it before. Just didn't think about it.
- JotForm SupportEltonCrisAnswered on November 13, 2013 at 06:04 PM
Thanks, that's appreciated.
My colleague will get back to you with updates as soon as he can. We will also try to cooperate with him to achieve this.
- KadeJMAnswered on November 18, 2013 at 10:24 AM
I apologize that it's been a few days since I last responded to you but I assure you there's a good reason why. It was due to the fact that I've been very busy and also working closely with one of our Developers on a New Feature labeled " Calculated Field " to speed up this process instead of the workaround I had previously been working on which I was a bit stuck on for awhile off and on. I'm not sure if you've noticed this new feature or not but I just wanted to point it out just incase you haven't yet. This is now much easier and you no longer have to embed the full source code like before. It will also gather all of the necessary information including the Sum (Textbox) that was a problem wheras now it is not.
Sadly though, I've attempted to rebuild this with a Newer Clone of your Original Form which I was working on but I ran into an issue where this was not working on my end. So because of that factor I think there is a chance that you may have to rebuild it to make this work. However, I did test the calculation feature on a brand new form with all 18 Questions for you and it is Working as intended so if that becomes necessary then it won't be a lost effort in doing so.
I also think that after this it would now safe to move onto to finishing your form and restyling it the way you want. If I am too late and you've already done all of this then I am very deeply sorry about all of the delays as I did not mean to leave you hanging for this long.
- jotform1939Answered on November 18, 2013 at 11:58 AM
I knew you'd respond when you had a solution. I don't see the "Calculated Field" in the Properties window.
- EliezerNAnswered on November 18, 2013 at 01:42 PM
You should see the Calculate Fields by right clicking over the field:
But if you are not able to see that option kindly try clearing your form Cache, to know how to do it please follow the next guide: How to clear your form cache
Please let us know if you need further assistance or kindly open a new thread to post unrelated inquiries. My colleague will get back to you sooner than later.
- KadeJMAnswered on November 18, 2013 at 02:32 PM
In addition to what my colleague mentioned I would like to point out that it will only work on certain fields. I checked your account and it appears that you should have it. Try right-clicking on the Configurations (Grey Gear) for a Text-box Field or a Text Area Field to see if it shows up. These are what you would use to collect your form's " Sum " or " Total " per say.
At that point you could then use other fields such as your survey's " Radio Options " which would gather value of 1 point per each if set mathimatically to equal the " Sum ". You can set it to Read-Only as well so that your customers can view it but are unable to change it if you wish.
- jotform1939Answered on November 18, 2013 at 10:46 PM
Thanks. I found it. I wasn't right clicking in the field.
- JotForm Supportashwin_dAnswered on November 19, 2013 at 12:18 AM
On behalf of my colleagues, you are welcome.
Do get back to us if you have any question.
- businetAnswered on May 17, 2014 at 05:37 PM
- JotForm SupportjonathanAnswered on May 17, 2014 at 10:34 PM
Hi, I have created a new separate about your question here http://www.jotform.com/answers/378913
Pleae use your own post to check for updates regarding your inquiry.