Modifying Leads list... adding relationship from calls...

[wdroush]

So far I got...

'NEXT_CALL' => 
  array (
    'width' => '5%',
	'module' => 'Calls',
    'label' => 'Next Call',
    'default' => true,
  ),

And that's about it, obviously nothing helpful... I want to add a field, and the field needs to get the next scheduled call for this specific lead.

Relationships seem to only be for adding things at the bottom of the details page, I'm looking to add this to the leads list page.

Any ideas? I figure there is some method to use to add some kind of custom code that will return the date, correct? Can I modify 'customcode' => and point that at a function that will query the database using the seed and get the next call for that specific lead? Or is there a better way?

Edit:

So basically I want it to do this:
Lead Name, Lead Phone #, Lead E-mail, Next call time from Call List

On the lead list.

[wdroush]

Is there no way to just put in a SQL query as a field?

[wdroush]

Maybe this should be in development help too. :P

[wdroush]

Is this not something that is suppose to be done?

[wdroush]

Bump.

Still digging in docs and experimenting.


I could use customCode, put in a javascript call, and use a javascript function to pull and format it, but geez, 50 AJAX requests per page... that will probably hurt the end user, or the server.

Or I can use an image, embed a PHP image, make PHP call and render it...

[wdroush]

It worked, but is terribly broken functionality wise, as expected, you can't sort images...

I'll be hanging around for any ideas on how to join another table and hand pick results.

[wdroush]

Here is an idea, how about using curl to call the php page I made, which will just return a date.

That would work, correct?