I created a form to allow people to register for different volunteer areas, with a drop down called "Where would you like to help?" There is a limit to how many people we could use for each of the areas in that drop down box, so I removed them from the drop down as we reached the maximum number.
At the end of the registration period, I exported the data to a .csv file but all the areas I had deleted from the dropdown showed as blank in the "Where would you like to help?" field in the .csv.
I tried rolling back to a previous revision of the form and rerunning the export but it was still not right.
Is there a way to get to the data that populates the responses page of formassembly.com and export that? That data is all there.
How far did you try to roll back your form? I think that going back to the revision that had all the options should allow you to get a complete export of the data.
Let me know if that's not working and we'll look into it further.
That's what I hoped, so I rolled it back to the one that had all the options. The problem I had then is better explained with this scenario:
I created a test form with one drop down called "option", with four choice, "one", "two", "three" and "four". I ran the form 4 times selecting "one" the first time, "two" the second, and so forth.
Then I renamed the first option in the drop down to "two" and deleted the second item (called "two" from when I set it up). Now, the responses list shows that the first response (which was previously "one") is now "two" and the second response (which was previously "two") is now blank. The third and fourth responses still show as "three" and "four". And if I do the export, it shows the responses in order as "two", "", "three", "four".
I still have the e-mails I received during the registration of the original form, so I have the info. I just need to have people go through all of the e-mails and update the excel sheet with the correct information.
Two questions:
Could you suggest a way pull items from a drop down list without screwing up the data on formassembly so it cannot be exported?
Can you see me raw data that might show the original <item> tag name without trying to map it back to the current form? Don't know if that would work.
Thanks again for your help. I need to figure this out today if at all possible.