If I want to automaticly add numbers to a field. I want it to start with 1, increment by 1 and restart at 1 when it has reached a certain number (say 4). Is there an easy way to do this?
It can be done easily, but the devil is in the details and can depend the context in which you are doing this, why, and whether you might have multiple users creating new records all at once that get this numbering.
If you wanted to update a group of records all in one batch to be numbered this way, the following calculation could be used with Replace Field Contents:
Mod ( Get ( RecordNumber ) ; 4 ) + 1
Once again you make my life so much easier.
Retrieving data ...