how do i update another table from an editview?

[netron]

how do you update another table from a module editview?

i've added an extra field to my leads table, which will store the date and time of when a call was made to that lead.
therefore, when i submit a call via the calls.editview page , i'd like to also update that leads table field.

its just a simple sql query

update leads set lastcalled=NOW() where leads.id='$related_id'

but i'm not entirely sure where the sql statements for updating/inserting occur once you hit "save" on an editview page.

[clint]

how do you update another table from a module editview?

i've added an extra field to my leads table, which will store the date and time of when a call was made to that lead.
therefore, when i submit a call via the calls.editview page , i'd like to also update that leads table field.

its just a simple sql query

update leads set lastcalled=NOW() where leads.id='$related_id'

but i'm not entirely sure where the sql statements for updating/inserting occur once you hit "save" on an editview page.

You will want to create a "before_save" custom logic hook and write your code there that does the update. Watch the Business Logic Hooks tutorial found at developers.sugarcrm.com. This will explain how to create upgrade-safe "before_save" code.