I need to create a simple form from a spread sheet I created. Help!

  • Profile Image
    mari 
    Asked on September 04, 2017 at 02:37 PM

    Hello

    I created a simple spreadsheet to calculate some financial ratios and I would like to the user to see the input data fields in a form format and not in an spreadsheet format.

    Please help me. thanks

  • Profile Image
    Kiran
    Answered on September 04, 2017 at 03:50 PM

    In order to perform calculations on the form, you may use the Form Calculation widget. Please refer to the guide below that can help you with this.

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    You may also take a look at the spreadsheet widget that might help you with achieving your requirement.

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

    I am not sure which fields will be entered and calculated, but you can also use the Input table field on the form to perform calculations.

    https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

    Please give it a try and let us know if you need any further assistance. We will be happy to assist you further.