2. PHPRunner General questions
  3. display fields on add page
This topic is locked

display fields on add page

 		6/27/2012 9:42:34 PM
PHPRunner General questions
M
 meirco author

php runner 5.1
my php runner app is 3 years old and i forgot how to do this.

in the add page

I need to display fields data from another table not related, and does not need to be saved in the current table.

i put this code in the after record added . is this the right place?
global $dal;

$rs = $dal->cases->Query("bmbmno='".$values["bmbmno"]."'","");

$data = db_fetch_array($rs);

$workh=$data["workhours"];
where do I define $workh so I can show it on the page.
thanks
Meir
Sergey Kornilov admin 6/29/2012

Save it to session variable and use it on any page:

$_SESSION["workh"]=$data["workhours"];


Then use $_SESSION["workh"] anywhere you want.
M
 		meirco author 7/3/2012



php runner 5.1
my php runner app is 3 years old and i forgot how to do this.

in the add page

I need to display fields data from another table not related, and does not need to be saved in the current table.
M
 		meirco author 7/11/2012






--------------------------------------------------------------------

I solved the problem by use of depended dropdown all fields were depending on mattkey
so in look up wizard i used

table cases

link field workhours

display field concat(bmbmno,' |Hrs:| ',workhours)//custome expression

checked on This dropdown is depended on checkbox

category control mattkey

category key ikey

check on dropdown box multiline 1 rows
I did the same for expenses and payments. We now are able to enter the matter and populate bmbmno,workhours,expenses,payments
is there a way to format the custome expression

concat(bmbmno,' |Hrs:| ',<strong>workhours</strong>)

where workhours will be bold.

Meir