I am trying to create a formula that will only display the first two left characters from a text box. How do I create this?
I assume you want to retain the complete text, but only display the first two left characters. In that case I would create a field that stores the complete text, but is hidden. I used this code in "Trigger after update"...
let txtMyText := Text1;
Text2 := txtMyText;
Text1 := substr(txtMyText, 0, 2)
Perfect thank you!
What I was doing was embedding it into a Printed Form and I just used substr!!
That's what happens when one assumes things! :-D