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 set up calculations based on a Matrix field inputs

    Asked by SMFSNCU on October 09, 2015 at 06:39 AM

    The date fields for columns would be dollar value with total across with a final column to the right that would add line totals.

     

    Also from on the Personal Car field in Travel and Expense I need a formula that calculates the mileage entered from Travel information x0.575

  • Profile Image
    JotForm Support

    Answered by david on October 09, 2015 at 12:03 PM

    Hi,

    I checked your most recent form and it looks like you are still using Matrices rather than the Spreadsheet widget:

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

    I believe my colleague explained the setup of the widget in your previous thread.

  • Profile Image

    Answered by SMFSNCU on October 09, 2015 at 02:45 PM
    Sorry but I don’t understand the google spreadsheet. This seem cumbersome.
    ...
  • Profile Image
    JotForm Support

    Answered by Mike on October 09, 2015 at 05:18 PM

    Alternatively, you might try conditional calculations with 'UPDATE / CALCULATE FIELD’S VALUE' conditional logic rules on form.

    Here is an example for one Matrix row.

    Note, that you will need to set calculation condition for each row.

  • Profile Image

    Answered by SMFSNCU on October 12, 2015 at 10:45 PM
    Can you assist me with this please.
    ...
  • Profile Image
    JotForm Support

    Answered by Welvin on October 13, 2015 at 12:55 AM

    1. Edit your form

    2. Click "Conditions" in the toolbar

     

    3. Setup your conditions:

    a. Set your Rule and click the "Add Field" button:

    b. Select the Matrix field. For example, the travel expenses matrix:

    c. Click "Show Headers" and select the options in a row that you would like to calculate except the Totals column then click "Insert" button:

     

    d.  Add + after each option. For example:

     

    d. Select the Output To Field. In this example, I have selected the same matrix which is the "Trave Expenses". You have to select the last option in the row which is the total column:

     

    That's it. Repeat the same for the other matrices.

    Thanks