Friday 7 June 2013

Workrequest creation

Workrequest num: =(LEFT(TEAM,1)&Year&CONCATENATE("WR-",REPT(0,4-LEN(incrementid)),incrementid))                     ex: A12WR-0251
(hear both incremented above through workflow only)
Year: =RIGHT(Filteryear,2)
Filteryear =TEXT(Created,"yyyy")
Incremented: (number field(number of decimal fields:automatic))
Incremented:through auto increment workflow
 Auto increment id workflow:





One more scenario for workrequest num creation
Workrequest no: =(Title&Filtermonth&Filterdate&Year&CONCATENATE("R",REPT(0,4-LEN(Autonumber)),Autonumber))                          ex: CSP042613R0000 (csp means title)

Filterdate: =TEXT(Created,"dd")
FilterYear:       =TEXT(Created,"yyyy")
Last two digits in year   year: =RIGHT(Filteryear,2)
Filtermonth :     =TEXT(Created,"mm")

Autonumber :Through designer workflow as specified above

No comments:

Post a Comment