This seems elementary, but I can't find anything about it and have tried every combination I can think of. I've got a field I want to trim, perform a Let function in and have text "Wrong Format" in the field if the user doesn't enter the correct info for the Let function. In what order should these steps be performed? I would think in as I've listed them, but can't get it to work. Should there be a Remove Text or Reformat Text in there somewhere? Is there a guide somewhere that shows the order functions should be performed? Thanks.

The order of functions depends on the situation. In some cases it doesn't matter, in others changing the order gives different results. If you can show the possible combinations of inputs along with what the desired results should be, we may be able to give you a specific answer.

This is the shortest example I have. The Let function produces 5 digits if that's all that's entered and 9 if all 9 are entered. I'm trying to make sure the Wrong Format is brought up if the user happens to enter more than 5 but less than 9. Thanks, Ender.

TrimAll( Work Zip Code ; 1 ; 0 ) /*remove all extra spaces*/

_________________________________________________________________

Let ( [tempZip = Filter ( Work Zip Code ; "0123456789" ) ];

Left ( Work Zip Code ; 5 ) &

If ( Length ( tempZip ) = 9 ; "-" & Right ( tempZip ; 4 ) ; "" ) )

_________________________________________________________________

TextColor("Wrong Format"; RGB(250 ; 0 ; 0)