Discussions

Time On Form Demo


I created a demo named "Time On Form" partially in response to this question:

How can I use javascript to get current date/time to use as a variable in a formula
https://community.quickbase.com/quickbase/topics/how-can-i-use-javascript-to-get-current-date-time-t...">https://community.quickbase.com/quickbase/topics/how-can-i-use-javascript-to-get-current-date-time-to-use-as-a-variable-in-a-formula">https://community.quickbase.com/quickbase/topics/how-can-i-use-javascript-to-get-current-date-time-t...

The demo addresses four different use cases that might occur all of which can be implemented with script. I think you can figure out what is accomplished in each of the four cases without a lot of description from be although there are subtle differences between each use case.

The demo has three fields [Name] representing the collective set of data entry fields, [Time On Form] representing the time the new record field is open, and [Forced Save?] indicating if the form was automatically saved after a 10 seconds timeout. For demo purposes I am displaying all of these fields but preventing direct editing of [Time On Form] and [Forced Save?] as these fields are set by script not human input.

Form 1 ~ Capture Time on Form
https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=2">https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=2">https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=2

Form 2 ~ Display Time On Form
https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=10">https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=10">https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=10

Form 3 ~ Forced Save after 10 seconds
https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=11">https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=11">https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=11

Form 2 ~ Nag Message after 10 seconds
https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=12">https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=12">https://haversineconsulting.quickbase.com/db/bnhiu5b67?a=nwr&dfid=12

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=637">https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=637">https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=637

This is awesome!  What kind of field is Time on Form?

Duration