I have an internal form with a drilldown custom field for the user to select different broker.
I tried to use the API to pull the drilldown custom field value. It doesn’t send back the field value instead it returns an id.
$con = $this->app->loadCon($contactid, [‘_Broker0’]);
Return {“_Broker0”: 49}
I queried the DataFormField table and couldn’t find any field related to the id 49.
$data = $this->app->dsQuery(‘DataFormField’, 1,0, [‘Name’ => ‘Broker0’], [‘Values’, ‘ListRows’, ‘DataType’, ‘Label’, ‘FormId’, ‘GroupId’, ‘Id’, ‘DefaultValue’, ‘Name’]);
[{
“Label”: “Broker”,
“Values”: [{
“Broker2”: [“broker2@email.com”]
}, {
“Broker3”: [“broker3@email.com”]
}, {
“Broker1”: [“broker1@email.com”]
}],
“ListRows”: 0,
“DataType”: 23,
“FormId”: -1,
“Id”: 305,
“GroupId”: 19,
“Name”: “Broker0”
}]
Is there a way I can get the actual value (broker1@email.com) out of the drilldown custom field?