update column on behalf of other column

update column on behalf of other column

waleed755waleed755 Posts: 1Questions: 1Answers: 0

i am using data tables editor and i want to update a field on behalf of other feilds
for example i am using two fields for time in and time out which calculate hours automatically
time in and timeout updates succesfully but hours are not updated in database

Answers

  • allanallan Posts: 63,815Questions: 1Answers: 10,517 Site admin

    The dependent() method might be the way to go here. I presume that you basically want to add the duration to time in? Another way would be to use a database trigger, or a server-side event to set the second value.

    Allan

This discussion has been closed.