I have a large spreadsheet. It has 3000+ rows and 50 columns. Each of the 3000 rows is potentially a Joomla document with data being presented in tabular/form format and the 50 columns being row labels in that document.
I also need people to be able to search/filter as they would in a spreadsheet. What I envision is users being able to bring up a form, fill in some data for fields they are interested in (with boolean logic) and have Joomla present a list of documents that meet those requirements.
For example, if some of the fields are Author, Date Published, Key Signature, Time Signature, Shape, then I would like to be able to do searches like:
Author = Colin*
Date Published < 1900
(Key signature = D or G ) and Time Signature =6/8
Shape = Square or Round
Shape NOT= Square
I have looked all over the extensions directory but have not seen anything that could do this. I am using Joomla 2.5.3. Would K2, perhaps with extensions, be able to help me achieve this, including ways of getting the data from the spreadsheet into Joomla?
I also need people to be able to search/filter as they would in a spreadsheet. What I envision is users being able to bring up a form, fill in some data for fields they are interested in (with boolean logic) and have Joomla present a list of documents that meet those requirements.
For example, if some of the fields are Author, Date Published, Key Signature, Time Signature, Shape, then I would like to be able to do searches like:
Author = Colin*
Date Published < 1900
(Key signature = D or G ) and Time Signature =6/8
Shape = Square or Round
Shape NOT= Square
I have looked all over the extensions directory but have not seen anything that could do this. I am using Joomla 2.5.3. Would K2, perhaps with extensions, be able to help me achieve this, including ways of getting the data from the spreadsheet into Joomla?
ALIJUTT