title: Oracle ApEx Checkbox to Manipulate Other Values When Checked/Unchecked
body: <p>Firstly, I am using the latest version of Oracle ApEx 4.1.1 and have the following standard report that has a checkbox selection so when clicked, would like to set another field with sysdate, including time.</p>
  
  <p>When unchecked, would like to reset to NULL the date set in my previous statement as well as a comments fields</p>
  
  <p>Report might look like:</p>
  
  <pre><code>select id,
         name,
         telephone,
         apex_item.checkbox2(10,id) as "Tick when Contacted",
         apex_item.display_and_save(20,:P2_DATE) as "Date Contacted",
         apex_item.textarea(30,:P2_COMMENT,5,80) as "Comment"
  from   my_table
  </code></pre>
  
  <p>As an example of the above report, there might be a total of 10 records, so as each of the 10 record checkboxes are checked by the user, I would like to set the date field to sysdate, on the spot. I would also like the reverse done, when the checkbox is unchecked - set both date and comments to NULL.</p>
  
  <p>How should I approach this? Is the above possible via a Dynamic Action or straight via a JavaScript/on demand process?</p>
  
  <p>Would definitely prefer the Dynamic Action approach if possible, in order to learn new methods of performing my required task.</p>