Hi All, I am working on a simple app that will interface with our accounting system's API to provide customers with their account balances, overdue invoices, etc. To link the two systems together I have created a custom field on the User Organization in Kayako called "Card ID". This links to the unique ID in the other system. I would now like to access this "Card ID" field in my controller. I don't know how to get to it though. It doesn't seem to be accessible via the SWIFT_UserOrganization class and the CustomFieldRendererClient seems to be tied in with templates (which I am not using). What I really need is to be able to extract this single field in the controller so that I can pass it into the API call. Any assistance would be appreciated. Adam
Hi All, Worked out a solution that does the trick so I thought I'd post it here. For now by directly calling the database: PHP: $this->Database->Query("SELECT * FROM " . TABLE_PREFIX . "customfieldvalues WHERE customfieldid IN (14) AND typeid = '" . $_SWIFT->User->GetProperty('userorganizationid') . "'"); while ($this->Database->NextRecord()) { $_fieldValue = $this->Database->Record['fieldvalue']; } The "14" is the custom field ID and is hard coded for now, but ideally this would be stored in the settings for the application.
