Resetting the form number when using @MAX(ID) field - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

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

Last post 04-27-2009 12:19 AM by madhuri. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-24-2009 07:59 AM

    • smate
    • Not Ranked
    • Joined on 04-24-2009
    • Posts 6

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

    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?

  • 04-27-2009 12:19 AM In reply to

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

    Hi

    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

    Madhuri
    http://www.ggktech.com
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.