October 11, 200223 yr Hi All, I want to write a script where when the script is activated it will move 1 up the alphabet e.g Version field = A (run script) then version = B. i know i could do it using an 'if' statement where if version = A insert B or if version = R insert S. but is there a better way? hope i gave explained this ok!!!
October 11, 200223 yr Try using a single script step, as follows: Set Field ["VersionField", "Middle("ABCDEFGHIJKLMNOPQRSTUVWXYZ", Position("ABCDEFGHIJKLMNOPQRSTUVWXYZ", VersionField, 1, 1) + 1, 1)"] If VersionField is empty when the script runs, it will give you 'A'. If VersionField has 'Z' in it, it will be cleared. Otherwise, VersionField will be incremented onwards one character through the alphabet each time the script runs.
Create an account or sign in to comment