- austinymcastrategicplanAsked on February 07, 2014 at 04:53 PM
I have written a form that I want to embed in my google site for different employees to fill out for their different projects. I use the information as a way to gauge how we are conforming to our board strategic plan.
I want to be able to provide a way for the employee to go back into a form they have already submitted and update the information so that it reflects not only what they were planning, but what actually happened. The questions are structured in such a way that this information can be captured. This update would only update one line of the spreadsheet that the form is connected to.
I have tried using several of the suggestions in other answers on the forum, but I am not a programmer and I don't know if I picked the right questions, or if google sites just doesn't like the code that was suggested.
I have set up one form in a test site and I have included that information below
- KadeJMAnswered on February 07, 2014 at 05:49 PM
Okay, I see where you're going with this. You can embed your form on a Google Site as far as I know. Have you tried embedding it via our guide here https://www.jotform.com/help/19-Adding-Form-to-Google-Sites? You can also make it so that your employees would have access to the form to edit and update it via an Edit Link inside your Email Notifications or Autoresponders depending on how you have it set up.
Now as for the Google Spreadsheet problem unfortunately I don't know of this being possible to send just one column of data to update a section of it after someone edits and updates their submission via your form. The problem happens because of the way google is designed to receive the data along with the fact that our form is designed a copy of it to the spreadsheet as well.
Even if we built a feature to filter it google spreadsheets still treats it as a new submission when received so this would just continue on down your spreadsheet list and you would have lots of holes in it. This is why I don't think it would work and I don't really know of a way to fix that. I will have to discuss this more with our developers.
A way to work around that however though would be to have a secondary form embedded on your main form for updates. The form would collect the updates via a secondary spreadsheet though it's a little more work to compare them. You could then manually merge them as needed also.
- austinymcastrategicplanAnswered on February 07, 2014 at 06:20 PMThank you for the information. I found the
http://www.jotform.com/help/19-Adding-Form-to-Google-Sites and have worked
with it to provide a confirmation email with an email link. I think I have
solved my problem by listing the employees authorized to fill out the form
in a drop box and conditionally sending an email based on their selection,
rather than having them fill in their own name.
Thank you for the quick response. I have been very pleased with jotform so
far. I have been working with Google forms for 3 months and have solved
all my problems in 4 hours today with jotform.
- JotForm SupportjonathanAnswered on February 07, 2014 at 06:27 PM
We are glad to know of your satisfaction with our service. On behalf of our colleague KadeJM you're quite welcome.
Thank you very much also for the warm appreciation.
Do not hesitate to contact us again anytime for any other assistance you need with JotForm forms.