Product selection and conditionnal logic

  • Profile Image
    yohann.aube
    Asked on August 15, 2020 at 09:14 AM

    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

  • Profile Image
    JohnRex
    Answered on August 15, 2020 at 09:56 AM

    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.


  • Profile Image
    yohann.aube
    Answered on August 17, 2020 at 08:32 AM

    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

     

  • Profile Image
    yohann.aube
    Answered on August 17, 2020 at 09:28 AM
    Thank you for the quick answer.
    Is there a conditional rule to show a list of multiple choice fields based
    ...
  • Profile Image
    IvayloK
    Answered on August 17, 2020 at 10:05 AM

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

    1597672855chrome_bM9bwwSFg7.png

    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.

  • Profile Image
    yohann.aube
    Answered on August 17, 2020 at 12:50 PM

    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,

  • Profile Image
    Basil_A
    Answered on August 17, 2020 at 02:15 PM

    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.

  • Profile Image
    yohann.aube
    Answered on August 17, 2020 at 02:33 PM

    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

  • Profile Image
    Lorenz_A
    Answered on August 17, 2020 at 07:51 PM

    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. 

  • Profile Image
    yohann.aube
    Answered on August 18, 2020 at 08:56 AM

    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

  • Profile Image
    JohnRex
    Answered on August 18, 2020 at 09:59 AM

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

    15977591562515014.png

  • Profile Image
    yohann aube 
    Answered on August 21, 2020 at 03:50 AM

    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

  • Profile Image
    JohnRex
    Answered on August 21, 2020 at 04:57 AM

    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:

    15980002562515014 5.png

  • Profile Image
    yohann aube 
    Answered on August 21, 2020 at 05:19 AM

    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? 

  • Profile Image
    gerardw
    Answered on August 21, 2020 at 07:04 AM

    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 

  • Profile Image
    Yohann aube 
    Answered on August 21, 2020 at 01:04 PM

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

  • Profile Image
    JohnRex
    Answered on August 21, 2020 at 02:24 PM

    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