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.