i know, it must be funny to read such a easy question but i have really problems to manage this simple task. I hope someone can help me with a Tip.
Thats the Situation:
Actually, i have two SharePoint Websites:
First: a InfoPath Form Library (where the Workflow run) ( 2 Fields: "Title", "used Inv. Number")
Second: a SharePoint Custom List with a "Text"-typed Colum named "Inv. Number" and following Content in it:
AB/00-00 or AB/01-00 or AB/02-00
Now the Task:
Every time a new InfoPath Item is created in the FormLib, i want to create a new Item in the Custom List with my Workflow. Thats no Problem at all, i thought. Therefore you can select in the Form the content of the Custom List Column "Inv. Number".
If someone select (for example) AB/00-00 in the Form i want to create a new Entry in the Custom List with the "Inv. Number" Column content: AB/00-01. If someone selects AB/00-01, a new Entry should be created with the "Inv. Number" Column content: AB/00-02 and so on.
But the problem is, i really cant increase the last two digits in the Workflow to create a new Item...
At first i thought it will be no problem with regular expression, but it doesnt work. If i *cut* off the last 2 digits of "Used Inv. Number" to increase them i can only save them into a 'collection'-typed workflow var., if i try to replace the Text, the result is still 'text'-typed and cant also be used for a (add) calculation. So this path doesnt lead me to a solution.
Then i created a 2nd Column in the Custom List.
First Column (Text) : AB/00 or AB/01 or AB/02 and so on
Second Column (Number) : 0 or 1 or 2 and so on
And i tried to use 'Math Operation':
List Lookup --> The Custom List --> Second Colum (with 0 or 1 or 2...)
When 'Used Inv. Number' Equals 'List Lookup --> Second Colum --> 'Inv. Number'
Second Operand: 1 (Value)
Result: Error ... but i know why, it can happen that the Filter "When 'Used Inv. Number' equals 'Inv. Number'" return more then one entry which throw an exception. Also no Solution.
What i need:
Some kind of TypeCast from String to Integer/Decimal, or sth like that. I also have the hope that its possible to use the collection type in some way but i am lacking actually the knowledge therefor.
Thanks for everybody which want help me out.