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

    Calculations with a Matrix

    Asked by jacobosanroman on September 13, 2016 at 10:13 AM

    https://form.jotform.com/62563496074968

     

    Hello

    My form does the following calculation now = 

     

    Sub-Total-1 = Income * Activity 1 Factor % * Activity 1 % 

     

    where income is a € value and "Activity 1 Factor %" is a variable like 0,2 and "Activity %" is the percentage that the activity represents of the user business operations. for example the user might have 40% of its activity in architecture and 60% of the activity in design

    I would like to be able to sum at Sub-Total-1 several activities instead of just one, something like these =

     

    Sub-Total-1 = [ Income * Activity 1 Factor % * Activity 1 % ] + [ Income * Activity 2 Factor % * Activity 2 % ] ...

     

    Can you help me? 

     

    Thank you

     

    Page URL:
    https://form.jotform.com/62563496074968

    calculations matrix calculation
  • Profile Image
    JotForm Support

    Answered by Chriistian on September 13, 2016 at 01:14 PM

    I am currently checking your form. Please give me sometime to further investigate the issue. Will get back to you as soon as I get a result. Regards.

  • Profile Image

    Answered by jacobosanroman on September 13, 2016 at 01:17 PM

    thank you i have a new version more clear

     

    https://form.jotform.com/62563711459965

  • Profile Image
    JotForm Support

    Answered by Chriistian on September 13, 2016 at 01:45 PM

    Thanks for giving me the updated form. I checked the form and I noticed that the Activity Factor % field is missing in the updated form.

    Old Form: https://form.jotform.com/62563496074968 

    New Form: https://form.jotform.com/62563711459965

     

    I checked the form and I noticed you are using condition to calculate the value for Sub-Total-1. 

     

    I think it is best to use the Calculation Widget instead of setting the calculation using conditions. To add a Calculation Widget to your form, just search the widget in the More Fields Tab.

     

    Once you have added a calculation, you can set the formula directly to the field using the Widget Wizard.

     

    For more information, you can check this article: How to Perform Calculation in the Form. You can also check this sample cloned form that I have created: https://form.jotform.com/62565754642968. You can also clone the form to have a closer look on the setup: How to clone an existing form from a URL.

     

    Do let us know if you have any further questions.
    Regards.

  • Profile Image

    Answered by jacobosanroman on September 13, 2016 at 02:08 PM

    thank you i will try that and yes sorry i have been updating the form

    the latest form working fine is https://form.jotform.com/62563711459965

    still i would like to be able to find a solution to calculate all activities together instead of the sum of activity 1 + 2 + 3 ...

     

    thank you

  • Profile Image
    JotForm Support

    Answered by Welvin on September 13, 2016 at 03:03 PM

    I think you can calculate the values into one calculation widget. Just add them using a correct syntax, using parenthesis to group each activity. You can look for my colleague's calculation. 

    Please let us know if you require additional assistance on this matter.

  • Profile Image

    Answered by jacobosanroman on September 14, 2016 at 09:46 AM

    hello i think i might not have explained myself ver well. what i am looking for is a table where the user can easily write the % of business in each activity and later on the form will calculate all. i know how to calculate them all. what i do not know is how to show them all together without the need to design a single box for each activity like i have now.

     

    the table would be like this (developer view)

     

    and this is how the user will see the table

     

     

    this is my form today https://form.jotform.com/62563711459965

  • Profile Image
    JotForm Support

    Answered by Chriistian on September 14, 2016 at 11:26 AM

    Hi,

    As far as I understand, you need to have a table in your form where users can input values in the cells. You also need to have calculations in the fields. Have you already taken a look at our Matrix field?

    I am afraid you will need to redo your form, though. I am trying to come up with a demo form but for now, can you please confirm that it is what you need the form to look like?

  • Profile Image

    Answered by jacobosanroman on September 14, 2016 at 11:41 AM

    i will try that thank you and get back to you. in answer to your question:

     

    yes i need a table but the USER will NOT be able to see the column WEIGHT nor the calculation only the activity and % the user has to write something like this = 

     

  • Profile Image
    JotForm Support

    Answered by BJoanna on September 14, 2016 at 01:05 PM

    Thank you for providing us additional info. I will check with my colleague, to see if he has created demo form for you. 

    You can also check our Spreadsheet widget.