What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    how to do this part on a form

    Asked by stephie6 on March 27, 2015 at 10:31 AM

    Hi,

     

    Please see picture for the part of the form that i am trying to do. The part with the grey, green and red. To be able to select and compare. When selected to have the total at the end.

     

    thanks

    part JotForm uploads jpg picture
  • Profile Image

    Answered by Shadae on March 27, 2015 at 12:50 PM

    Hi stephie6,

    To confirm, you would like to add a spreadsheet table to your form?

    If that is the case, we do have a Spreadsheet widget that can be added to your form and can perform calculations.

    Spreadsheet Widget 

    If you do not need to have the calculation feature, you can also use our data grid widget to display your information in the same format.

    Data Grid Widget 

    I hope this helps, please inform us if you need further assistance.

    Thank you.

  • Profile Image

    Answered by stephie6 on April 08, 2015 at 09:30 AM

    The data grid it says search but i would like to have it in french... is it possible ?

     

    what would you do to represent this picture on my form?

  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 08, 2015 at 01:24 PM

    Hello stephie6,

    I did test the data grid widget but unfortunately the search text cannot be displayed in french.

    You Just want to display the above grid in your form correct? You can add a "Text" field in your form and manually add the table to display the items.

    Please take a look at the following screenshot and see if this is what you wanted to achieve (texts can be changed to match as per your screneshot):

    Please take a look at the following form where I have added the table in the "Text" field:  http://form.jotformpro.com/form/50974698507976? Feel free to clone this form for a closer look. The following guide should help you in form cloning:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Hope this helps.

    Thank you!

  • Profile Image

    Answered by stephie6 on April 08, 2015 at 07:14 PM

    good but how can they choose the quantaty etc.. i imagine i have to put a drop down

     

  • Profile Image
    JotForm Support

    Answered by Charlie on April 08, 2015 at 10:37 PM

    Hi,

    May I know if the table you are creating is dynamic? Where details can be added into it? Like a drop down or an input field? That "Text" field mentioned by my colleague is fixated and your end users won't be able to change or input any data on it.

    You could try using the Configurable List widget. Or if you are using calculations, then you can try using plain form fields together with the "Conditions" function, or the "Spreadsheet" widget for it. Although, it won't have the same design that you have in your sample, you can redesign using the Form Designer but will need an advance custom CSS code to meet that style.

    Kind regards

     

  • Profile Image

    Answered by stephie6 on April 09, 2015 at 06:17 AM

    i want the client to see the heading of the sheet fixed but the choices below so that they can choose mutliple option. mix and match you know and what ever they choose the calculation for the soumission will appear under in a order status saying if you choose this product with this and with this quantity here is the price.

  • Profile Image

    Answered by stephie6 on April 09, 2015 at 08:00 AM

    OK how do i do the total for this picture?

  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 09, 2015 at 09:26 AM

    Hello stephie6,

    Yes it is possible to do the calculation for the fields displayed in the screenshot you have shared. 

    Can you please explain the calculation formula on how the total will be calculated? We will surely help you on how to add it in your form.

    Basically, you will have to add the "Calculation values: for dropdown values and then use it in a calculation values. Here are the steps you should follow:

    #1. Add the "Calculation values" for every dropdown option you have. Please check the screenshot below on how to add the calculation values:

     

    #2. Repeat this step for every drop down question which will be part of the calculation. 

    #3. Add a "Form Calculation" widget in your form and add the calculation formula. 

    Hope this helps.

    Do get back to us on the calculation formula and we will help you adding it in your form.

    We will wait for your response.

    Thank you!

  • Profile Image

    Answered by stephie6 on April 09, 2015 at 11:05 AM

    thank you !

     

    here is the link of the actual form: http://form.jotform.ca/form/50813764348258

     

    how would you make it work ?

    i want that when people are choosing from this part(picture) the sub-total is at the bottom of this picture and i want my form to calculate all the things that are on it (taxes, épreuv, montage etc) and have a total at the end. just to show the customer what is the price before clicking on submit (soumettre).

  • Profile Image
    JotForm Support

    Answered by david on April 09, 2015 at 12:09 PM

    As my colleague stated, you would need to associate calculation values with your dropdown selections:

    These are the values that will be used by the calculation widget.  Once you have the proper values associated with your fields, you can then use the calculation widget to perform your final calculation:

    http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    How you set up your final calculation will depend on how you would like the total calculated.

  • Profile Image

    Answered by stephie6 on April 09, 2015 at 01:51 PM

    ok good so my first drop box is 1,2,3,4 and the second one is 5,6,7,8 ? or i can put again 1,2,3,4? (sorry i am french so i want to make sure i understand well hahaha!)

     

    and after if i am the Customer and i want to see how much it will cost me if i choose different quantity and different pricing before submitting

  • Profile Image

    Answered by stephie6 on April 09, 2015 at 02:16 PM

    ok good so my first drop box is 1,2,3,4 and the second one is 5,6,7,8 ? or i can put again 1,2,3,4? (sorry i am french so i want to make sure i understand well hahaha!)

     

    and after if i am the Customer and i want to see how much it will cost me if i choose different quantity and different pricing before submitting

  • Profile Image
    JotForm Support

    Answered by david on April 09, 2015 at 03:35 PM

    After you have your calculation values, you would need to add a calculation widget to your form:

    http://widgets.jotform.com/widget/calculation

    In the settings for the widget, you can setup your calculation how you'd like.

    The above calculation would take the calculation value associated with the selection made in those two fields and multiply them together.  You can setup the calculation however you would like.

  • Profile Image

    Answered by stephie6 on April 09, 2015 at 04:03 PM

    ok good so my first drop box is 1,2,3,4 and the second one is 5,6,7,8 ? or i can put again 1,2,3,4? (sorry i am french so i want to make sure i understand well hahaha!)

  • Profile Image

    Answered by Shadae on April 09, 2015 at 05:31 PM

    Hi stephie6,

    You can use the same set of values of different fields, as well as using different set of values. Which ever option would best suit your needs.

    I hope this helps, please inform us if you need further assistance.

    Thank you.