- nickbhAsked on March 11, 2015 at 01:14 PM
Firstly, I think the Jot form product is superb. Best form-maker I have come across.
I have a slight challenge that I'm struggling to decide on the best method.
Essentially I want to create a form that allows me to select an option from a group of data (passed by either a query string in the url or another method?) and process a payment based on that data?
The offers may range from say 1 offer to 10 offers?
I want the form to display the offers, then the user selects one and pays through online payment processing?
My question is how best would I get the data into the grid/table and what if any widget would be best to use?
Any help greatly appreciated.
- CharlieAnswered on March 11, 2015 at 02:03 PM
Thank you for the kind words and I'm glad you find JotForm useful.
Regarding your question, I'm not sure if I fully understand it. I see that your form is a reservation form, is that correct? For each reservation are you aiming to let your users to input multiple taxis with offers on shared and private? Or is it just "one" taxi per submission?
If you would like to pass custom prices to payment total field, you can do that by following this guide: http://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field.
I hope this helps.
- nickbhAnswered on March 12, 2015 at 08:42 AM
Thanks the info is very useful. However, to explain further I have managed to mock-up a form similar to the one I would wish to use.
The grid in the form contains text fields.
Can I send a query string to populate those text fields?
Can I use the amount from one of the text fields in the grid to populate the amount in the paypal form?
Can the grid be dynamic (ie increase or decrease in size based on the rows in the query string?
IS their a drid option that allows multiple types in the rows? ie to include a radio button?
Hope my explanation makes sense? Essentially The user would select one of the cells within the grid and that would trigger the amount for payment.
- CharlieAnswered on March 12, 2015 at 10:53 AM
Unfortunately, we can't pass the value from the matrix field to as a total or calculation value.
What I would recommend is using the radio buttons and adding a value on it. Here's the test form that I made: http://form.jotformpro.com/form/50704114636953.
Here's what I did.
1. Add a radio button and change the number of columns to 6 so that it can have a horizontal effect.
2. After that, click the Properties of the radio button and add corresponding values for each option. You'll add it in the Calculation Value field.
3. After that, add a "Form Calculation" widget, click the wizard icon.
4. You can then click "Add Fields" to sum all the selected options in option 1, 2 and 3.
5. We will then need to pass the value in the form calculation widget to the Payment total field.
I hope that helps. Do let us know if you need more assistance on this.
- nickbhAnswered on March 12, 2015 at 11:53 AM
Very Very Helpful. Not quite there... so I have some questions>
Can the calculation values be amended (ie passed) as part of a query string through a URL?
Also - Do you have any ideas how to show the values passed eg>
That is, can you dynamically update the labels maybe?
Also the list as you have it with 3 options means you can have 3 picks. However the intent would be to have one pick from all the options.
Again, any help or advice will be greatly appreciated.
- CharlieAnswered on March 12, 2015 at 12:41 PM
You're welcome, we'll try our best to design the form as you expected.
So just to confirm, here's what I understand.
1. There's multiple options with sets of items but user can only select one of them, one option and one item on it?
2. Each item has a value?
So here's an update of the form: http://form.jotformpro.com/form/50704114636953. I've removed the grid because you have mentioned that they will only pick one option, so instead I'll use a drop down option and when one is selected it will display the option's available items.
So this is what I did.
1. I added a drop down option with 3 options.
2. I then click the "Conditions", what we want to do is "SHOW" the options depending on what is selected on the dropdown, then we would like to pass the value of the selected item in the options to the calculation field to be used.
3. Here's what my conditions look like. To learn more about conditions you can check this guide: http://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic
For the labels, you can just select the text and edit it.
For the other question that you have, yes you can pass the form field value via URL parameters. You can learn more about it here: http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters.
I hope that helps. I'm not sure though if I understand your requirements completely.
- nickbhAnswered on March 12, 2015 at 02:28 PM
Again thanks for the info but its not really hitting the mark. I will try to explain in more detail.
Lets say I have 3 suppliers.
When I call the form I need to pass query strings that have data in for each of the suppliers. I am familiar with passing query strings to the forms to pre-populate the fields.
Private Transfer, 25 Euro
Shared Transfer, 26 Euro
Taxi, 15 Euro
Private Transfer, 25 Euro
Shared Transfer, 15 Euro
Taxi, 19 Euro
Private Transfer, 15 Euro
Shared Transfer, 10 Euro
Taxi, 30 Euro
Th highlighted variables will change often - as I say they will be passed as part of the url.
What I am trying to do is display ALL the information in a grid (or similar).
The user of the form will then select 1 option from the 3 suppliers and the multiple choices available. The cost figure e.g. 30 Euro will then be passed for payment processing.
Does that make sense?
If I was able to select the apporprirate cell and use the figure that would do the trick. Or as before if I was able to use radio buttons but need to display the value passed as part of the URL?
Many Thanks for your support.
- JotForm SupportMikeAnswered on March 12, 2015 at 04:15 PM
Matrix fields are not currently supported in calculations, and there is no way to select Matrix cell with the text box input type.
If you would like to use calculations, you will need to use standard fields. And if you would like to use pre-population by URL, it is most likely that you are limited to text boxes / text areas.
Here is the form example based on text boxes and check boxes. The form can be pre-populated.
Values passed to the Calculation field with 'Update a form field value' conditions.
You can clone that form to check the back end. Thank you.
- nickbhAnswered on March 13, 2015 at 09:46 AM
Thanks Mik, that's Perfect, and will allow me to create the form exactly as I need.
My only final question is I am unsure how to create the input box without the input? Im sure its obvious but I cant work it out? Ie what element is the circled one in my screenshot?
- CharlieAnswered on March 13, 2015 at 11:22 AM
I'm glad that my colleague's sample worked for you.
Regarding your question, he used a custom CSS code to hide the input field for that one.
To do that, you need to open the form designer, click the "CSS tab", double click the input field and add the CSS code "visibility:hidden;".
Or, you could also use the "Text" field instead as a field name if you are not really using the text box for the "Supplier" name.
I hope that helps.