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.


  • Profile Image

    How can I preload data from a database into the Jotform form

    Asked by MiklosCCI on August 01, 2016 at 07:21 AM

    Hello,

    I would like to link my database (Excel), then fill the Jotform form with data from my Excel database, letting the possibility for my customer to correct some of these data in the form.

    Please tell me, how can I link my form with such data set.

    Thanks

    Miklos

    JotForm how how can i excel database
  • Profile Image
    JotForm Support

    Answered by Charlie on August 01, 2016 at 09:40 AM

    I am not sure how your process flow works. An excel file is a separate file in a local storage. There's no way for a form submission to directly interact or update an existing Excel file.

    However, we do have some apps and integration that might help. 

    Option #1: You can integrate your form to Google Spreadsheet, that allows you to have an online spreadsheet where the submissions will directly be saved, you can also allow your users to edit their submission which will also reflect on the online spreadsheet. 

     

    Option #2: You can use this app ReportsToCloud, that should allow you to receive an updated excel file o your submissions on your Dropbox folder.

     

    To learn more about JotForm's other reports creation, you can check this guide link: https://www.jotform.com/help/326-How-To-Create-Form-Reports-in-JotForm 

     

    I hope that helps.

  • Profile Image
    JotForm Support

    Answered by Charlie on August 01, 2016 at 09:43 AM

    On a different note, if you would like to import your existing data to JotForm, then you can try checking this guide: https://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm 

  • Profile Image

    Answered by MiklosCCI on August 02, 2016 at 01:18 AM

    Thank you Charlie,

    I succeded importing the list as a submission list. I wonder how could I show the submission to each respondent of their submission, then let them to modify it.

    The flow is the following: I have some contact details, and I want to know more about the respondents opinion and to let them modify their contact details. This means the form should show, based on the email address where the form is shown, the contact details of the specific respondent.

  • Profile Image

    Answered by MiklosCCI on August 02, 2016 at 02:36 AM

    And of course, our respondent should see only their own pre-populated form, and be able to modify only their own pre-populated form.

    Their feedback, data modification should registrate in my submission database

  • Profile Image
    JotForm Support

    Answered by beril on August 02, 2016 at 04:56 AM

    If you want to let your users to  modify your form after submission. It is possible with {edit_link} function. Please, check the guide below for more information:

    https://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date

     

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.

  • Profile Image

    Answered by MiklosCCI on August 02, 2016 at 05:01 AM

    Thank you Beril,

    In the form what the receiver get will contain many details about him, what I already have, and I want to be in the form. But I also want to let the receiver to update his details (address, phone, etc.).

    I don't want my receivers to modify the form, but only the submission details.

    And one user only his information, not all submission

  • Profile Image

    Answered by MiklosCCI on August 02, 2016 at 05:47 AM

    More details: Let say I am A. A wants to send a form to B, C, ... X.

    A wants to include in the form some text input and some check boxes.

    In the form A wants to tell B that I have some info about B (address, phone, email etc.). B should be able to change address of B. Then A wants to let B to submit these information.

    C will see the contact details about C, but C will not change anything, but will submit some check boxes. A also want this information to collect in a database, in the same database where B and C had submitted their information.

    C and B will not be able to see each other information.

  • Profile Image
    JotForm Support

    Answered by beril on August 02, 2016 at 09:01 AM

    I am not sure that I understand your workflow correctly. As far as I understand from your thread, you want to allow users to edit selected Data only in their responses while they are modifying form after submission, unfortunately, it is not possible with Jotform. However, I will search your request and if I find a solution for you I will update you from this thread.

  • Profile Image

    Answered by MiklosCCI on August 02, 2016 at 09:09 AM

    Many thanks Beril,

    I don't want to let anyone to modify the form. I want respondents of the form to see some information what they can sometimes to modify. All submitted data, and the modification should arrive in that submission database. Also I am talking about 10-15 fields contact database. This is why I don't want to put my respondents to answer by typing in these information, as I already have data from a previous year.

  • Profile Image
    JotForm Support

    Answered by beril on August 02, 2016 at 11:21 AM

    Hello Miklos,

    If I caused the confusion I am sorry for that. When you create a form in JotForm , your users are able to edit their submissions with {edit-link} function so your customers will able to edit their submission's data by the help of the following guide:

    https://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date

    Please note that your users can not modify your form. However, they can update their submissions on their end. To do this you need to create an auto-responder.

    After they receive the response, they can edit the submissions data as you see below:

    Please clone the demo form and test it on your side. If it complies with your request, please do let us know. We can assist you to step by step.

  • Profile Image

    Answered by MiklosCCI on August 03, 2016 at 01:17 AM

    Hello Beril,

    Thank you for all information. No, you didn't caused any confusion.

    I will try to work with this, and if I have any question here, I'll be back.

  • Profile Image
    JotForm Support

    Answered by Charlie on August 03, 2016 at 02:28 AM

    We're glad that the information we shared somehow helped. If you need any assistance again, please do feel free to open a new thread here in the forum.

    Thank you.