AnsweredAssumed Answered

Find first available number in list

Question asked by greenawayr Champion on Oct 29, 2015
Latest reply on Nov 1, 2015 by mmatsako

Hi All,

 

I'm looking for some ideas on how to achieve the following.

 

I will be given a selection of 4 digit codes from a legacy app. These codes are random, ranging from 1 (I'd append necessary 0's) to 9999 and could be anything in between.

 

Using Workflow, I need to find an available code. It doesn't have to be the first available sequentially, but just not exist in the list already. I guess if I was doing this in Nintex Form then I'd use Javascript to randomly generate a number and then check it against the list, if it exists, run the code again until success. Ideally though, I'd like to keep this away from the form and in the Workflow.

 

Is there an inline function I've missed that can help with this?


Thanks

Outcomes