Extending a data field to complete a URL

[sandydomrep]

My current database just stores the end digits e.g. 545 as the end part of a url e.g. www.mywebsite.com/search/show.php?id=545

I have updated the accounts tables with these value and entered them in to the website field, but have no idea on how to automatically add the www.mywebsite.com/search/show.php?id= part of it.

What's the best option? Updating the sql table column fields with the addition? which I have no idea how to do... or update the php file to add this?

I have been looking at option 2 at the Modules/Accounts area, but can not find anywhere to do this. I am using SugarCRM version Version 6.1.1 (Build 5512).

Using the search function on here, I found a reference to the detailviewdefs.php file and came across this part of the script,

array (

array (
'name' => 'website',
'type' => 'link',
'label' => 'LBL_WEBSITE',
'displayParams' =>
array (
'link_target' => '_blank',
),
),

but am not sure if it is the right part of the code to edit or what amendments I should make to it. Any suggestions would be much appreciated. Sandy

[ozz_]

Hi There
Have you tried the Admin -> Repair -> Expand Colum WIdth?

[sandydomrep]

Helllo Ozz

Thanks for replying. I was thinking it would be something simple like a change in the php file somewhere. I had a look at what you suggested, but came up with the following

'This function is not currently implemented for this configuration.'

Not really sure what this means...I am using the community version.
Sandy