Pre-populate field value

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
TKay
Posts: 11
Joined: Mon Jun 19, 2017

19 Jun 2017

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

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

19 Jun 2017

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

TKay
Posts: 11
Joined: Mon Jun 19, 2017

20 Jun 2017

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

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

21 Jun 2017

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.

TKay
Posts: 11
Joined: Mon Jun 19, 2017

22 Jun 2017

Thanks Dmitry!

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 6 guests