Table Style Order form

  • Kyle Pitsenbarger
    Asked on May 9, 2019 at 2:20 PM

    Hello! I have a client that has requested to move the attached order form over to a digital version. 

    I would like to have something embedded in their website. I have been searching and searching for a solution, and I think your forms may work! 

    The "Cases" field needs to be the only fillable field in the table. I have experimented with your forms and have something that would work, but isn't the most ideal. I was wondering if I could get your expert advice and if you think your forms are capable of this. 

    Thanks so much guys! I also attached a screen shot of something I did with your form that is okay, but not exactly what we need. 


    Kyle 

    Jotform Thread 1818587 Screenshot
  • Mike_G JotForm Support
    Replied on May 9, 2019 at 4:49 PM

    I believe what you are trying to achieve is possible with the help of the Spreadsheet widget.

    The widget has the option to set a default value to each cell and it also has the option to set each cell as "read-only".

    You may, however, need to inject Custom CSS codes into the widget to merge rows or make cell appear as merged.

    I suggest that you give the Spreadsheet widget a try and feel free to let us know if you need any further assistance.

    How-to-Add-a-Widget-to-your-Form

  • 1922creative
    Replied on May 23, 2019 at 1:43 PM
    Hello!
    I am really having some trouble with getting my excel sheet into the Jot
    Form. This should be pretty simple, but it's not. Can someone assist me
    with the first row and how to set it up? I have read all instructions but
    cant seem to figure it out.
    Thanks,
    Kyle
    ...
  • denis_calin Jotform Support
    Replied on May 23, 2019 at 3:00 PM

    Hi Kyle!

    I have created a sample for for you:

    Form: https://form.jotform.com/91425786090967

    Please clone it to use it or to see how I have set up the Spreadsheet widget and modify it to your liking.

    Guide: How-to-Clone-an-Existing-Form-from-a-URL

  • 1922creative
    Replied on May 23, 2019 at 3:43 PM
    This is so great, I was totally over thinking it. One more question then I
    will stop bothering you.. Lol. Is is possible when the user clicks "Sumbit"
    that we can just have the submission sent to an email of choice VS going
    into the actual jotform website/backend?
    Thanks!
    Kyle
    ...
  • denis_calin Jotform Support
    Replied on May 23, 2019 at 5:08 PM

    :)

    Yes, it is possible! They are called notification/autoresponder emails. The Notification email sends an email with the submission data to your (or any other one you specify) email address once the form is submitted. The Autoresponder email sends an email to the person who filled out the form, provided they left their email address somewhere on the form.

    Please follow this quick guide for more info on how to set up notification emails: Setting-up-Email-Notifications. Let me know if you have any questions.

  • 1922creative
    Replied on August 9, 2019 at 1:58 AM
    Hello! Thank you for all the help. The form is 99% complete. The client
    really likes it. I do have a question though. Can the reciever of the form,
    have the option to print as a PDF? Right now the only way I see for
    printing is to print the whole Gmail form message, which also prints the
    headers and footers of gmail and takes up a lot of space on a standard
    sheet of paper. I would like the end result to have a better print option
    for that. Any ideas? I am trying to avoid my user having to copy the form
    and having to select "Print Selection" in print options. I want it to be an
    easy process of receiving the form and being able to print it.
    Thanks!
    Kyle
    ...
  • jherwin
    Replied on August 9, 2019 at 3:19 AM

    Hello Kyle - How about including PDF document to the autoresponder? That way, they'll receive a copy of their submissions or the data you want to send them as a PDF.

    Guide: 

    How-to-include-submissions-as-PDF-attachment-in-the-email-notifications

    How-to-Customize-PDF-Submissions-Report

    Let us know if that could work for you.