2. PHPRunner General questions
  3. A tricky One!!!
This topic is locked

A tricky One!!!

 		7/31/2009 11:00:17 AM
PHPRunner General questions
S
 swanside author

Hello.

On my database In a table called job I have a field which is linked to JobType. The job type could be DTD or Boiler Service, or AC Service.
I have three custom views, DTD, Boiler Service and AC Service. Each one has different fields to show different information depending on what view is called.
To access these fields, we go to one of the links on the left hand side of the job_list page, but as more of the custom views are coming online, the job list page is getting wider all the time.
On the job list page I have a field called Job_Type. This displays DTD or Boiler Service or AC Service, depending on what was chosen at the time of adding the job.
What I would like to be able to do is just click on the item in the Job Type field on the job_list page so if it says DTD it will take me to the DTD_list page, or if it says Boiler Service, It will take me to the Boiler_Service_List page and so one. Can this be done?

Thanks

paul
S
 		Shankar 8/1/2009

Hello.

On my database In a table called job I have a field which is linked to JobType. The job type could be DTD or Boiler Service, or AC Service.
I have three custom views, DTD, Boiler Service and AC Service. Each one has different fields to show different information depending on what view is called.
To access these fields, we go to one of the links on the left hand side of the job_list page, but as more of the custom views are coming online, the job list page is getting wider all the time.
On the job list page I have a field called Job_Type. This displays DTD or Boiler Service or AC Service, depending on what was chosen at the time of adding the job.
What I would like to be able to do is just click on the item in the Job Type field on the job_list page so if it says DTD it will take me to the DTD_list page, or if it says Boiler Service, It will take me to the Boiler_Service_List page and so one. Can this be done?

Thanks

paul


I think you want to make the items "clickable" to their details - I haven't found a way of doing this.

But you could set-up master-detail links (in the table menu) which automatically makes links to the details - it's not pretty but it works.
Shakar
S
 		swanside author 8/2/2009

Thanks for the idea, but I have about 20 of these now, so there would be 20 links over the list page.
Thanks

Paul
F
 		FreddieM 8/2/2009

Couldnt you do something like the following in the View As > Custom section of the job type field on the joblist page.

If ($value=="Boiler Service"){

$value="<a href=\"boilerservice_list.php\">$value</a>";
}
If ($value=="DTD"){
$value="<a href=\"dtd_list.php\">$value</a>";
}
If ($value=="AC Service"){
$value="<a href=\"acservice_list.php\">$value</a>";
}