Expand my Community achievements bar.

Increment number each day

Avatar

Level 3

How can I increment a number each day that a form is opened?

Example:

A form with numeric field, that displays "1" the first day that the form is opened

The second day that the form is opened, the numeric field displays "2"

The third day the form is opened it displays "3" and so on.....

I guess I need a calculation script?

Thanks in advance

1 Reply

Avatar

Former Community Member

Here is some sampel script that does what I think you want. The StartDtae field woudl hold the current date when the form is opened, The Epoch field woudl be an invisible field that woudl be used to store the value of when the form was 1st opened, and the NumericField1 woudl be the field that woudl hold the number of times the form was opened. Note that this is FormCalc code (much easier to deal with Dates using FormCalc).

Paul