2. PHPRunner General questions
  3. [SOLVED]  Display field concat values show up in List View
This topic is locked
[SOLVED]

 Display field concat values show up in List View

 		5/5/2015 1:57:37 PM
PHPRunner General questions
A
 Anapolis author

[size="3"]I am using the latest build of PHPRunner 8.
I use concats in the Lookup Wizard Display field all the time to make the lookup easier to associate with the correct record.
So, if I have a Key field acctnumber I use the Lookup Wizard to pull values from that table column ---- FC37904, FC45661, ....etc. for my Edit Box with Ajax popup.
To help the User pinpoint the needed record I apply a Concat for the Display Field
[indent]Table: accounts

Link field: accountid

Display Field: concat(accountid,' ',name,' ',city,' ',zipcode)[/indent]
I set the search for Edit Box with Ajax popup
Now the User sees the account id number in line with the Name, City, Zipcode in the Display field but they are, of course, selecting the Link field value as the value to place in the accountid field of the new record.
Most of the users could not use the lookup unless they have the additional visual help to confirm they have the right record.
However, when the Record is created and Saved on the LIST page I have row after row of entries like this in the Account ID field --
FZ667393 Axis I want this: FZ667393

Logistics Kenosha

53141
TR82229 Locker [color="#2E8B57"] >>> I want this: TR82229

Security Services

Pekin

61555
on and on.
The actual field in the database is just the accountid sequence as I wanted so that is definitely a good outcome.
But I need to strip out the Concat values set in the List view and free up some row and column room.
I am using a LIST page generated separately for all fields, all these List views are set for Text only.

There was a time when using PHPRunner, in the 7 and earlier 5 series when this unexpected List view was not a problem.
I have looked at projects over and over investigating every setting when working on new projects and this Concat override in the List view has not stopped.
What have I missed to get the List view I am expecting by Default?
Thank you if you can clue me in![/size]
A
 		aptivus 5/6/2015



[size="3"]
To help the User pinpoint the needed record I apply a Concat for the Display Field
[indent]Table: accounts

Link field: accountid

Display Field: concat(accountid,' ',name,' ',city,' ',zipcode)[/indent]
I set the search for Edit Box with Ajax popup
Now the User sees the account id number in line with the Name, City, Zipcode in the Display field but they are, of course, selecting the Link field value as the value to place in the accountid field of the new record.
Most of the users could not use the lookup unless they have the additional visual help to confirm they have the right record.
However, when the Record is created and Saved on the LIST page I have row after row of entries like this in the Account ID field --
FZ667393 Axis I want this: FZ667393

Logistics Kenosha

53141
TR82229 Locker [color="#2E8B57"] >>> I want this: TR82229

Security Services

Pekin

61555
on and on.
The actual field in the database is just the accountid sequence as I wanted so that is definitely a good outcome.
[/size]


If I have understood your request, then you should go to the Editor tab fo PhpRunner, select the LIST view of the table of yours, then double click on the field acctnumber and choose "Custom" from View As menu.

In the right window type:

$value = $data['accountid'];


That should do the trick.

Bye
A
 		Anapolis author 5/7/2015

If I have understood your request, then you should go to the Editor tab fo PhpRunner, select the LIST view of the table of yours, then double click on the field acctnumber and choose "Custom" from View As menu.

In the right window type:

$value = $data['accountid'];


That should do the trick.

Bye

[/quote]
[size="2"]Thank you for taking the time to respond!
But this is a trick I have done for a long time. I have even posted this in the forum a couple of years ago. And my point is that PHPRunner even after years of improvements is still not addressing this behavior.
The default of PHPRunner is supposed to be that you get the same field Value shown in ALL fields when you specify a separate LIST page's field properties.
On any other field PHPRunner simply shows the value of the field unless you specifically set it up for another "interpretation" such as setting a field that holds either a YES or NO in the database to DISPLAY as a Check Box checked or unchecked in the List View.
I get so many projects where I have to turn out working models in 3 days or less to be online.
I used a CONCAT via the Lookup Wizard to help the User choose the Value.

They should not be seeing the Concat itself in the List page because it is a FALSE and Misleading indication to users. And, it takes up List column space for displays.
The Custom Code should only be required for modifying the display of that value.
Not NEEDED to make a custom code just to see the value itself.
I hope to see this small change made to reduce some steps in creating a project.[/size]