Forum Discussion

AlfaCenterLawGr's avatar
AlfaCenterLawGr
Qrew Member
2 years ago

Social Security Number typing and saving...

Hi, and many thanks for your help, we appreciate it

We are not the best coding so we will try our best.

We are a attorney at law office and we register all info about our customers, including the Social Securty Number (SS#), as probably you all know, the formatted way to type it is "###-##-####)  but we created a text field that has no format, and our people just type in the fastest way they can, so we got some registry typed as (#########) or (#### - ####) and that is not the correct way to keep a Social security number.

So, the question: is there a way to created a autoformat field like the "date" field, that, when someone type the number it just auto correct to (mm-dd-yyyy), no matter what you type in, it autocorrect himself? - I been trying and reading other post but can not figure out. 

We would preffer a autocorrect field, that corrects himself on the form, not creating another field that with a formula "totext" converts the exiting field on form and then converts it to formmated text in another field to display. (mainly cause no one will know how it will be saved until you already save the registry)

Many thanks. (We do not even know if this is possible, we are open to other smart solutions)



------------------------------
AlfaCenter LawGroup
------------------------------
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    2 years ago

    One option is three fields on the form  with dictated lengths

    XXX

    XX

    XXXX

    then a formula field to put the pieces together



    ------------------------------
    Don Larson
    ------------------------------

    • AlfaCenterLawGr's avatar
      AlfaCenterLawGr
      Qrew Member
      2 years ago

      Thank for your time Don,

      We figure out that we were hoping too much, so trying to resolve we did what you said before with next formula text field:


      var text PartOne = Left([SS#],3);
      var text PartTwo = Mid([SS#],5,2);
      var text PartThree = Right([SS#],4);


      List("-", $PartOne, $PartTwo, $PartThree)

      It is working fair good enough, but we facing the following now; Some SSN were written like ( ###,###,###) so, the new field keep them as (###-##-,###). That take me to question, is there a way that formula void (, / . ) symbols?

      We appreciate your time Don, and else others.



      ------------------------------
      AlfaCenter LawGroup
      ------------------------------