R
Robin
I'm looking for a way to auto number a form that can also pull from a
sharepoint library and increment by one. For example, the numbering
could start with the year, month, and date (yyyymmdd) followed by three
"leftover" numbers so the end result would be (yyyymmdd###)
The purpose would be so that a new set of numbers is used on each day,
so on 5/1/2006 the form number would start as 20060501000, and on
5/2/2006 the form number would start as 20060502000, and so on.
Additionally, I would like the field to then update by one when the
forms are saved back to a sharepoint library. The current way we do
this (increment by one) is that the form queries the sharepoint site,
and adds 1 to the number, a very simple formula.
Any recommendations for this type of auto-numbering? Thanks for the help!
sharepoint library and increment by one. For example, the numbering
could start with the year, month, and date (yyyymmdd) followed by three
"leftover" numbers so the end result would be (yyyymmdd###)
The purpose would be so that a new set of numbers is used on each day,
so on 5/1/2006 the form number would start as 20060501000, and on
5/2/2006 the form number would start as 20060502000, and so on.
Additionally, I would like the field to then update by one when the
forms are saved back to a sharepoint library. The current way we do
this (increment by one) is that the form queries the sharepoint site,
and adds 1 to the number, a very simple formula.
Any recommendations for this type of auto-numbering? Thanks for the help!