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!!!!