adding dash after 5 character in zip code
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
Forum Discussion
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
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
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
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())}\">"