I am creating a work order form to replace a manual submission system. I have a numbering system based on the year and the sequence of the order in which it is received. My current format is as follows: WO 16-1350. I want my first Cognito entry to start at 1401.

How do I build a calculation using the "Entry" to fit into my pre-existing order?


You can use the following calculation in Cognito Forms to generate your work order number. Just create a Calculation field of type Text and enter this calculation:

="WO " + DateTime.Today.ToString("yy") + "-" + (Int32.Parse(EntryNumber) + 1400)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.