2. PHPRunner General questions
  3. Tree/Dropdown
This topic is locked

Tree/Dropdown

 		3/5/2007 11:38:39 AM
PHPRunner General questions
B
 Bikerman author

I have a feeling the answer to this is no but I'll ask anyway.

The particular project I'm working on is a list of science stories on the web. The main table is updated weekly and has a lookup field which joins to another table containing a master list of science disciplines (physics, biology etc). What I need the user to be able to do is select (say) Physics on the screen and for that then to list all the physics entries in the main table. I can't see a way to do this and I suspect I am asking for something impossible, but I have to ask :-)
D
 		Dale 3/5/2007

Good News,

Nothing is impossible. It's amazing what PHPRunner can do for you.
I used a more complicated method, by embedding a piece of the Advanced search on my list pages.
I have an application that displays Construction projects(science stories) and they are linked to Project types( Science disciplines), ie New Project, Updated Project etc.
So when a user logs into the projects list, phprunner builds the tabs for the Project types( Science disciplines) accross the top of the list section, the user can select to display the correct records(science stories) in the list below.
It works great, for printing, exporting searching and all that good stuff.
With this advanced search snippet, you can add Project Types( Science disciplines ) any time and they just automatically show up with the new tabs on the list page.
Bad News,

As I mentioned, it is quite a complicated process. I have embedded javascript to control which tabs are active, I have modified the functions template to accommodate the advanced search snippet on the list page. And creating some session variables to hold the info that needs to be passed back and forth to other pages.
I would be happy to share, but as always I am sure support will have an easier answer to implement your wishes.

I am also using the older version 3.0 and I have no idea where one would apply the snippets and the changes you need to make if you are using the 3.1 version. I plan to upgrade once I have my latest project completed.
My whole point here, it can be done. If you are on the old version, drop me an email and I will be happy to share the process.
Here's a screenshot of what PHPRunner produces for me demontrating how I use the tabs at the top of my lists.
T
 		thesofa 3/6/2007

I have a feeling the answer to this is no but I'll ask anyway.

The particular project I'm working on is a list of science stories on the web. The main table is updated weekly and has a lookup field which joins to another table containing a master list of science disciplines (physics, biology etc). What I need the user to be able to do is select (say) Physics on the screen and for that then to list all the physics entries in the main table. I can't see a way to do this and I suspect I am asking for something impossible, but I have to ask :-)



If you made the login for the database to be the type of science, I.E. Physics, Chemistry etc

Then use the security to just show the entries for the logged in user.When adding new entries, make the owner field in PHPR the field that holds the science type.

It might work OK, but you would have to logout of one science type and log into another to change science type, whereas DaleM's version allows fast switching

If I have not made myself clear, get back to me and I will try to set up an example of what I mean

HTH
B
 		Bikerman author 3/6/2007

If you made the login for the database to be the type of science, I.E. Physics, Chemistry etc

Then use the security to just show the entries for the logged in user.When adding new entries, make the owner field in PHPR the field that holds the science type.

It might work OK, but you would have to logout of one science type and log into another to change science type, whereas DaleM's version allows fast switching

If I have not made myself clear, get back to me and I will try to set up an example of what I mean

HTH



No...that's well explained and thanks for the idea....it might prove a bit cumbersome with the number of categories but it is certainly an option....