Forum Discussion
Mike
5 years agoQrew Member
Wow, I cannot thank you enough for your response, Mark! You've given me hope!! I'm willing to do whatever it takes to make this possible, whether I have to rebuild it or what. Although, the quickbase people helping me build my app have probably done it correctly, I just sort of ran into this and it freaked me out.
I used "items" and "receipt" as sort of a metaphor, but we're actually a painting company. I just didn't know how else to express correctly what it is I/we need for our invoices/estimates/contracts. But same concept: You have rooms to choose from along with room options (bedroom (which bedroom), living room (high ceilings or not), bathroom (which floor, which bathroom), family room, etc), then each room has several options which have options within them (walls (how many, how much), doors, trim, etc).
So we need the invoice to be like:
Bedroom Master Walls Included $200 Trim baseboards Included $100. Total= $300
Livingroom HighCeilings Walls Included $150 Window Frames Not Included $45 Total= $150
TOTAL: $450
Does that make sense? In other words, I do not need the field names in columns like a table, I just need the answers to the form fields listed by themselves.
We have the items in a child table, and the items chosen show up on the parent table in a report that is a table with every single field item listed.
Sorry for the trouble & I can't thank you enough for responding.
------------------------------
Michael Brumfield
------------------------------
I used "items" and "receipt" as sort of a metaphor, but we're actually a painting company. I just didn't know how else to express correctly what it is I/we need for our invoices/estimates/contracts. But same concept: You have rooms to choose from along with room options (bedroom (which bedroom), living room (high ceilings or not), bathroom (which floor, which bathroom), family room, etc), then each room has several options which have options within them (walls (how many, how much), doors, trim, etc).
So we need the invoice to be like:
Bedroom Master Walls Included $200 Trim baseboards Included $100. Total= $300
Livingroom HighCeilings Walls Included $150 Window Frames Not Included $45 Total= $150
TOTAL: $450
Does that make sense? In other words, I do not need the field names in columns like a table, I just need the answers to the form fields listed by themselves.
We have the items in a child table, and the items chosen show up on the parent table in a report that is a table with every single field item listed.
Sorry for the trouble & I can't thank you enough for responding.
------------------------------
Michael Brumfield
------------------------------
MarkShnier__You
Qrew Legend
5 years agoSo, I'm not sure now if you need more help.
The right solution would seem to be to have a Parent table for the Painting Job, and then child line items for the quoted services.
Do you know about relationships? https://help.quickbase.com/user-assistance/about_relationships.html
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The right solution would seem to be to have a Parent table for the Painting Job, and then child line items for the quoted services.
Do you know about relationships? https://help.quickbase.com/user-assistance/about_relationships.html
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------