What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Client has existing excel sheet with built in prices etc. How do I make a from out of it that when submited will open up as their excel spread sheet.?

    Asked by rnauta on August 01, 2013 at 05:20 PM

    Its an exising excel form that client uses to fill out orders, it has some fileds that get filled automatically as client fills in data (which they do by phone now) they would like the form on their website to do exactly the same thing fill in information (as cost per square foot and give the total automatically) and when they receive the form it will open in excel as a excel spreadsheet with the same features.

    Is it possible??

    Screenshot
    excel prices fill
  • Profile Image
    JotForm Support

    Answered by jonathan on August 01, 2013 at 07:38 PM

    Hi,

    The calculation part will require using the form's source code. If you noticed already there is no field/s in the form that do computations/calculations except the payment fields which only do totals.

    How-to-get-your-Form-Source-Code

     

    What I can suggest you do for now is to finalize your form template (make it at least look similar to your Excel form) and we will assist you later in creating the calculation fields

     

    "...and when they receive the form it will open in excel as a excel spreadsheet.."

    You can actually create Excel Report out of the form's submission data.

    See this guide Generate-Excel-Report

    Please update us when you have your form ready and we will attend to you at once.

    Thanks.