Add DateTime stamp on checkbox

[Duncan]

Hello,

I have just signed up with Caspio and am creating my first app, but have run into a hurdle I am hoping can be overcome.

The app records test cycles and I have a requirement to capture the following fields:

1. Start Weight
2. Start Time (DateTime)
3. Stop Weight
4. Stop Time (DateTime)
5. Mass Consumed (1 - 3) [Calculated Field]
6. Cycle Time in (decimal) hours (4 - 2) [Calculated Field]
7. Consumption Rate (5/6) [Calculated Field]

Ideally, I would like the user to be able to click a button or checkbox to capture the date/time, as the form will need to be open when the test starts and we may need to re-start.

So, I have two questions please:

1. On a Datapage form, is it possible to add a DateTime stamp to a field using a HTML button or checkbox and some JacaScript?
2. Can I then calculate the difference in hours (digital...i.e. 4.5 is 4hr 30min) and add this to the cycle time field?

 

Any help would be appreciated.

[MayMusic]

Yes on can use this JS in the Footer of HTML Block below all your elements:

 

<script>
document.getElementById('InsertRecordStampCheckbox').onchange = function (){
if (document.getElementById('InsertRecordStampCheckbox').checked){
document.getElementById('InsertRecordDate').value = '[@cbTimestamp]';

} else {document.getElementById('InsertRecordDate') = '';}
};
</script>

in 'InsertRecordStampCheckbox ' you need to replace "StampCheckbox" with checkbox field name

in "InsertRecordDate" change "Date" with the date field name you want to record the timestamp

[Duncan]

Hi MayMusic,

Thank you.  I have inserted a form with a checkbox and a HTML footer with the script, but it's not working. 

Here is the checkbox...

<input name="start" type="checkbox" value="start" /> Start

 

And here is what I've put in the footer HTML...

<script>
document.getElementById('start').onchange = function (){
if (document.getElementById('start').checked){
document.getElementById('Start_time').value = '[@cbTimestamp]';
} else {document.getElementById('Start_time') = '';}
};
</script>

 

Have I set this up wrong.  I've attached a couple of screenshots of the setup dialog.

[Kurumi]

Hi @Duncan,

You can refer to this Forum post about Timestamp and time difference.
 

I hope it helps.