ContributionsMost RecentMost LikesSolutionsRe: QuickBase Scripting & Data Field ValidationDear 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 lengthin 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, RahulSend email notification when user importing the data from excel and duplicate records insertedHi All, In our recruitment tracker application , we have table for Applicants where we are import the data from excel. In excel we are getting the data from multiple sources and also getting duplicate applicants. we need to import all of the applicants including duplicates but somehow want to send notification or high light those records in any report. I am aware of the option to have summary report using unique field to show duplicate records but its not fulfilling our requirement. If it is not possible using native quickbase then could you please guide any approach using scripts ? IOL technique is already configured and also we are using other script to generate unique codes etc. Thanks in advance ! Regards, Rahul