I'm developing a support ticket system and when creating a ticket I have some code that will automatically change the status of the new ticket from "New" to "Assigned" if the 'Assigned To' field is changed to a value other than null. If it's reset back to null the ticket status is changed back to "New". This all works correctly in the add form.
I also have a table which allows for inline edits of this data. What I'm trying to accomplish is that when assigned_to in the table is edited inline and changed from null to an assigned value it also edits the status field and shows it as assigned. I don't want to push a change directly to the data as I want the user to be able to override that edit and change the status to something else if they choose.
I've played around a bunch with the changesetArray variable and can detect when assigned_to is changed but I can't figure out how to translate that into an edit of a different field on the same row.