QuickBase Scripting & Data Field Validation
I understand that there is ability to use ... is it Javascript? ...scripting in QBase to accomplish things that are not straight out of the UI. First question, is this Javascript or something els...
Forum Discussion
Dear Stephen, There is alternative to achieve this requirement using javascript.
Please follow below steps.
1. First Configure Dan's Image onload technique.
2. https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294&_ga=2.233694235.40686674...
3. In your module.js code page , you can write javascript function as below to validate the character length in any numeric field. In field fid_147. if user enters digit more than or less than 6 then it will prompt error and clear the value from the same field.
---------------------------------------------------------------------------------------
$('#_fid_147').focusout(function(){
if ($('#_fid_147').val() != '' && $('#_fid_147').val().length != 6) {
alert('The PID should be 6 character');
$('#_fid_147').val('');
$('#_fid_147').focus();
}
});
---------------------------------------------------------------------------------------
$('#_fid_16').focusout(function(){
if ($('#_fid_16').val() != '' && $('#_fid_16').val().length != 8) {
alert('The FW# should be 8 character');
$('#_fid_16').val('');
$('#_fid_16').focus();
}
});
---------------------------------------------------------------------------------------
I hope this will help you.
Regards,
Rahul
Please follow below steps.
1. First Configure Dan's Image onload technique.
2. https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=294&_ga=2.233694235.40686674...
3. In your module.js code page , you can write javascript function as below to validate the character length in any numeric field. In field fid_147. if user enters digit more than or less than 6 then it will prompt error and clear the value from the same field.
---------------------------------------------------------------------------------------
$('#_fid_147').focusout(function(){
if ($('#_fid_147').val() != '' && $('#_fid_147').val().length != 6) {
alert('The PID should be 6 character');
$('#_fid_147').val('');
$('#_fid_147').focus();
}
});
---------------------------------------------------------------------------------------
$('#_fid_16').focusout(function(){
if ($('#_fid_16').val() != '' && $('#_fid_16').val().length != 8) {
alert('The FW# should be 8 character');
$('#_fid_16').val('');
$('#_fid_16').focus();
}
});
---------------------------------------------------------------------------------------
I hope this will help you.
Regards,
Rahul