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.
Purchase orders integration: Will drop all fields into a single cell when connected to google spreadsheetAsked by habitatjackson on September 27, 2012 at 02:00 PM
I want to make an order form
there is a quantity and price per each (poinsettia) $15
and a Total
Can someone tell me how to do this.?
I know how to do it with Paypal, but not just an 'order' form'
That is a start... but I have to have a quantity for each color
any idea on that?
Yes, that's possible. Please check this link on how you can customize Paypal forms.
hmm. Can I use a paypal form and NOT use paypal.
I mean I don't want to use paypal. It is just an order form, the people will send a check
Yes, this is possible with us.
Just drag and drop a Purchase Order tool to your form.
Then, you will be asked to configure that tool. From there you will be able to add the products and specify the quantity options.
If something is not clear, please let us know. We would be happy to help you.
Ok that worked pretty good now the only problem I see is the order is dropped into one cell on my google spreadsheet...it seems Paypal does that too (I made something similar with PayPal ) Red Poinsettia (Quantity: 2) White Poinsettia (Quantity: 1) Total: $45.00I need this info in separate cells is this possible?
You are correct on your observation of the purchase order field being all dropped into a single cell only when viewed on google spreadsheet. There was actually a ticket already submitted to our dev team regarding this and currently being look upon.
As a suggestion and temporary workaround-- since you do not really need a 'payment' info/data, can you instead just use individual regular fields?
A checkbox, a dropdown box fields can also be used display your product. The part that will be missing though will be the computed 'Total'. But you can see/calculate your total via google doc formula.
I will include your post on the submitted ticket post so that you will be inform of its progress too.
Thank you for using our services. Please inform us should you require further assistance.
i see this issue with one cell still exists - is this soon to be handled in the near future?
i wonder how would it be possible to map these fields in the form to salesforce as they are all named "my products" and "quantity", ie they dont have unique names.
I am opening a new ticket in order to set a higher priority to this request.
On regards to Salesforce, please open a new thread for it as this is only related to google spreadsheet integration and payment forms
This problem (payment field separation on Excel) has already been resolved a month or two ago.