Forum Discussion
_anomDiebolt_
8 years agoQrew Elite
>... too dangerous to change the user's actual input ...
>... never really being sure what the user entered ...
Human input should always be verified and changed if incorrect, in the wrong format or if a typo is detected. Luckily it is simple to do with script. Here is the core code (for use with IOL) for negating the number entered by your human:
>... never really being sure what the user entered ...
Human input should always be verified and changed if incorrect, in the wrong format or if a typo is detected. Luckily it is simple to do with script. Here is the core code (for use with IOL) for negating the number entered by your human:
$("#_fid_6").on("change", function() {Using a formula to do this only bloats your application with superfluous fields (assuming there is no need for retaining the human's original keystrokes).
$("#_fid_6").val(- parseFloat($("#_fid_6").val()));
});
- HillaryWhitney5 years agoQrew CadetWhere would I place this script to change my field to a negative? Do I need to change my field type from currency to formula - numeric?
------------------------------
Hillary Whitney
------------------------------- MarkShnier__You5 years ago
Qrew Legend
One way is to create a new formula field with the formula
-[field which is positive]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------