This is an issue I have not found an answer for through the past year of PHPRunner versions.
In the Lookup wizard I often use Concat() to combine an integer field, such as the Account Number in the record, with a user-friendly name and city in the Auto-suggest field the User sees.
So visually the Ajax values dropdown might look like this:
367712891 Robert Armstrong Chicago
367712894 Arnold Fletcher Kansas City
367712902 Ahmed Mousannis Detroit
(The other values come from other fields in the same record.
I will usually concat an address, too, to help make each line more distinct.)
The link field used in the Lookup Wizard is the AcctNo. field of 9 digits.
But the List View always shows the whole value word-wrapped in the field cell something like this:
Acct#
367712894
Arnold Fletcher
Kansas City
What I want is to only see the actual number stored in this field: 367712894
I have not found the "secret" to only displaying the Value actually saved, the 9 digits.
No matter how I set up the List View, even specifying to display the contents as a 9 digit Number, I always get the "artificial" display in List view, all of the concat values stacked with the digits saved.
I go through all of the windows checking the field settings from view to view to make sure they are consistent from screen to screen. But no matter how I define this field in List view I cannot FORCE it to simply display the REAL value ... 9 digits.
The concat lookup wizard settings for Add & Edit always override the separate List setting.
And this still happens even when the field type in the table is an INTEGER.
If I did not have to use separate settings for Add, Edit, and List then I could set it as a Text field with Number validation or HTML5 Number type.
Am I the only one with this problem?
A few years ago we were counselled that the only way to work around this bug was to set up an alias of that field and then use the alias to set this field unaffected by the Lookup Wizard. This is a series of extra steps that should not be necessary.
I was under the impression that some builds back this bug was taken care of.
How has anyone else dealt with this problem when using Concats in the Lookup Wizard?
Thank you. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=23009&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />