Forums

Hi,

How do I tell ChronoConnectivity to show distinct entries only?

Ideally this is what I want to do...

- I have a database table with year, quarter, username, and filename fields.
- user submits the file (filename) and assign the file is belong to what year and what quarter.
- it will be like user1, year 2007, quarter 3 has submitted those 6 files, etc.

I want to use ChronoConnectivity to display the result based on the query request:

- a "year" dropdown by going through the field "year", and find distinct entries to populate the dropdown list.
- If user choose "2008", it finds all distinct "quarter" in year 2008 and then auto populate the "quarter" dropdown list.
- If user choose "Q3", it finds all distinct "username" in year 2008, Q3 and then auto populate the "username" dropdown list.
- then, press submit, and it then list out all files in a table format that meet the query requirements.

Please help, thank you.

Hi batmon,

I'm not a ChronoConnectivity expert but I think you can do most of this with two drop-downs for year and quarter - you already know what quarters there can be. The tricky bit is getting the student list for the selected quarter. Either a second form or an AJAX look-up will probably be needed to get this.

Bob