Re: Resetting the form number when using @MAX(ID) field

madhuri — Mon, 27 Apr 2009 07:19:00 GMT

Add the below condition to set max(@ID) to 0 when year is 2010.

Case when (year('04/12/2010') = '2010') then 0

else @ID end

Resetting the form number when using @MAX(ID) field

smate — Fri, 24 Apr 2009 14:59:58 GMT

I am generating a form Number (Request ID) using the ID of the forms from sharepoint form Library. I would like to generate a number based on the year and a sequence number. (Form ID)

Function would look Concact(year(request date), max(@ID)) This works fine but I would like to reset the max(@ID) to '0' for year 2010. How would I do this?

Data Connections

Re: Resetting the form number when using @MAX(ID) field

Resetting the form number when using @MAX(ID) field