Cognito-forms – Need a formula to synchronise “Entry” with existing numbering

cognito-forms

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?

Best Answer

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)

Related Solutions

Cognito-forms – Is it possible to link one calendar to another inside the same form

I'm a developer with Cognito Forms.

Yes you can do reference another calendar, but it sounds like you have one Minimum value on your Order Start Date and you will then want to replace it with the new Minimum value that would be provided by the 'Pre-approval Date' when its showing.

To do this I created a simple from with just 3 fields.

A Yes/No field titled 'Pre-approve audio' that is always visible.
A Date field titled 'Order start date'that is always visible.
Then another Date field titled 'Pre-approval date' that is only visible when the Yes/No filed, 'Pre-approved audio' is set to yes.

The 'Order start date' then has the following code in the 'Minimum' range value.

=PreapproveAudio ? PreapprovalDate.AddDays(2) : DateTime.Today.AddDays(3)

This will set the date field to check the Yes/No field, and use one of the two minimum dates. If 'Yes' is selected the minimum value cant be before the date in the 'Pre-approval date' + 2 days. If 'No' is selected the minimum value cant be before today's date + 3 days.

I have included a link to my template so that you can copy this form into your Organization and take a look at how the calculations are working.

Linking Calendars template

Cognito-forms – Need help with image to be written on

I'm a developer with Cognito Forms.

No, we do not have a way to draw, or make updates to an image that has been added to a Cognito Form.