Challenge: Save "dirty" form before navigating away
Well, seems like a challenge to me anyway!
I have a updatable dynamic SQL query region built using htmldb_item items.
The page has
1. A save button on the page that calls a After Submit process to sync the form back to the database.
2. The standard Rows X to Y pagination scheme.
3. A breadcrumb menu on the top to navigate between different pages of the app.
My users cant be bothered to click the Save button
Question:
How can I either auto-save or prompt user to 'Save or Cancel' when anything is clicked that would navigate away from the page? This would include the pagination Previous/Next links and any of the non-current breadcrumb menu items on the top
Help? Thanks