Custom field insert query in suitecrm

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Hi all,

     In suitecrm how to insert custom field value for other table in database .

Regards,
Rajkumaranbu

#2

If I understand your question correctly, this would require a workflow or more likely as logic hook. The logic hook can retrieve and edit any other records/tables in the database.

I recently discovered the SuiteCRM for Developers eBook, and it is tremendously helpful, although very outdated:
http://www.jsmackin.co.uk/
http://www.jsmackin.co.uk/suitecrm/suitecrm-for-developers-released/

Buy it here: https://leanpub.com/suitecrmfordevelopers

sieberta

#3

Hi sieberta,

If i create all fields in a project task module, if open create view page i fill the all fields after submit the project task module ,at the time i want to display two fields for cases module list view page how it is make kindly help me

Regards,
Rajkumaranbu

#4

rajkumaranbu,

I see, you wish to display some fields from a related module. And I assume this is a one to one or one to many relationship (where the many side is the project tasks).

I have never attempted this… while it is probably possible (not through logic hooks or workflow, but through editing detail.view.php and possibly an associated template file) I wouldn’t have much to offer and it is more in depth than I could reasonably research for you.

This looks promising, however: https://community.sugarcrm.com/thread/21730

Sincerely,
sieberta