We use LimeSurvey to collect monitoring data from a range of third sector/charitable organisations. The data is centred around a large number of projects, some of which will deliver services to many people and some of which to only a few.
For most of the data collection this is not a problem as we only want numbers as integers, e.g., How many participants have gone on to form friendships..., and then a number is entered.
But for postcodes we want to know how many people use a service by UK postcode area, for which we use the first part of the UK postcode - LS11, WF3, etc. and the first number of the second part, this is then followed by the number of participants from that area accessing the service, eg.:
LS11 5, 6
WF3 2, 2
To avoid a ridiculous number of subquestions, it is better that we validate a list (long free text), which then provides us with a csv.
Ideally we would also like to display the total to assist those completing the survey. As many of the projects are delivered by very small community organisations some respondents will be entering directly into the answer whilst others will copy and paste from their own spreadsheets, we want to make sure that the number of participants' postcode areas inputted is equal to the total number of participants they have worked with. We want to make it easy for people to return data to us, and running totals is a great way to help people.
Previously we asked for an excel file/csv, however, it appears that different people have wildly different ideas as to what might constitute a spreadsheet file, attachment, upload, etc.
I appreciate that this is not a trivial task and any help or pointers would be greatly appreciated. I'm not very familiar with regex - the basics, but I'm on a steep learning curve.
Thanks
Pete
The topic has been locked.