BarlaeDC a écrit Hi, If you use the code above in a calculation script, would it not make all the fields you haven't got to yet ( assuming they are blank to start with) read only before the user gets to fill it in? No because the value of the fields the user have not reach is still "", thus triggering the if statement I provided. BarlaeDC a écrit This would probably need to be on each fields validate ( or calculate) event, but you could store the function globally as a document script which you could then call. Your script, document level script would work great as a validate script as you said, but not as a calculate script. Although it would produce the same result in the end, you need to remember a calculate script runs EVERY TIME a value is commited, regardless of where it was commited from. So to quote you again, if the user enters a value to field1, field2 and field3 will run their own calculate script also, for nothing. When only 3 fields are involved, it's no problem. But when you have many it can slow everything down. A script should run only when needed to. In my opinion, the doc-level function/validate event combo is the best solution but just a bit more complicated to understand for a begginer.
... View more