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
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
------------------------------
Thank you. I will give that a try. I would have never thought about it that way.
Best regards,
Kyle McAfee
Operations Manager
Mobile 973-229-9099
Supor Heavy Haul, LLC
12600 Deerfield Parkway
Alpharetta, GA 30009
Best regards,
Kyle McAfee
Operations Manager
Mobile 973-229-9099
Supor Heavy Haul, LLC
12600 Deerfield Parkway
Alpharetta, GA 30009
Mark,
I have tech support helping me work through your solution. Can you clarify the following step:
"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."
Thanks!!!
Kyle
- MarkShnier__You
Typos corrected below
Create 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 type to formula numeric and make the formula of 1."
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------Mark,
The typos was not hurting us...Just the thought process. We got it working as wanted with you pushing us in the right direction. Thanks. We did 90% of everything you talked about. We literally just finished 5 minutes ago, so I will do a little tweaking and might end up with 100% your thoughts. I will let you know how it turns out, but it basically is what I needed. Thanks for the help.
Kyle