Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Level 10

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