JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
How to update data in 2 places?Asked by ellie123 on June 29, 2014 at 07:26 PM
Hello - I need some help, I've tried several different things and can't quite get any of them to work all the way. Here is what I want to accomplish:
1. A user will complete a form, upon submission - their responses will be displayed on their page on my website. (I already have the system setup where the user creates their own page.)
2. They should have the ability to go back and edit the form and update their responses.
3. Anyone who logs on to their page will see their form replies
4. When the user updates their form, their responses are updated also.
So, I figured out how to save the form submissions to MySQL database...I have them in there. But, I don't know what to do next.
1. When I pull the form up, the user's responses are not showing up - the form goes back to it's default state
2. How can I let them edit the form? (I did create the one form where they login with name/email first, so I may just need them to start with this first?)
If you can please tell me how I can show the user's answers - or if this is even possible, I'd greatly appreciate the help.
P.S. Here is my form: http://form.jotform.us/form/41686264528160
Please refer to my numbered answers below:
1.) Not sure what you meant by "when you pull the form" -- did you meant the form http://www.jotform.us/form/41686264528160 have no submission data when you check in the form's submissions page?
I checked the submission of this form, and I see existing submissions
Please clarify to us what was it you meant. If you can describe to us the steps to take, we will check again.
2.) You can use the Edit Link to let the form users edit the form data even after it had been submitted already.
Check this user guide:
3. You can share and show to the users the answers to the form by simply creating a Report.
You can check several method to share and create report on this JotForm Reports Guide
Hope this help. Inform us if you need further assistance.
Once the user fills out the form I want their answers to show on my website. So, how can I show the the form with their answers?
Then, how can I let them edit their answers?
The report doesn't work because everybody can see everyone else's data...I need to show one form per page and then just allow access to that page to the user.
Does that explain better?
Like I said, I have been able to setup the form and connect it to my database and my responses are being saved there. (I have made several forms so maybe this one in particular is not THE one...I might have given the wrong form.)
But, what I want to achieve is to have the form show on my site, have the user fill out the form, have their responses show on the form and stay on the form until they edit them.
Hopefully that explains better? I was thinking maybe the WebHooks would work, but I have no idea HOW I would set this up or do this??? Is there a step by step guide for the webhooks yet?
I followed the instructions for Send Post Data (where you guys posted instructions for Form 1 and Form 2 to post data to another form or website but I can't get it to work.)
Here is a screenshot of my database so you can see that it IS working....
Please let me know if this correctly sums up the workflow you want to achieve
- You have specific pages for each user
- On these pages, the form is embedded
- After the form is submitted, you want the page for the specific user to show their form response, not the empty form
- On this page will be an option to edit the form response
I'll look forward to your answer.
YES! that is EXACTLY what I need to do....can you help me do this? (Please don't say it can't be done)
BTW - I posted the wrong form url above...THIS is the form that is saving form responses to my database:
Here it is embedded on a page my site: http://siteformybiz.com/mysterydiner/diner-form/
What you need is very much doable. Let me create a demo website for you to show this.
I will get back to you as soon as I can.
Please test submit the form on this demo website.
Tell us if the concept is at par to what you need or not...
In the demo website, I created the Report Viewer where the user can view the submission report using this guide -How-to-create-an-HTML-Table-Listing-Report
The user can edit the latest submission using the Edit Link below the report viewer.
The edit link was created using this guide -How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date
We will wait for your updated response.
Hi there - thanks for your help....almost, so close...problem is, I can still see other ppl responses.
There is going to be about 1000+ people using this, so it would take forever for someone to try to go through and find their responses. Plus, I really don't want them to see anybody else's data.
Can I make it so the user can only see their responses?
In other words, can we make it so the user does not see all the other ppl that filled out the form.
Is there a way we can make it so only their replies show and they can edit only their replies?
Also....One more question.....I have users uploading an image, and when it gets stored in my db it is only storing the image name. How can I find the FULL PATH to that image instead of just the name of it? This is pretty important...can you help me wit this? I see the image on the report, so I know it's there, and when I look in my db it just shows the image name. But, I need the actual full http:// path to the image...
Can you tell me how I can have it store the full url path instead? (I know I kind of switched paths here, but this is important too...my image isn't showing on my site because I don't know the path....).
Also....Can you show me how you added the "edit form link" to the Table Report?
Unfortunately, it is not possible to display only one user's submission in a report. There is no way to customize the reports and it will always display all the submission records you have received in your form.
Since you want your users to be able to edit their submission records from your web page, you will have to save the edit link in order for your users to be able to edit it. Please be noted that you can build your edit link yourself and here is the format of edit link:
You need to replace the form ID with the id of your from and also the submission id of the user's response.
Do get back to us if you have any questions.
As we cannot answer multiple questions in one thread, I have moved your question related to image path in a new thread. You will be answered in the following thread: http://www.jotform.com/answers/397801