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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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