If a user has filled out the questionnaire before, can their results appear automatically on the form?

  • springboardcharity
    Asked on August 30, 2017 at 9:22 AM

    We have a form which is rolled out annual and need people to sign up each year.

    However, if they have already filled out the same form, can their inputs be automatically generated to ensure they are the same as before without the users inputing the fields manually?

  • Kiran Support Team Lead
    Replied on August 30, 2017 at 11:05 AM

    Do you mean to search for the user information from the submissions to display on the form again? If you already have the user information with you in an Excel sheet, you may consider using Spreadsheet to Form Widget with the form so that the information can be pulled from the spreadsheet based on the unique field entered on the form. You may go through the guide below that can help you with using this widget on the form.

    https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Let us know if you are referring something different. We will be happy to assist you further.  

  • springboardcharity
    Replied on September 1, 2017 at 7:43 AM

    Thank you for replying. 

    I think that is what I need. However, would there be any data protection issues/problems which we need to consider because anyone who fills out the form can see the data entered by someone else? Such as email addresses, addresses etc which are all private details.

    Thanks in advance. 

  • Jan
    Replied on September 1, 2017 at 10:26 AM

    You need to provide a unique code for each user. In this way, they will not be able to populate the data of other users. In the example below, the unique codes are unique1, unique2, unique3 and so on.

    If a user has filled out the questionnaire before, can their results appear automatically on the form? Image 1 Screenshot 30

    In this demo form, the image and the unique code are provided for testing purposes only. It means that you should not include this information in the actual form.

    If a user has filled out the questionnaire before, can their results appear automatically on the form? Image 2 Screenshot 41

    Hope that helps. Thank you.