-
MelindaAsked 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.
-
IrshadReplied 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.