InfoPath Dev

I have a field for SSN.  Sometimes, we get request and the user only knows the last four of a SSN and sometimes they know the entire SSN.  I want to create a rule that pulls the last 4 digits of this number.  So if it is 9568 or 111119568, the field will display the same response. 

 Awesome.  That worked like a charm.  I was also able to add the same rule to the table and users are not able to delete the previous field.  Thank you very much.

 Thanks Hilary.  I was able to get the incremental value added and I copied your disable rule.  I am missing why my table isn't disabling the previous value, but yours is.  I have attached the file back to this email with my table.

I am looking for two solutions.  I am wanting an id number to display on a repeating table and increment by 1 each time a new row is add.  When the next number is greater than the previous number, I want it to disable a comment field for that previous value. 

 Yes, I agree. The field will definitely be more than 256 characters. Is there a way to only pick one field on the repeating section and merge it any time a new table is created.  I uploaded a copy of my IP.  I would like to merge my Requested Facility, Date/Time Fax Sent Out, and decision to one field from the Transfer Out ...

 Thank you Hilary.  I ended up using a Drop Down for Hour and a drop down for minute pulling from a support list.  Then concat it to a field. 

I would like to format my Date/Time field into this format: mm/dd/yyyy HH:MM (AM/PM).  I found this solution, but getting an error for some of the quotations: concat(substring(MyDateTime, 6, 2), “/”, substring(MyDateTime, 9, 2), “/”, substring(MyDateTime, 1, 4), ” “, substring(MyDateTime, 12, 2) mod 12 + 12 * (substring(MyDateTime, 12, ...

Hi Group,  I have created a repeated section on my form.  I know you can merge repeating tables, but can you merge repeating sections.  Then I would like my output to resemble as shown below on my SharePoint Library: Name: Joe Smith Address Line 1: 123 Rose St City: Jacksonville St: FL Zip: 32456 Name: John ...

 As always, thank you Hilary.  I did find this solution: boolean(.. >= 5 and .. <= 7) or boolean(.. >= 15 and ..<=16) or boolean(.. = 25)    

I am looking for a Boolean rule that determines if a value is >= to 4 and <= 7.  How would I write this statement?