Product selection and conditionnal logic

Hi JotForm Team, 

We want to propose to our customers a selection of products based on their previous choices. It seems we can only add one product list.

For example: Tennis players who look for durability won't have the same selection of products than players who look for comfort. 

We are creating an "airtable" DB in order to stock all the selection of tennis products. If this requires an SQL DB, it's not a problem. 

Thanks in advance, 

Yohann

Hello Yohann - You were right. Unfortunately, you can only add one Product List or payment field for a single form. And apart from that, it is not possible to map the said field into Airtable.

What I can suggest is to create your products outside the payment field. You can use basic fields such as Single/Multiple Choice fields. So if you'll require multiple categories of products to sell, you can just create multiple sets of these fields. Let say the first field is for Durability while the other's for Comfort.

Then assign a calculation value for each option in the Single/Multiple Choice field. Here's a guide on How-to-Assign-Calculation-Value.

After that, you can add a FORM CALCULATION widget to calculate the total cost of the selected options/products.

To learn more about how to use the form calculation widget, here's a link that you can visit: How-to-perform-calculation-in-the-form 

Now the question is, how to pass the calculated total to your payment integration? That's possible by using this guide on How-to-pass-a-calculation-to-a-payment-field.

And that's it! You can now map the products (inside the Single/Multiple Choice field) to your Airtable Table.

Please try that and let us know if you need further assistance.

Thank you for your quick answer.

Do you have a conditional rule to show the right products in front of the customers based on their previous actions? 

For example : People who clicked on "casual player" then clicked on "3x to 5x per year, then clicked on "confort" will receive a list of specific products. Those who chose "casual player" then "3x to 5x per year" but chose "performance" will receive another list of products.

To sum up : Do you have a rule who can combine, IF + AND ?

Thanks in advance

 

Thank you for the quick answer.
Is there a conditional rule to show a list of multiple choice fields based
...

You can add multiple "If" statements in your conditions. Then you can choose "If Any" or "If All". Please refer to the attachment.

You can also add multiple "Do" statements.

I believe that this will allow you to achieve your conditional logic.

Please give it a try and let us know if you need any further assistance.

Alright. Thank you very much. It's much clearer now. 

However, our customers select their products and option during completion of the form. How can we create a sum up of their order in the Form calculation widget? 

Everthing is fine but it's weird for the customer to see a final price without summering up what products and options they chose before. 

Thanks,

Hi,

Could you tell us after which page would you like to show the products to your customers and how would you like to show them?

Looking forward to your reply.

Hi,

Since the customers select different options and products (with corresponding prices) as they go through the form, I'd like to show a sort of 'order summary' on the last page of the form that gives users a detailed overview of all the options they've selected. For instance, this could be a list of line items (specific products, customization options etc) with prices next to them so they can see how the final price is calculated. 

Thanks,

Yohann

Hi there,

You may try adding a Review before submit widget into your form, which will allow users to review all their orders, including each product price and total amount. 

Here's a sample demo: https://form.jotform.com/202297597445063

Please give it a try, and see if it does meet your requirements. 

I hope this answers your question. 

Thank you Lorenz_A, 

How can I download the widget in a specific form? When I dwl it from your link, it goes on a new form and I can't find the widget in the widget list in the builder. 

Thanks,

Yohann

You can add the widget via the WIDGET TABS. You can type in "review" to search it as in the screenshot below:

I can't find the "review before submit" nor the "Relire avant de soumettre" widget in the tab.

The only way I can activate it, is by clicking on the widget url: https://www.jotform.com/widgets/review-before-submit 
Therefore, it activates it on a new form and not on the one I created. 

Thanks, 

Yohann

Is this the form where you would like the widget to be added? Prestation cordage StrinGr

If so, I can see that it's using a CARD FORM layout so the widget is not available for that type of layout.

Instead, you can enable it via the FORM SETTINGS:

Thank you for the fast answer. However the review before submit does not allow a full customisation.

At the end of the form, we would like to create a confirmation page with payment integrated. 
Can you advise us what is the best way to do this on a CARD layout please? 

Sorry, but the Review page cannot be customized on Card forms.

Any kind of customization can only be done in Classic form. In that case, you would need to change the form layout: https://www.jotform.com/help/493-How-to-Change-the-Form-Layout 

There is no way to sum up what the customer chose in the previous steps in the card form. This is correct? 

As a workaround, you can add a PARAGRAPH field as the last page of the form, then customize the field data there.

Here's a quick guide for that: http://tiny.cc/f5qosz