- BarbaraWilliamsAsked on August 27, 2014 at 11:44 AM
Can anyone point me in the right direction? I have started to create a form (which will be long), asking for a company's address information and for them to tick their company's products. By problem is that if they tick one heading, it will be free of charge. If they tick two or more headings there is a charge per heading. The form I need to convert to an online submission form can be found on the attached screenshot if you need to see the extent of my problem. So far I have played around with various options until I can find a working solution, but being new to all of this it is rather hit and miss. Please, please, please can anyone suggest the widgets I can use? The company name and address details listed in the A-Z section are free of charge, along with one heading from either the Classified Buyers' Guide Section or the Regional Guide section. Highlighting the A-Z with a logo or synopsis is chargeable, along with extra headings selected. So I need to find a way to collect the information and then count the number of headings selected to add to the payment form. Unless you know of another way I should do this. Would really appreciate any feedback. The form I have started can be found here http://www.jotform.com//?formID=42322905827354. Website with original entry form http://www.turretgroup.com/directories/view/finishing-yearbook
- JotForm SupportMike_TAnswered on August 27, 2014 at 02:59 PM
Thank you for contacting us.
Are you able to use Text Boxes, Check Boxes, Drop Downs or Radio Buttons for your 'headings'? If so, we can try to assign a calculated value for each option and calculate a total with a Form Calculation widget field.
Then, we can pass the calculated value to a payment total:
Please let us know if this is something that might work. We can provide you with further assistance on this.
- BarbaraWilliamsAnswered on August 28, 2014 at 11:06 AM
Thanks for getting back to me. I can use any of the suggestions (although maybe not a radio button as isn't that for a single option?). I use the code number to input to my database which then corresponds to the heading. The other thing to note is that one heading is free of charge then there is a charge for each extra heading. The other thing is the amount of available headings. With the regional guide they are broken down into sub sections and by region. The buyers guide has about 600 headings which can be broken down into groups alphabetically. Have not been able to look into the problem today, so will have to try tomorrow. If it helps, I can email a pdf of the form that I am trying create using jotform.
Thanks so much for your help.
- JotForm SupportWelvinAnswered on August 28, 2014 at 12:33 PM
Yes, radio button is for single selection only. You can use Checkbox for multi-selection. Let us know if you need any further assistance creating the form. We love to help.
- BarbaraWilliamsAnswered on August 29, 2014 at 06:02 AM
Thanks for your answer. Unfortunately work has got in the way of me creating a form to make work easier! Shall look at the form next week and try some of your ideas....but would passing the calculated value to payment work with the multiple fields widget? As I haven't looked at the form yet to try anything I just forsee this as a potential issue. I have hundreds of headings which I would like to upload rather than typing them singularly using the checkbox for multi-selection. Is it possible to send you a pdf of my form that I am trying to convert so you could point me in the right direction of use this widget for section 1 and that widget for section 2 then link them with calculation (for example). Not sure if this is cheeky, but so far I have been trying different things, only to encounter a problem half a day later realising that the option I have chosen is not suitable.
- JotForm SupportWelvinAnswered on August 29, 2014 at 11:17 AM
Unfortunately, no. You have to use our textbox field to calculate values. Sure, send us the PDF file. Send it to email@example.com and update this thread so we can check it right away.
- BarbaraWilliamsAnswered on August 29, 2014 at 11:40 AM
Have just sent an email with the pdf of my form. As I mentioned before, any pointers you can give would be really appreciated. I made an excel version of my form but that it too large to email but could sit on our website requiring the file to be downloaded, and then with no real way to upload back to the website....hence stumbling across your site!
- JotForm SupportMike_TAnswered on August 29, 2014 at 06:10 PM
Here is a basic example for section 3 and 4 with linked calculation:
I have used conditional logic to update the calculation value since you allow one heading for free.
Please take a look at the following screencast:
You can also clone my example form to check it out.
I hope that this is something that we can start with.
- BarbaraWilliamsAnswered on September 16, 2014 at 11:13 AM
Back working on the form I started and have now propagated all of the checkbox headings (there are thousands of them). http://form.jotformeu.com/jsform/42322905827354
I managed to get the pricing working but will need to revisit at a later stage as I need to incorporate other checkbox options aswell so I have currently mucked it up as I needed to get the headings in therefore the calculation doesn't point to the correct things.
Leaving that aside, I need to concentrate on the product headings where the user can select the headings they want by ticking the checkbox, but for those headings selected they can either have a basic company name listing at £9 (one heading free of charge - calculation can be gathered by the regular ticking of the checkbox) or a panel entry @ £65 (which I will need to add to their total calculation at some point. Is there a way of creating a dropdown box showing all the ticked checkbox headings so they can also select to have a panel entry...or can you think of some other way of doing this. The only way I have found so far is to create a condition that shows the heading if it has been ticked with the option to select a panel entry....but as I have over a thousand headings, to create over a 1000 conditions would be painstaking...is there an easier way? If the heading was ticked in the regular checkboxes, could the option to select a panel entry come up?
I also need to do the same for the Trade Names section (offer a panel entry if they take complete a trade name).
I will then have to go through and calculate all of the options selected (Step 1 A-Z entry option, plus headings ticked, plus any trade names completed)
Hope you can point me in the right direction, if not I will be in 'condition' hell entering each heading singularly!
- JotForm SupportWelvinAnswered on September 16, 2014 at 12:04 PM
How about taking advantage of the Calculation Values feature in the checkbox field?
If the price is based on each field (checkbox), you can put a single price value in the option. Then you can sum up all the fields using a single calculation widget. If there's a hidden sections, you can choose not to include those in the calculation result:
I hope this method would make it easier for you to have the desired result.
- BarbaraWilliamsAnswered on September 16, 2014 at 12:44 PM
Hi Welvin,Thank you for such a speedy response! I am already using the calculation for my check boxes which is why I have to use these rather than the matrix widget. My real problem is being able to offer a panel option (another optional checkbox to tick if they tick the heading check box, if they dont tick a heading checkbox then they will not be offered a panel entry check box) so the panel entry option checkbox does not need to appear alongside unchecked heading check boxes. The only solution I found is stated in my answer above regarding a condition but there are over a thousand headings! Is their a simpler solutiin.? But yes, I would still need to use a check box or something that could be used in the calculation.
- JotForm SupportWelvinAnswered on September 16, 2014 at 02:09 PM
I'm afraid that we don't have any other solution to accomplish the desired output. If you need to have a separate field visible based on the heading selection, then you will have to add it using our conditional logic.
- BarbaraWilliamsAnswered on September 16, 2014 at 04:01 PM
Thanks for responding. Being a little stupid here but are you referring to a separate condition for each heading as I have referred to previously, or is there another condition logic I should be using? Perhaps one that refers to if a check box is ticked then the heading it corresponds to is shown along with the extra check box option. Is that possible?if so, how?
- JotForm SupportMike_TAnswered on September 16, 2014 at 04:25 PM
There is a 'Is Filled' option available for fields. For example, if any Check Box option is selected, it will trigger the 'Filled' state, and show some other field.
If you are referring to something else, please provide us with some example. Thank you.
- BarbaraWilliamsAnswered on September 17, 2014 at 05:45 AM
Thanks for your response...unfortunately I have tried that and I need an option to be triggerd for every selection made (not just for the extra option to appear once). I will also need to keep track as to what heading checkbox they have selected as the extra option checkbox will only apply to that particular heading checkbox.
For example, if I have the checkbox headings as follows (the brackets denote the checkbox):
() Option 1
() Option 2
() Option 3
and Options 2 and 3 are ticked, then I would like by the side of the Option 2 and Option 3 heading a another option checkbox to appear saying Panel entry, so it would look something like this:
() Option 1
() Option 2 () Panel entry
() Option 3 () Panel entry
In other words, I want to find a way to suppress the () panel entry option if the heading is not ticked. I have found a way using conditional logic but it means setting a condition for each heading and as there are so many I wanted to find another way (my original thought was to set a condition for each heading separately so that if Option 1 was filled then it would show 'Option 1 - panel entry - obviously if it wasn't filled then it would not show anything). My next idea was to shrink the first list of checkboxes and added another list with the panel entry option besides it but using the condition, if any checkbox is filled then the entire OPTION list will appear. Can you think of a way around this?
- jedcadornaAnswered on September 17, 2014 at 08:27 AM
I was thinking of Shrinking the fields to have it beside the 'Options' like in your sample. You can set the label on top then shrink the field. Once everythin is set you can now use the conditional logic to show Panel Entry if this Option is ticked.
I cloned your form and was looking to Panel Entry value but it doesn't seem to have any. Can you show us some sample after changing the label on top and shrinking the field. I just want to see what values will be showing when user clicked on any Option.
I have made a sample please check it here http://form.jotformpro.com/form/42593446074964. I used CSS to align fields beside the Options.
- BarbaraWilliamsAnswered on September 17, 2014 at 09:29 AM
That is exactly what I am after, but I had been racking my brain on how to make the condition logic work. I could only get it to show a panel entry option beside every checkbox option. How did you do this? I am sorry, but I tried to open the form example that is showing so I could look at the coding and I do not how to do this (very sorry...advanced in some areas and completely dumb in others!) I had made a clone of my form to work through some examples to see if they would work and this is where I had done some testing http://form.jotformeu.com/jsform/42523741522347. Is this what you are after...if not, if you could explain the condition logic in a little more detail I may be able to get it to work on my original form.
Thanks so much in advance, and I do apologise for not being able to track how you solved the issue from your example!
- BarbaraWilliamsAnswered on September 17, 2014 at 09:44 AM
Please ignore my previous message as I have managed to import your form and can see that your method is one of the ways I had managed to get it to work....by setting up a separate condition for each individual heading....although the CSS coding is a big help in that I can get it to appear adjacent to the ticked checkbox heading! So there isn't a way to do this in bulk with over the 1000 headings that I have (the Classified Buyers' Guide headings on the original form need the same panel entry option aswell!)
- KadeJMAnswered on September 17, 2014 at 10:37 AM
Thank you for the update about that. It seems like you may have been able to resolve this per the provided solutions above then from what I am reading in your above response so you are welcome.
If any of that is incorrect and you end up needing more help with this issue just let us know.