Pre Fix Problem with Sequential Numbering

[plance]

Hello,

I currently have a db that uses 9 diff prefixes and then a random unique number. When a staff member enters / submits the form everything works fine except the FIRST time they do this per day. So for example, their first entry would look like 12-3- on the table. It should look like 12-3-42516325....

I have to go back into the table and put in my own "random" number when this happens.

Any advice would be helpful and much appreciated!

~ Paul

[bahar_vm]

Can you take a screenshot of your DataPage Fields Configuration screen? I want to see how you have configured this autovalue field.

Also it would be helpful if you provide a link to the page where we can test the form.

Best,

Bahar M.

[plance]

Hello,

Please see the screenshot as requested.

Thanks in advance,

Paul

[plance]

Hello again!

Thought it would be helpful to add this screenshot as well.

Thanks!

Paul

[bahar_vm]

I see why it is not working. You are using a JavaScript to combine the two virtual fields and put them into a real field in the table, however Random Unique ID is generated in the server level but JavaScript is on the client level. In other words, the JavaScript cannot pick up the autovalue number because the number is not generated yet. This type of combination requires the code run at the server level such as a database trigger to combine the two values.

If you want to use JavaScript you cannot use the Autovalue field, instead you can write another JavaScript to also create a random unique id.

Best,

Bahar M.

[plance]

Hmmm..

Interesting. Thanks for the advice. Since ( for obvious reasons ) I don't have access to the server level... I better increase my javascript capabilities huh? LOL

Fortunately, the db is perfect other than that...

Anyway, thanks again.

Paul

[nkamalan]

Here is the script that generates 8 digit random number and put it in RandomNum field. It goes to the footer of the submission page.

function r_num()

{

var randNum = "";

var MAX_LENGTH = 8;

while(randNum.toString().length

var temp = Math.floor(Math.random() * 10);

randNum += temp.toString();

}

document.getElementById("InsertRecordRandomNum").value=randNum;

}

document.getElementById("caspioform").onsubmit=r_num;