i am really new to SharePoint and have the Problem with an Form. I have a list like the following:

ID Title Year No DateFrom DateTo 

When a user opens a form to enter a new Entry and the View should automatically query for the max No from the current Year and add 1. If there is no Entry, it should start at 1.

In SQL it would be a simple query:

SELECT isnull(sub.No, 1) FROM ( SELECT MAX(No) AS No FROM List WHERE Year = Year(GETDATE()) ) Sub 

But how to do it without Powershell or .Net Code? I could write a small Script, but i try to stay away from scripts in Workflows.

I am really new to SharePoint and have the Problem with a Form. I have a list like the following:

ID Title Year No DateFrom DateTo 

When a user opens a form for a new Entry and the View should automatically query for the max No from the current Year and add 1. If there is no Entry, it should start at 1.

In SQL it would be a simple query:

SELECT isnull(sub.No, 1) FROM ( SELECT MAX(No) AS No FROM List WHERE Year = Year(GETDATE()) ) Sub 

But how to do it without Powershell or .Net Code? I could write a small Script, but i try to stay away from scripts in Workflows.