Automate

Hello
We have external number assignment for our trade goods. Every productmanager can initiate a process for a new material. In my form they have to insert the material number they would like to have. But it could be that at the end of the process when creating the material in SAP the number is no longer available.
In SAP it is not possible to book/reserve a material number without creating the material. 

I would like to do this in Evolve.
Perhaps like this:
in perhaps reference data or another list I insert all possible numbers (par ex. 20). In the form user choose a number. While choose the number, it reserve it and the next who open the list of all possible numbers there is only 19 left.

Is this a possiblity to do in Evolve?

Thanks for your ideas.

Jana

Hi Jana, 
You can create a database table in any of your sql databases.
and can use to fetch the values and delete the used value from the table.
----------------------
for example :
use below command to create the table : 
create table MaterialNumbers
(
Mnum int
)
insert into MaterialNumbers values(1)
insert into MaterialNumbers values(2)
insert into MaterialNumbers values(3)
insert into MaterialNumbers values(4)
insert into MaterialNumbers values(5)
insert into MaterialNumbers values(6)
insert into MaterialNumbers values(7)
select * from MaterialNumbers
* once table is created make a data connection to this table from the form solution.
* use these values in a dropdown for users to select.
* Configure a query control(run at end) to delete the selected number from the table.(shown in screenshot below).

* You can maintain the values stored in the database table according to your preference.

Hope this helps.

Regards 

Reserving numbers tends to get tricky if you consider what should happen if the workflow is cancelled?
Do you purge that number or do you need a way to put it back in the queue?
Also, if SAP allows material creations behind the scenes via the GUI as well, then you may be competing for the same numbers anyway. 
Just a few things to consider :)