Jump to content
Server Maintenance This Week. ×

Order of functions in defining fields


This topic is 6536 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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)

Link to comment
Share on other sites

This topic is 6536 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.