How to clean text with Logic Hook formula?

Hi Arpad Szabo

Formula and logic hooks are different ..

formula will be automatically updated based on a calculation you provide

https://support.sugarcrm.com/Knowledge_Base/Administration/Studio_and_Module_Builder/Sugar_Logic/Sugar_Logic_Walkthrough…

Logic hook also having different type .. for your scenario you can try afert_save logic hook.

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.7/Architecture/Logic_Hooks/Module_Hoo…

Hello Mehul  Bhandari

Yes I understand that the formulas ang logic hooks are differenet.

Simplified: one field on the record has two choices by the Studio:

a. Entry field

b. Calculated field (with formulas)

Normally with entry field i cant clean or uniformise the data, only we can enter for example the text.

We want to use the Logic Hook After Save to clean the entered text.

We found the workoround how to define a Logic Hook.

The Question is, to how to define the cleanin procedure :

<?php

   if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
  
   class logic_hooks_class
   {
   function after_save_method($bean, $event, $arguments)
   {
  //logic - HOW TO DEFINE THE LOGIC? WHICH FORMULA CAN WE USE?
   }
   }

?>

Hi Arpad

Basically you need to define those functions if they are neither php or SugarCRM builtin functions.

Then you can invoke them in order to modify some specific fields:

<?php

if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');

class logic_hooks_class {

  function after_save_method($bean, $event, $arguments {

  $fields_to_clean = array('first_name', 'last_name', 'description');

  foreach($fields_to_clean as $field) {

  $bean->$field = $this->clean_field($bean->$field);

  }

  }

  private function clean_field($value) {

  // do something

  }

}

?>

Chees

Hi Arpad

Basically you need to define those functions if they are neither php or SugarCRM builtin functions.

Then you can invoke them in order to modify some specific fields:

<?php

if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');

class logic_hooks_class {

  function after_save_method($bean, $event, $arguments {

  $fields_to_clean = array('first_name', 'last_name', 'description');

  foreach($fields_to_clean as $field) {

  $bean->$field = $this->clean_field($bean->$field);

  }

  }

  private function clean_field($value) {

  // do something

  }

}

?>

Chees

Hello,

Thank You for Your help, just created a Custom Logic Hook !

Here it is, used to clean the company name from fancy characters and to standardise it:

<?php
    class Clean
    {
        function CleanName($bean, $event, $arguments)
        {
           $companyname = $bean->name;
           $companyname = ucwords(strtolower(trim(str_replace('"',' ',$companyname))));
           
           $bean->name = $companyname;
        }

    }
?>