Telephone Number Formatting

Telephone Number Formatting

Hi, Following on from the April digest, here is a custom function, that Ive got in place for UK based +44 numbers 

  1. contact = zoho.crm.getRecordById("Contacts", contact_id);

  3. // Get ONLY the Phone field. 
  4. phone_number = contact.get("Phone");

  6. // If phone_number isn't null...
  7. if (!isnull(phone_number)) {
  8.     info "Original phone number: " + phone_number;  // Log the original value

  10.     // Remove spaces
  11.     phone_number = phone_number.replaceAll(" ", "");

  13.     // Replace 01, 02, 07, 0044, +440 or 44 with +44 directly
  14.     if (phone_number.startsWith("01") || phone_number.startsWith("02") || phone_number.startsWith("07")) {
  15.         phone_number = "+44" + phone_number.substring(2);
  16.     } else if (phone_number.startsWith("0044") || phone_number.startsWith("+440")) {
  17.         phone_number = "+44" + phone_number.substring(4);
  18.     } else if (phone_number.startsWith("44")) {
  19.         phone_number = "+" + phone_number; // Simply add the "+" sign at the beginning
  20.     }

  22.     info "Modified phone number: " + phone_number;  // Log the modified value

  24.     // Update ONLY the Phone field if a replacement was made.
  25.     if (phone_number != contact.get("Phone")) { 
  26.         phone_update = Map();
  27.         phone_update.put("Phone", phone_number);
  28.         zoho.crm.updateRecord("Contacts", contact_id, phone_update);
  29.     } else {
  30.         info "No update needed. Phone number is already in the correct format."; 
  31.     }

  33. } else {
  34.     info "No phone number found for this contact.";
  35. }