How Do I Timestamp A Record When Value Of A Checkbox Is Changed?

[Barbara]

How do I timestamp a record when value of a checkbox is changed?

[bahar_vm]

Place the script below in the Footer of your details/update page.

Status is my checkbox field. Change Status in the code to your field name.

Time_status_edited is a hidden field to store the timestamp. Change Time_status_edited to your field name.

---------------------------------------------------------------
function getT()
{
var prevValue='[@field:Status]';

if(((prevValue!= 'Yes') && (document.getElementById("EditRecordStatus").checked)) || ((prevValue== 'Yes') && (!document.getElementById("EditRecordStatus").checked)))

 {
   document.getElementById("EditRecordTime_status_edited").value = '[@cb:Timestamp]';
  }
}
document.getElementById("caspioform").onsubmit = getT;

</script>
 

[Jan]

Hi Barbara,

 

Please do not forget the "<script>" before the code.

The whole code will be:

 

<script>

function getT()
{
var prevValue='[@field:Status]';

if(((prevValue!= 'Yes') && (document.getElementById("EditRecordStatus").checked)) || ((prevValue== 'Yes') && (!document.getElementById("EditRecordStatus").checked)))

 {
   document.getElementById("EditRecordTime_status_edited").value = '[@cb:Timestamp]';
  }
}
document.getElementById("caspioform").onsubmit = getT;

</script>

[Kurumi]

You could use the option 'Stamp on Update' on your Timestamp data type. Just like this:

For more information about Data Types, check the article here: https://howto.caspio.com/tables-and-views/data-types/

 

I hope this helps!