Solid Dev Posted November 25, 2016 Share Posted November 25, 2016 Hi, We have a custom field for customers - Mobile Phone. We would like to able to include this number in a clients report. E.g. admin/reports.php?report=clients-mobile Can anyone explain how this is done? Kind regards, 0 Quote Link to comment Share on other sites More sharing options...
Solid Dev Posted November 29, 2016 Author Share Posted November 29, 2016 Can anyone give me some clues? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted November 29, 2016 Share Posted November 29, 2016 Can anyone give me some clues? it's technically not that difficult, but the first thing you need to figure out is where in the database does the information you want exist (if it does). for example, the clients report just looks through the tblclients database table - but there are no customfields in there, so you'd additionally need to check tblcustomfields (for field names/types) and tblcustomfieldsvalues (for the corresponding values for each client)... if you were doing this just for one specific ccf, then you could probably bypass the 2nd table and code the value of the customfield you want into the 3rd. there are a couple of existing addons that could probably help you with this, but seeing as you've also posted in Service Offers & Requests, you'll likely get some replies from developers in there too. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.