Can I create a form which will be printable in addition to online for data entry and export to Excel?

  • Profile Image
    Melinda  
    Asked on August 13, 2016 at 11:16 PM

    I have built an Excel workbook that generates many financial reports.  Currently, we input data in one of the worksheets.  There are a LOT of entries and calculations.  I'm looking for a solution which will enable us to print the data entry form for use in a meeting with a prospect, enable us to enter the data into the form online, then have the data exported to the Excel workbook to replace the data entry worksheet.

    Can I do that with your product?

    Thank you!

    Melinda

    P.S. I've included a screen print of the first page of the input worksheet.  This data entry worksheet has 200 rows and 19 columns.  There are 50 worksheets in the workbook.

  • Profile Image
    Irshad
    Answered on August 14, 2016 at 05:08 AM

    Yes, it is possible. 

    You can use Form Calculation Widget  for applying the calculation in your Form fields. Please check the below guide for more detail:

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

    You can also use Jotform conditional logic, for calculation and logic according to the Form field conditions. Below is the guide for more details about Jotform conditions.

    https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic

    After the completion of Form, you can export the form submissions or data in to excel. Please check the below guide for exporting form data to excel:

    https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    If you face any issue, or need further assistance, feel free to revert back.