Advice required for multi-select and list filter

[ontarget]

Hi I have a form whereby users will select from a number of options
We need to be able to filter the list based on a number of these selections e.g see all respondents who chose Limerick, Clare and Galway.
Would data capture via a multiselect dropdown or check boxes work, or would Yes/No responses be better? e.g Clare Yes/No, Galway Yes/No Cavan Yes/No

21. Please state the preferred geographic area/counties in which you would be available to mentor to a new principal

Clare
Galway
Cavan
Louth
Limerick
Mayo
Donegal
Meath
Kerry
Sligo
Monaghan
Westmeath
Cork
Leitrim
Longford
Waterford
Roscommon
Kildare
Tipperary
Laois
Kilkenny
Carlow
Cavan
Offaly
Wexford
Wicklow
Dublin City Centre
Dublin North
Dublin South
Dublin West

 

[cheesegrits]

List filtering should work with a multi-select join element to a "county" table, which is what I presume you are thinking about. Which also gives you more flexibility for any other reporting you may want to do outside of Fabrik, as it gives you a many-to-many junction table with the selections in it.

I definitely wouldn't go for a solution using individual, hard wired Yes/No elements. Use a 'county' table, and a multi-select join to it.

-- hugh

 

[ontarget]

Thanks for the advice Hugh