CiviCRM Community Forums (archive)

There's a really good UK Phone Number Validator extension* that uses inline editing to help users clean up their phone numbers.

The question is, how can I do the same for custom data sets?

Do I need to add to the api to make inline editing work?
Either way, what would I need to set the below to?

For a phone number it's (abridged):

<tr id="phone-{$eachRecord.phone_id}" class="crm-entity {$eachRecord.phone_id}">
<td>
<span id="phone-{$eachRecord.phone_id}" class="crmf-phone crm-editable">{$eachRecord.phone}</span>
</td>
</tr>

This includes:
1) Custom data off a contact.
2) Custom data off a relationship.

Thanks all!



*So I hear

Thanks for responding Coleman. Sadly, I'm not quite there yet

When I have the following (abridged):

<span id="contact-8557" class="crm-entity 8557">
            <span id="contact-8557" class="crmf-custom_35 crm-editable">test maiden name</span>
</span>
The database is like this:
mysql> describe civicrm_value_additional_contact_details_12;
+------------------+------------------+------+-----+---------+----------------+
| Field            | Type             | Null | Key | Default | Extra          |
+------------------+------------------+------+-----+---------+----------------+
| id               | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| entity_id        | int(10) unsigned | NO   | UNI | NULL    |                |
| previous_name_35 | varchar(255)     | YES  |     | NULL    |                |
+------------------+------------------+------+-----+---------+----------------+


I edit the inline message and get the error message "DB error: no such field".

However, when I do a print out of the column names available to the generic setvalue api function custom_35 appears there, and I don't get the standard error Param 'field'  is invalid. must be an existing field

Looking in the log shows: DB_mysql->simpleQuery("SELECT  id, custom_35  \n FROM civicrm_contact \n \n WHERE (  civicrm_contact...")

Obviously, as custom_35 is custom data it isn't in the civicrm_contact table.

What should my data be?

I modified the file
api/v3/Generic/Setvalue.php so that it looks like this:
// Customisation: setFieldValue below doesn't support custom data,
  // so if we encounter custom data we use the api create call instead
  if ( array_key_exists('custom_group_id', $fields[$field]) ) {
    $updateCustomFieldParams = array(
      'version' => 3,
      'sequential' => 1,
      'id' => $id,
      $field => $value,
    );
    $updateCustomFieldResult = civicrm_api($entity, 'create', $updateCustomFieldParams);
   
    if ( !civicrm_error($updateCustomFieldResult) ) {
      $entity = array('id' => $id, $field => $value);
      CRM_Utils_Hook::post('edit', $entity, $id, $entity);
      return civicrm_api3_create_success($entity);
    }
    else {
      return civicrm_api3_create_error("error assigning $field=$value for $entity (id=$id)");
    }
  }
  elseif (CRM_Core_DAO::setFieldValue(_civicrm_api3_get_DAO($entity), $id, $field, $value)) {
    $entity = array('id' => $id, $field => $value);
    CRM_Utils_Hook::post('edit', $entity, $id, $entity);
    return civicrm_api3_create_success($entity);
  }
  else {
    return civicrm_api3_create_error("error assigning $field=$value for $entity (id=$id)");
  }
}
Sharing it in case it's useful for others!