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 collect new and update existing alumni information collected through a formAsked by Kara on October 26, 2016 at 01:09 AM
We are trying to put together a database of alumni from our school. We have a bunch of info already in an Excel sheet so what we would like to do is have a form for people to fill in and if their name is already in our database, along with address, etc. we want it to display the info we have on file and allow them to then simply make corrections where needed.
Is this at all possible?
Thanks for your help!
When you have created your JotForm form, you can easily import your existing data into the form's submissions by using our Import app:
However, it might be a little trickier to show them their existing data so they can update it. Does your existing data contain their email addresses?
If so, it would be possible to import submissions, and then send each of them an email containing the edit link for their (imported) submission data. So the people with existing data could update their data from the links in their email, and the rest would simply submit new submissions on your form.