Ability to set min/max on custom fields when the Field Type is Number
For custom fields where the Field Type is set to Number, we would like the ability to set minimum & maximum values for the data entered.
For our use case, we are trying to record the number of residents within a given encampment who are either engaged or not engaged based on their current sleeping location. However, the field currently allows negative numbers to be recorded which should never be the case and would negatively affect our client counts in Looker.
Allan Hong
shared this idea
-
Glenn Gonzalez commented
This feature would be great for data quality. Allowing negative number causes reporting discrepancies.
-
Wendell Kirkman
commented
This would be incredibly useful - we consistently are having issues with users recording negative counts of individuals, and every provider has asked us to implement constraints, but we currently can't.
This is made much worse by the scroll wheel functionality - people scroll down on the page and just change the value they just typed into a negative value instead.
-
Kim Griffith commented
This would be so helpful, and create accurate data reporting.