ContributionsMost RecentMost LikesSolutionsRe: How to prompt the user if the sum of specified fields is not equal to 100% ?Well many users do find the click-and-drag Quick Base formulas more intuitive than scripting. And "do it yourself" is more than a marketing pitch -- its a real value than even teams with smaller budgets can appreciate. But I do think your quote is the most important thing I have ever read on these community pages: "With the passage of time theQuickBase Singularityhas arrived. We are converged and everything is now possible with QuickBase (using script).Re: How to prompt the user if the sum of specified fields is not equal to 100% ?Your point is well-taken, Dan. But remember that part of the Quick Base pitch is that teams can quickly build most of their applications "without writing code". If I start presenting script macros as the solution to routine problems, that "no coding required" value disappears. My current clients have no scripting skills and want to manage their applications without paying for those skills.Re: How to prompt the user if the sum of specified fields is not equal to 100% ?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.Re: How to prompt the user if the sum of specified fields is not equal to 100% ?Thanks, Coach. I will explore these options.Re: How to prompt the user if the sum of specified fields is not equal to 100% ?Sorry Dan, I was so distracted by your Meatloaf graphic that I missed the Pastie Database link. I have now made my way back to that and see the script you used for this quickie demo. Alas, it is beyond my ability. (I use Quick Base to avoid writing code whenever possible.)Re: How to prompt the user if the sum of specified fields is not equal to 100% ?Hot patootie � bless my soul" this might work for us. Did you build this with simple calculated fields, or within Dynamic Rules? (I have a limited view of this demo app and don't see any way to grab the administrator view.)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 prompt the user for corrections when the total is incorrect? I guess we could use "Dynamic Rules" to throw up a custom error message under those conditions, but we would rather require the user to get that total correct before they save that record. I feel certain we are not the first or only customer to need this feature...