Table Style Order form

  • Profile Image
    Kyle Pitsenbarger 
    Asked on May 09, 2019 at 02: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 

    Screenshot
  • Profile Image
    Mike_G
    Answered on May 09, 2019 at 04: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

  • Profile Image
    1922creative
    Answered on May 23, 2019 at 01: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
    ...
  • Profile Image
    denis_calin
    Answered on May 23, 2019 at 03: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

  • Profile Image
    1922creative
    Answered on May 23, 2019 at 03: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
    ...
  • Profile Image
    denis_calin
    Answered on May 23, 2019 at 05: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.

  • Profile Image
    1922creative
    Answered on August 09, 2019 at 01: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
    ...
  • Profile Image
    jherwin
    Answered on August 09, 2019 at 03: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.