-
Kyle PitsenbargerAsked 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
-
Mike_G JotForm SupportReplied 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.
-
1922creativeReplied on May 23, 2019 at 1:43 PMHello!
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 SupportReplied 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.
-
1922creativeReplied on May 23, 2019 at 3:43 PMThis 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 SupportReplied 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.
-
1922creativeReplied on August 9, 2019 at 1:58 AMHello! 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
... -
jherwinReplied 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.