- belmontjotAsked on January 17, 2017 at 10:30 AM
We would like to collect demographic information on a form. The form itself contains an email and information about the person. Is there a way to have one of the questions on the form submitted anonymously and that information be stored in another spreadsheet?
- JotForm SupportJim_RAnswered on January 17, 2017 at 11:58 AM
If your aim is demographic info, then there's already one by default. It's called Form Analytics https://www.jotform.com/form-analytics/
Complete guide: Introducing-Form-Analytics
I'm not sure what the end-goal would be by storing it on another spreadsheet. I assume you want a specific field on your form to be submitted and you don't want to know who submitted which.
If my assumption was correct, you can try using either the CSV or Excel Report.
Basically, you'd generate a report and purposely EXCLUDE the fields that will cause you to lose the anonymity of the submission (e.g. the name of the respondent, his email, etc.). So, while generating the report, just untick those fields so they are not included on the sheet that will be generated.
In case we misunderstood your question, just get back to us with a bit more info and a clearer description of what you're trying to do so we can better assist you.
- belmontjotAnswered on January 17, 2017 at 12:27 PM
The report would give us the information we need. I'll give that a try too.
However, what we were trying to do was create the form so that the person filling it out would feel that they were submitting that portion anonymously.
I think we figured out a solution - let me know what you think:
We created 2 forms. One with the standard information we need for registration and billing and then when they click the submit button it redirects to the demographics form which only has the gender and race. We'll have 2 different submissions and unless they click on IP address, they won't see who submitted the 2nd form.
- JotForm SupportBDAVIDAnswered on January 17, 2017 at 01:54 PM
You could apply that solution. You can redirect to the second form after submitting the first one, here is how: https://www.jotform.com/help/38-Redirecting-Users-to-a-Different-Page
Just add the second's form URL in the "Redirect to External Link" area of your first form:
Let us know if you need more help.
- belmontjotAnswered on January 17, 2017 at 02:25 PM
That works for us! Thank you!
- JotForm SupportJim_RAnswered on January 17, 2017 at 03:35 PM
I'm glad that solution fits your requirements. In case you need more help, don't hesitate to post a new question anytime.