Compare Functionality (Combining Two Search And Reports)

[jmcallister]

Hello,

 

My website (gradlook.org) uses Caspio to host a search engine for graduate schools as well as chat forums. I am now looking to create a compare functionality. This is essentially will just a combined table in which the user enters the names of two schools from the same table (preferably with an autocomplete feature). The results are a table with two columns (each school) and each school's fields/stats side by side. I have been working with views but haven't really been able to get anywhere.

 

Can someone point me in the right direction?

 

Thanks,

 

Joe

[LWSChad]

I would suggest using two search sets found ->>http://howto.caspio.com/tech-tips-and-articles/parameters/add-a-search-interface-to-results-sets-page/

 

Two Sets - School One & School Two (for a total of four data pages)

[aam82]

You could use a listbox to allow user to multiselect schools in a search form, and give each school a row in a tabular report of results.

 

If you have a lot of schools, you could instead use a cascading listbox based on another field that filters the list based on one of your other data points.

 

school region: northeast

schools listbox: just northeast schools

[svitlanataran]

Hi Joe,

 

As far as I remember, you can select several values (e.g. two schools) only by using list boxes. And cascading listbox is a good option.

I can recommend you using gallery report. 

You could show 2 records per page, which gives you an opportunity to compare two schools.