General

Re: Infopath/Sharepoint Increment based off of different selections

Jamie1234 — Tue, 11 Mar 2014 14:15:45 GMT

I am trying to create an Infotpath form that is submitted to sharepoint and I have it working but not the way I would like it to work. Any help with much needed detail would be greatly appreciated due to the fact I am still a "newbie".

I have two fields one called Ref Number which is a read only text box to the users and another field called Own Info which a Drop-Down list. Bascially I would like it to where when the user clicks the submit buttom the Ref Number will get incremented. I have the form incrementing with leading zeros but everytime the submit button is clicked and I would like it to be determined by the Own Info and not like this : concat(Own_Info , "-", substring("000", 1, 4 - string-length(max(ID) + 1)), max(ID) + 1).

Example :

Own Info : D652

Ref Number : D652-0001

Own Info : D652

Ref Number: D652-0002

Own Info : D653

Ref Number : D653-0001

Own Info : D653

Ref Number : D653-0002

Own Info : D652

Ref Number : D652-0003

So the Ref Number increments based off of the Own Info which will be about 25 different options. Again any help with much needed detail would be greatly appreciated. Thanks in advance!!!!

Infopath/Sharepoint Increment based off of different selections

Jamie1234 — Mon, 10 Mar 2014 19:57:36 GMT

Example :

Own Info : D652

Ref Number : D652-0001

Own Info : D652

Ref Number: D652-0002

Own Info : D653

Ref Number : D653-0001

Own Info : D653

Ref Number : D653-0002

Own Info : D652

Ref Number : D652-0003

So the Ref Number increments based off of the Own Info which will be about 25 different options. Again any help with much needed detail would be greatly appreciated. Thanks in advance!!!!