- skrishnaAsked on November 08, 2015 at 03:06 AM
Please see the screenshot attached. I was wondering if there was a way to hit + or ADD button in JotForm and dynamically create a set of similar fields so that users can add multiple items one below the other?
The Line# set of rows is what I want. So users would use the + to continue adding new set of 5 fields.
- JotForm SupportjonathanAnswered on November 08, 2015 at 03:37 AM
You can use widgets instead to achieve this.
You can find them here link: http://widgets.jotform.com/category/multiple_entries
Hope this help. Let us know if you need further help.
- skrishnaAnswered on November 10, 2015 at 04:14 AM
Hi Jonathan - That is very useful indeed. Works well!
One more question: Is there way to SAVE the submissions coming in in some sort of CSV or XLS automatically? I know emails are sent but any other storage possibility?
- SammyAnswered on November 10, 2015 at 05:26 AM
You can integrate you form to google spreadsheets so that the submissions are synced to it automatically as they come in.
There is also an option to export the submissions to an excel or CSV file under the form submissions section.
- skrishnaAnswered on November 10, 2015 at 06:07 AM
Thank you Sammy. I figured it out.
Final question: Is there a way to make one of the headers in the matrix a dropdown box with pre-set values?
I am using a Matrix Dynamique widget.
- skrishnaAnswered on November 11, 2015 at 01:35 AM
Hi Charlie - Thank you. This is helpful. One last question:
Can all of the fields in that matrix be made required? The problem is that if I fill up even just one column it accepts the entire widget.
- skrishnaAnswered on November 11, 2015 at 01:40 AM
Never mind. Figured it out. :)
- CharlieAnswered on November 11, 2015 at 02:51 AM
Glad to hear that you have already figured it out. I presume you are referring to the Configurable list widget? That should be possible there as mentioned in this guide.
- skrishnaAnswered on November 15, 2015 at 12:24 AM
Hi Charlie - Yes.That was the one.
LAST QUESTION : I know I know :P
This is my form now:
Is there a way I can dynamically calculate Shipping Cost by the following formula for each row?
(Qty x Unit Price) + 30% if Currency is NOT QAR ?
It would be great if the value got automatically updated in that field every time data was added. Any way to make that conditional logic work?
I have connected the results to a Google Sheet where I have written a script. But since data comes in a single cell, parsing it is becoming a bit of an issue. So was wondering if this form can do it for me instead.
- JotForm SupportKevin_GAnswered on November 15, 2015 at 11:00 AM
To assist you better, I've moved your question to this thread :
I will answer there.