MegatronM Posted August 29 Share Posted August 29 I have a custom client field with the name REFERRED BY in the client`s profile. How can I include this field in the CLIENTS report during an export? 0 Quote Link to comment Share on other sites More sharing options...
WGS Posted September 5 Share Posted September 5 Hi, Please contact us here https://whmcsglobalservices.com/whmcs-custom-development by custom report, we can do it. 0 Quote Link to comment Share on other sites More sharing options...
MegatronM Posted September 11 Author Share Posted September 11 I'm asking in the community to avoid paying for this feature that should have been available already. Your developer wants $100 to add that one field. 0 Quote Link to comment Share on other sites More sharing options...
D3vil Posted September 12 Share Posted September 12 You can include the "REFERRED BY" field by going into your WHMCS admin area, then head to Reports > Clients. You’ll need to customize the report by adding that custom field manually in the export settings or tweak the report’s template to pull that field. You might have to edit the SQL query in the report template if it’s not showing by default. 0 Quote Link to comment Share on other sites More sharing options...
MegatronM Posted September 12 Author Share Posted September 12 1 hour ago, D3vil said: You can include the "REFERRED BY" field by going into your WHMCS admin area, then head to Reports > Clients. You’ll need to customize the report by adding that custom field manually in the export settings or tweak the report’s template to pull that field. You might have to edit the SQL query in the report template if it’s not showing by default. Yes, I've edited the template but I am stuck on how to edit the SQL area of the codes to display the custom field. Not the report page is not loading. I had to put back the original template for now until I figure out the SQL part. Google is not helping me....LOL 0 Quote Link to comment Share on other sites More sharing options...
MegatronM Posted September 16 Author Share Posted September 16 On 9/12/2024 at 11:05 AM, D3vil said: You can include the "REFERRED BY" field by going into your WHMCS admin area, then head to Reports > Clients. You’ll need to customize the report by adding that custom field manually in the export settings or tweak the report’s template to pull that field. You might have to edit the SQL query in the report template if it’s not showing by default. Thats the part I'm having an issue with, editing the SQL correctly. 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.