Display first two characters
S

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?

Ninox Profile

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)

S

Perfect thank you!

What I was doing was embedding it into a Printed Form and I just used substr!!

Ninox Profile

That's what happens when one assumes things!  :-D

Reply