Forum Discussion

WaynePendley's avatar
WaynePendley
Qrew Trainee
8 years ago

How to prompt the user if the sum of specified fields is not equal to 100% ?

We want to include some automatic checking of date entry errors, and in one of our apps we need to have the sum of several fields that the user enters total to 100%.  What are some efficient ways to p...
App builders
Formulas and functions
Tips and tricks
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
How about just converting QuickBase's inputs to sliders (ie <input type=range>):



A Plate Full Of Sliders ~ Add New Record
https://haversineconsulting.quickbase.com/db/bm5k6564x?a=nwr

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=606



Notes:

(1) I only implemented this feature for new records. Simple to extend for edit records.

(2) The code could be improved but I was short time and needed to make a quick road trip to White Castle.
WaynePendley's avatar
WaynePendley
Qrew Trainee
8 years ago
This is impressive, but too twiddly to throw in the user's workflow.  I'm looking for simple, vanilla error-checking on their totals.  I wouldn't want to build a custom GUI control.