Report
How would I build a report that will ask user a [Percent of Weight] then ask user for the [Weight] and then display in a summary report showing items that are X% more to X% less?
I have the fol...
Forum Discussion
Follow up to my post – If a user could just type in the weight and the report would show everything sorted by how close the weight is, that would be just a good. Another words, it would show items with exact same weight followed by items that are one pound heavier and one pound lighter and so on. If that is an easier solution, I am fine with something along those lines. Just an idea. Thanks.
| Kyle McAfee Estimating & Database Design
SHH Logistics LLC 15171 Cronewood Lane Memphis, IN 47143
Phone: 812.989.4171 / 973.229.9099
|
WBE Certified Business
|
MarkShnier__You
Qrew Legend
Qrew Legendnp,
Create a helper table called Weight Finder.
Create those two fields in that table for the Weight and %.
One record to the table and then lock down permissions that no one, not even the admin can add or delete that single record. The single record will of course be record ID equals one.
Ate a relationship down to your details table. Let the system create a field for you and then rename the field to be called [Link to Weight Finder (=1)] Change the field tape to formula numeric and make the formula of 1.
Great. Now every detail record is linked to your weight finder and you can look up the weight and the percent down to your detail table and create a formula that down there which will do the math. Do any calculations.
Then put an embedded report on the Weight Finder of the detail records and use the sorted report.
The effect will be the user will enter their values, save the weight finder record and the results will be right on the weight finder record as an embedded child table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Create a helper table called Weight Finder.
Create those two fields in that table for the Weight and %.
One record to the table and then lock down permissions that no one, not even the admin can add or delete that single record. The single record will of course be record ID equals one.
Ate a relationship down to your details table. Let the system create a field for you and then rename the field to be called [Link to Weight Finder (=1)] Change the field tape to formula numeric and make the formula of 1.
Great. Now every detail record is linked to your weight finder and you can look up the weight and the percent down to your detail table and create a formula that down there which will do the math. Do any calculations.
Then put an embedded report on the Weight Finder of the detail records and use the sorted report.
The effect will be the user will enter their values, save the weight finder record and the results will be right on the weight finder record as an embedded child table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------