
Announcements
What seemed to be a straight forward quick coding on the toggle button is taking me ages to figure out the right set of conditions to apply :). I have a toggle button in my forms called "Is Active?". The purpose is to track whether a service is in active state or inactive state. The toggle button is false or in inactive state by default. i have 4 other fields that im tracking - " Active marked by", "Active Marked Date", Inactive Marked by" & "Inactive Marked Date". in the new & edit pages, if the user checks the toggle button, i want the current user to be captured in 'Active marked by' textbox and current date to be captured in Active Marked Date field. in the edit page, if the user changes the active to inactive state by unchecking the toggle button, i want the Inactive marked by and inactive marked date fields to be populated by current user and date respectively. But i want to also retain the values in Active Marked by and Active Marked date fields for auditing purposes. Appreciate any help here.
You can't set those values and keep a history.
You need to create a separate table which tracks the changes for this, and add a new row to it each time your toggle is changed.