Set up an auto-enter calculation in field options:
Let ( values = Substitute ( self ; "/" ; ¶ ) ; // make it a list of values for easier value access
If ( GetValue ( Values ; 1 ) = GetValue ( Values ; 2 ) ; GetValue ( Values ; 1 ) ; self )
And clear the "Do not replace existing values..." check box.
so it works if there are the same values one either side of the slashes, which is what I wanted.
but if the values don't equal each other it (like "2/5") it makes it "25", when it should be "2/5"
mmmm in Phil's If statement I'd suggest that the last argument is (Middle (self,1,1) & "/" & Middle (self,2,1)) which concatenates the 2 and the slash and the 5 BUT will the numbers always be single digits ?
Sounds like your field is type number. It should be of type text since you are entering text as well as numbers.
Since the expression resturns "self" if the values are not equal, there shouldn't be any change in what data was entered--which is what will happen with a field of type text.
YUP! Fixed it!
Thanks a bunch!