Forms Designer Forum

Hi there,
Can you please help me pre-populating the next ID value in a new form?

I have the following column: "Contract ID" = single line text
The "Contract ID" is in the format of YEAR-3-digit-NUMBER = for example = 2017-015

I would like to pre-populate the next value (the last existing ID + 1) in the new form Contract ID filed. For example if the last existing value is 2017-015 the next would be 2017-016. If the "YEAR" part changes then the next value would be 2018-016

Sincerely,
Tomas

Hi Tomas,
You can populated the Contract ID field a workflow based on ID of the newly created item.

would it be possible to do it through the javascript? and fill out the COntract ID field in the form itself? workflow is not the best solution in my case

There is no ID of an item in a new form. First, you should create an item and then populate a column with its ID.

Thanks Dmitry!