Using Logic Hook to mirror a custom field from a seperate module

[infamousse]

I am trying to accomplish the following, hopefully I am on the right track.

I have added a few custom fields in the 'Accounts' module:

custom_field1
custom_field2
...and so on

I have also created a custom module:

module_field1
module_field2
....and so on

I would like the data from the 'Accounts' module to copy over and paste into 'Custom Module' fields preferably using a logic hook (I believe after_retrieve is the correct hook to use but i could be wrong).

e.g. custom_field1 = module_field1 (after retrieve or during the creation of a new Custom Module record via a 1:1 relationship


I hope this makes sense, I believe its pretty straight forward but I could be wrong. Thanks in advance.

[SugarDev.net]

There are many ways to do this. A hook is the simplest and upgrade-safe, but Sugar will not 'get' your data so don't expect searching/sorting/auditing etc.

Some info on relate fields is here: http://www.sugardev.net/content/idea...ields-sugarcrm

[kbrill]

I would like the data from the 'Accounts' module to copy over and paste into 'Custom Module' fields preferably using a logic hook (I believe after_retrieve is the correct hook to use but i could be wrong).

If you are looking for the data to be copied from accounts to this custom module then a before_save hook would be the one to use I think. However that means that the data will not be passed to the custom module until you actually save the account. If you want this data to be there up front (IE you have accounts with data that you want to be in the custom module) then doing some sort of SQL copy first and then letting the before_save logic hook take care of updates would be the way to go.

[infamousse]

So after reading both your threads the ideal thing to do would be gathering data during a before_save (will after_retrieve not do the same). How do I go about implementing this logic? Currently the custom module and the accounts module are carrying a ONE:TO MANY relationship. What type of logic is involved in copying data from:

accounts_module_custom_field == custom_module_custom_field

Thanks again for your advice.