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

  • 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.

    Jotform Thread 905772 Screenshot
  • Irshad
    Replied on August 14, 2016 at 5: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.