Is there a way to use an external matrix file with numbers to use as input with the " Calculation" widget or some alternative.

  • Profile Image
    winnie_jo
    Asked on April 23, 2018 at 03:01 PM

    Hello is there a way to use an external matrix file with numbers to use as

    input with the " Calculation" widget or some alternative.



    This is a re-post of a comment on How to Insert Text or Calculation into a Field Using Conditional Logic

  • Profile Image
    BDAVID
    Answered on April 23, 2018 at 04:37 PM

    You can perform calculations with values obtained from an Input Table(matrix) field, please check this guide: https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field 

  • Profile Image
    gizem
    Answered on April 24, 2018 at 08:11 AM

    I do not think this is possible. You can set conditions for the output fields or you can use the form calculation widget. But, you can not pass values to conditions/calculation widget from the spreadsheet.

    I can suggest you set the Update Calculate Field condition/Form Calculation widget according to your spreadsheet.

    Smart Forms Using Conditional Logic

    How to Insert Text or Calculation into a Field Using Conditional Logic

    How to Perform Form Calculation Using a Widget

    Give it a try. If you encounter any problems, feel free to contact us. We will be glad to help.

  • Profile Image
    david
    Answered on April 26, 2018 at 02:26 PM

    It is not possible to use an external sheet in conjunction with the form in order to produce calculation values.  There would be no way to connect the sheet to the form.  The closest thing we have that allows for an external document to interact with the form would be our submissions to spreadsheet widget:

    https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    But that only uses data from the sheet to populate form fields. 

    For your purposes, it would require using the tools available in the form.  Setting up the calculations and such in an input table within the form, rather than in an external document would be the only option.

  • Profile Image
    BDAVID
    Answered on April 26, 2018 at 04:58 PM

    It is still not clear to me what you are trying to accomplish, have you started to work in a form? Can you share the link, so we can take a look?

    It seems like you were looking to perform calculations in a spreadsheet, you may try the Spreadsheet widget: https://widgets.jotform.com/widget/spreadsheet 

    1524776194spreadsheet.png

  • Profile Image
    BDAVID
    Answered on April 26, 2018 at 06:46 PM

    Please check if this is what you mean: https://form.jotform.co/80917253126859 

    1524782727form.gif

  • Profile Image
    winnie_jo
    Answered on April 26, 2018 at 07:04 PM

    Ok Bdavid ! But I need the set up without the table matrix. Because there are sometimes more the 50 items in the top row and first columns a table becomes then to large for the window

    A good solution would be to let user have to fill in 2 blank fields to get result for field 3.

     

    like this example.

                              1524783549exmple layout.png



  • Profile Image
    Kevin_G
    Answered on April 26, 2018 at 09:17 PM

    You can achieve what you shown on your screenshot, you can have two fields and perform the calculation in a third field that can be a Form Calculation widget. 

    On this guide you will find everything related to form calculations: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget 

    Thanks. 

  • Profile Image
    winnie_jo
    Answered on April 27, 2018 at 04:07 AM

    Kevin I dont think so after reading your link. How would you integrate and convert this spreadsheet data beneath into a formula as screen shot below.

    Glass prices:

            100  200  300   400    500    width cm(top row)

    100    11    23    35    46      57          prices

    200    21    33    45    56      67          prices

    300    31    43    55    68      78          prices

    400    41    53    65    78      89          prices

    500    51    63    75    88      99          prices

    Height cm (first column)

    (As you can see in the matrix width is filled in by user as '200' see top row, height filled in by user as '300' see column left. This will give '43' as the price.

    So the whole matrix table above is the data. Is it possible to convert all the data into a formula so it can be generated into a working calculation, as the screenshot example beneath. Please dont give a link be more specific.

     

    1524815830layout.png







  • Profile Image
    Victoria_K
    Answered on April 27, 2018 at 06:38 AM

    Hello,

    I was searching for an option for you, but it seems that we do not have any currently. We do have a Spreadsheet to Form Widget to populate rows of a spreadsheet to form fields, but as I understand the range of prices you have is not very small. So, you will need to add lots of conditional statements or other calculations to automate the process. 

    If you know the formula how prices are calculated based on height and width, we could try to re-create it for the form.

    Related guide: How-to-Use-the-Spreadsheet-to-Form-Widget

    Let us know if you need further assistance.

    Thank you.