Max value from number field by this year

[Pavel Smirnov]

field1=numer, field2=date stamp

How to find max value of number field by this year?

Thank you.

[comment]

There are many ways to do that. It would be best if you explained the context in which this is needed.

[Pavel Smirnov]

There are many ways to do that. It would be best if you explained the context in which this is needed.

each year number value begins from "1" and next number value must be next with increment = 1, but I can't do this with calculation like 'serial number' because if you delete any record, this number value will be lost.

I think the best way, is to find max number value, and set field "value+1", but I don't know how to make this script.

by clicking a button i need to see in a new record right value.

[comment]

if you delete any record, this number value will be lost.

What exactly should happen if a record is deleted?

each year number value begins from "1"

This is difficult to implement reliably. What is this number being used for?

[Pavel Smirnov]

What exactly should happen if a record is deleted?

This is difficult to implement reliably. What is this number being used for?

It's used for numbering documents.

So if I need for any record make this document, I need set max value by this year in the related table. So if any record will be deleted in related table (but I think it will be not happened) so next value must be next.

[comment]

What is this number being used for?

It's used for numbering documents.

LOL. And numbering documents is used for...?

So if any record will be deleted in related table (but I think it will be not happened) so next value must be next.

That could mean anything. You didn't mention a related table before. Technically, it's easy to count the number of records in the current year, using a relationship matching on year. The problem is that the number doesn't change until a new record is created and committed - so it's quite possible to generate duplicates.