Pre-populate field value
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
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
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
Hi Tomas,
You can populated the Contract ID field a workflow based on ID of the newly created item.
You can populated the Contract ID field a workflow based on ID of the newly created item.
- Dmitry Kozlov
- Site Admin
- Posts: 1524
- Joined: Thu Jun 07, 2012
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.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 8 guests