2. PHPRunner General questions
  3. Sorting a field based on conditions in other fields
This topic is locked

Sorting a field based on conditions in other fields

 		7/7/2006 8:35:50 AM
PHPRunner General questions
T
 TerryB author

Hi,
I want to display a list of available tutors in a new students record as it is being entered. Basically there are four conditions I need to check for depending on what the student asks for:

  1. Availabilty
  2. Sex of tutor
  3. Area
  4. Whether the tutor is currently taking students



So as I enter the students details the list of tutors in the Tutor Allocated field gets narrowed down.
Is there and wasy way to do this please?
Thanks
J
 		Jane 7/7/2006

Terry,
unfortunately there is no easy way to do it with PHPRunner.
We plan to add something like this in one of the new PHPRunner version.
adamdidthis 7/7/2006

Couldn't you just use the advanced search section for this?
T
 		TerryB author 7/7/2006

I ddi think about using the advanced search but as these are bookings taken over a telephone and time is of the essence I decided that trying to sort them this way would be quicker. By the time they reach the Tutor Allocation field it would have (I hoped) filtered the tutors down to just a few rather than the list of 70+ I have at present...
The other way I suppose is to have the Advanced Search open in a _blank window and have that there semi-permenantly but that seems like such a crappy way to do this <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=9703&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
This in turn leads me to the conclusion that I need to write a table that just deals with tutor availability based on a limited number of fields - it just seems the work never ends!
But thanks for the suggestion Adam
kujox 7/9/2006

Try this
table filter
I had a problem on another site and this solved it, make sure you tell phprunner to display as many records as you have in the table, IE don't split over 2 pages or it wont work.
this one filters as you type but the link doesn't seem to be there and it only works on one field at a time.
http://www.vonloesch.de/node/23