- MarionTAsked on April 20, 2014 at 10:19 AM
I am hoping to use JotForm for collecting data from 40 employees. It works fine out-of-the-box, but my use-case has a requirement that I can't wrap my head around.
Easily, I can make a form, send it to the designated 40 employees, see that 23 of them have answered - but I cannot easily see who has not answered.
I can think of possible solutions, but I'm sure there is a better way:
1. Assign each person an ID#, which is the answer to the first question. Once they put in their ID number, they are directed to questions which are proprietary to them. This soves the problem, but is clumsy as I'll end up with the data in one very wide row in my spreadsheet (which I'll then have to manipulate to use, as I need the end result to have employee names down the left, and answers to the right of each name)
2. Pre-populate each employee's name in 40 rows for the form. Great, but I don't know how to restrict each employee to only filling in their specific row of answers.
3. Duplicate the form 40 times; one form for John, one for Mary, etc. I publish John's form directly to John, and Mary's form directly to Mary. The problem with this is that I end up with 40 separate xls files that have to be compiled.
How would you solve this?
- JotForm SupportjonathanAnswered on April 20, 2014 at 11:01 AM
I propose trying the technique described on this guide
If you check this guide, you will noticed that it is using 2 forms at the least and an e-mail session.
Here is a demo form you can try.
My idea goes like this.
1. Using the 1st form, you will have an initial data(name, e-mail.. so on) of the user/employee who WILL ATTEMPT to submit or fill the main form.
2. If there is NO RESULT/SUBMISSION on the 2nd form, you will then be able to, by process of deduction, find out who did NOT FILLED the form.
Hope this help. Please tell us your thought on this.