I need a series of random numbers, 5 digits in length, that are divisible by 3. They will be dispalyed to survey respondents as validation codes. In the past, I would make codes in Excel and turn them into a Predefined list, and then call list members for each respondent based on their RespNum. Unfortunately, I need 20,000 random codes, and I keep freezing SSI Web by trying to paste that many items into a list.
Is there a way to use the RandNum or SysRand functions to generate numbers divisible by 3? I know I can use them to get 5-digit numbers (by setting Min and Max to 10000 and 99999).
Any help is much appreciated!