Jump to content
Sign in to follow this  
jbullydawg

Print Script

Recommended Posts

This might be a bizarre question but I'll try it out nonetheless:

I have a layout we print quite a bit. The primary key is the SSN but we've slowly been moving to a new system where it's a 9 digit number but begins with a 9. So, new identifiers look like this 9xx-xxx-xxx.

Is there a way when printing the form to control whether or not the SSN prints or not? If the field contains the new identifier (9xx-xxx-xxx) we want it to print but if it doesn't we would prefer it not print at all.

thanks.

Share this post


Link to post
Share on other sites

Hi

create a new calculation field, SSNtoPrint:

Case(

lenght(SSN) = 9 and Left(SSN;1) = 9 ; SSN

)

and put this field in the form to print.

Share this post


Link to post
Share on other sites

Length in not going to really help you in this case since even if you use a filter for numbers, the difference can be just the location of the dash or typos.

Try this instead:


Let ( [ f= SSN;

        x= Substitute ( f; [0;"^"]; [1;"^"]; [2;"^"]; [3;"^"]; [4;"^"]; [5;"^"]; [6;"^"]; [7;"^"]; [8;"^"]; [9;"^"] ) 

      ]; 

        Case ( x = "^^^-^^^-^^^" and Left (f; 1) =9; f )

     )



Share this post


Link to post
Share on other sites

It would have been better to enter the new ID number into a separate field. In any case, it seems that a string that begins with "9" cannot be a valid SSN, so

Case ( Left ( SSN ; 1 ) = "9" ; SSN )

should suffice.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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