April 12, 200520 yr I have a text field that is blank at the start. When you press a button and the field is blank it add the letter "A". What I want then is if you press that button again the letter will become "B" and so on. I could write it out of course. Case ( field = A ; B ; field = B ; C and so on ) Is there a better way to write? TIA
April 12, 200520 yr Try Set Field[] with the following calculation: Let ( [ alpha = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; pos = Position ( alpha ; field ; 1 ; 1 ) ; len = Length ( alpha ) ; next = Mod ( pos ; len ) + 1 ] ; Middle ( alpha ; next ; 1 ) ) This will rotate the alphabet in a loop.
Create an account or sign in to comment