Question
Distributing Form that generates sequential numbers to multiple individuals
Hello,
This Forum has been quite helpful in creating a Purchase Order that automatically generates unique sequential numbers each time the form is open. I used this script:
var num = this.getField("Text1");
num.value = Number(num.value)+1;
num.defaultValue = num.value;My question is: how do I go about distributing said form? I need to email it to 3 different people. If they open the form at the same time, how do I prevent the same number from generating for each individual?
(I tried reproducing the form with different number sequences for each person, but the (auto generated) number is only changing on the original form.)
Any help would be greatly appreciated.
AdChoices