Help with form for data entry
I have tried searching on this, but I guess I don't know the keywords to use, so I haven't found anything.
I'm trying to make a form for entering data from a survey. I want to make it as easy as possible for those entering the data. However, I also want the data to be in a format I can use when I analyze it with statistical software. That is where I'm having my problems.
I want the actual data to be numeric. So for example, I want 1=blue, 2=red, 3=green. On the paper forms the people entering the data have, they show the blue, red and green. But I want the data to be 1,2,3. Is there a way to do this easily?
I know I could have them enter the numbers, but I want to minimize errors.