Will this idea work? Should I build JotForm first or Excel/Google Spreadsheet form?

  • Profile Image
    Alan
    Asked on May 06, 2013 at 01:41 PM

    Hi,

    I was looking at shopping carts for our new e-commerce website but determined that a cart was not what we need.  Instead I think that a form that the potential customer fills out on our website (a JotForm) would be what is needed if the information that the customer fills in would then automatically or semi-automatically go into specific boxes in a spreadsheet (Excel or Google Spreadsheet).  I would then save the spreadsheet as a pdf to be emailed to our supplier for order fulfillment.  And I would send a PayPal invoice to the customer for their payment.  Once payment is received the order would be processed.  Does this sound like a workable solution?

    Would I build the JotForm first or the spreadsheet?  I would much prefer an Excel spreadsheet but I think I can make a Google Spreadsheet work.  Because the spreadsheet that I create would need to be basically a copy of our supplier's order form I would think that I would need to build the spreadsheet first... does that make sense?

    Any help you can give would be great as I am just learning this stuff....

    Thanks,

    Alan

  • Profile Image
    jonathan
    Answered on May 06, 2013 at 05:41 PM

    Hi Alan,

    Thank you for contacting us.

    I think the answer to your questions can be found from this JotForm articles.

    Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

    and How-to-Download-Form-Submissions-to-Excel-CSV-PDF

     

    When you use JotForm (http://www.jotform.com/faq/) , you can integrate it to spreadsheets or download the results as Excel or PDF report. A lot of integration can be read from this blog post http://www.jotform.com/blog/

    I hope this help. Please inform us if you have further question.

    Thanks.