Discussions

 View Only
  • 1.  adding dash after 5 character in zip code

    Posted 06-14-2017 14:00
    I have a address field and which  is having postal code as a sub field , so my question is like after i am entering 5 numbers a dash symbol must come. Do  i have any native QuickBase option


  • 2.  RE: adding dash after 5 character in zip code

    Posted 06-14-2017 14:08
    I presume you are talking about Zip + 4 where there is an optional suffix.

    one suggestion is to have the Zip field be called [Zip 5] be a text field and set the field properties to limit to 5 characters.  Then have a field called [Zip 4] and limit to 4 characters.  Show these in add and edit mode.

    Then have a formula field

    List("-", [Zip 5], [Zip 4])

    This presumes that your data entry is by hand and not imported.


  • 3.  RE: adding dash after 5 character in zip code

    Posted 06-14-2017 14:14


  • 4.  RE: adding dash after 5 character in zip code

    Posted 06-14-2017 14:14
    I was asking like this . Do i have any native Quick Base option


  • 5.  RE: adding dash after 5 character in zip code

    Posted 06-14-2017 15:06
    I don't think so.


  • 6.  RE: adding dash after 5 character in zip code

    Posted 06-14-2017 14:34
    If there is any native quick base option Please let me know that one


    Other wise using javscript we can do this one

    $("#_fid_45").keyup(function() {
        let val = $(this).val();
        if(val.length > 5) {
            let digits = val.split(/(\d{1,5})/);
            let str = "";
            for (let group of digits)
            {
              if (/^\d+$/.test(group))
              {
                str += group + "-";
              }
            }
            str = str.substring(0, str.length - 1);
            $(this).val(str);
        }
    });

     Insted of _fid_45 give your fid Id


  • 7.  RE: adding dash after 5 character in zip code

    Posted 06-14-2017 18:14
    How and where are you referencing this JS? 
    So I am assuming you create a Formula Text field with HTML enabled and writing this piece of code? But where are you calling it from?


  • 8.  RE: adding dash after 5 character in zip code

    Posted 06-16-2017 11:11
    Using IOL Technique.
    Create a formula text field and have the below code

    Create a page in Pages name it module.js and have the above code
    with field id replaced. Then it will work ,You can name the page
    whatever but you need to make the same name on the formula Field


    "<img qbu=\"module\" src=\"/i/clear2x2.gif\" " & "onload=\"javascript:if(typeof QBU=='undefined'){QBU={};$.getScript('" & URLRoot() & "db/" & Dbid() & "?a=dbpage&pagename=module.js&rand='+Math.random())}\">"