I recognise this post is highly ironic in light of yesterday’s remarks about my not being able to use a spreadsheet in parody of Apple’s Mac/PC ads, but, please, let it slide.
So all I want is an enum field. Or a multiple choice box, easy to get in Excel.
Neither of these are available at time of writing. The term “enum” has only been mentioned on any OO.o mailing lists pertaining to Base nine times, ever. And it supposedly connects to a MySQL server. Yeah, right.
I guess it’s back to rapid prototyping of a web interface to deal with data entry, or using Excel/Access… sigh. This was meant to be the quick and easy (and open source) solution.
posted on Thursday, December 7th, 2006 at 11:14 am by Josh, filed under Open Source.
try this link:
http://www.openofficetips.com/blog/archives/2006/01/data_validation_2.html
Excel can do a type of enum.
Looks awesome. Wish I’d seen that when Googling around last week :P I ended up just setting up an open-source survey app and using that to process data. Worked a treat, I don’t really know how it was doing it though (and, by that stage, didn’t care to find out either… if it looked like it worked, that was enough for me!)
I was using it for a survey I ran at a youth ministry conference last week (Luke was there, which may be why you found this post?) and published results on the CYIADA project blog. Quite interesting stuff… it’s not a very large data sample, but it is fairly high quality.