Clear a date field when a new drop-down selection is made
Every department has a report to track incoming communication. On the report, I've created buttons to quickly track the communication process. When a new record is appears, the department clicks the '...
Using script and the IOL technique you can easily implement a generic technique that will allow you to add custom parameters to the common record manipulation URLs. In particular you can add the desired functionality to initialize field value of the ?a=er URL. Here is a demo and screenshot showing editing the first record with and without the custom _fid_* URL parameters::
(1) The code in the pastie is generic and can be used to implement this functionality for any table or set of fields.
(2) The IOL field is included only for ?a=er pages
(3) This technique of adding custom properties and parsing them out in script to perform some useful action can be extended to many other use cases. For example you could easily arrange to pass the name of a code page with a parameter &script=myscript.js and within with the IOL module.js page just insert a generic $.getScript() to load the script passed in the URL.
Once I come up with a snappy name for this technique I will add it to my forthcoming QuickBase Swimlane Catalog (it's big and chocked full of goodies):
FWIW, I modified the code to do a destructuring assignment as indicated below::
(function(){ var querystring=document.location.search; if(/a=er/i.test(querystring)) { var params = new URLSearchParams(location.search); for (var [fid, value] of params.entries()) { if (fid.indexOf("_fid_") == 0) { $("#" + fid).val(value); } } } })();
