Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoTypically in the proper design of an app you will have a parent child relationship. That means that one invoice will have many line items. So that way the users will add the line items that they need as a trial table and those children will display on the parent form.
It is unusual to have a company where there are so few different SKUs sold that you can actually list every possible SKU write on the invoice.
But if you do not want to re-design your app or in your use case it is appropriate to literally list every SKU on the form then the easy solution is to have two different forms.
Do you have more than one form there is a setting that comes up called forms usage and you can send a different form to be used in View and Edit and Add.
The ADSD and Edit form would be your complete form.
But the view form would have dynamic form rules. In fact it would have a bunch of them.
Fortunately when you make a dynamic form or you can copy it.
So Rule 1 will be
When Qty Item 1 equal zero
Action
Hide Item 1
Hide Qty Item 1
Hide Price Item 1
Hide extended price Item 1.
be sure to check the somewhat hidden checkbox at the bottom of he form rule to collase space on hidden fields.
Your rule number one done perfectly then you can copy it and change everything to refer to item 2.
However before you dig the hole deeper reconsider whether it would be better to design your app "properly quote and have the users add child records one by one for the items they need. The problem with your solution is that does not seem scalable as the number of SKUs grows.
Problem with your approach is that sales analysis will be brutally difficult. That is because you do not have a dedicated table of line item so as soon as you turn around and say you want a sales report by item you will be not able to do that at all.
Just point out once again that not having a child table for items is quite unusual and while not necessarily wrong you need to know what you're doing and not just accidentally do it that way only to realize a month from now that you regret that choice and now have to tear apart the app to rebuild it.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
It is unusual to have a company where there are so few different SKUs sold that you can actually list every possible SKU write on the invoice.
But if you do not want to re-design your app or in your use case it is appropriate to literally list every SKU on the form then the easy solution is to have two different forms.
Do you have more than one form there is a setting that comes up called forms usage and you can send a different form to be used in View and Edit and Add.
The ADSD and Edit form would be your complete form.
But the view form would have dynamic form rules. In fact it would have a bunch of them.
Fortunately when you make a dynamic form or you can copy it.
So Rule 1 will be
When Qty Item 1 equal zero
Action
Hide Item 1
Hide Qty Item 1
Hide Price Item 1
Hide extended price Item 1.
be sure to check the somewhat hidden checkbox at the bottom of he form rule to collase space on hidden fields.
Your rule number one done perfectly then you can copy it and change everything to refer to item 2.
However before you dig the hole deeper reconsider whether it would be better to design your app "properly quote and have the users add child records one by one for the items they need. The problem with your solution is that does not seem scalable as the number of SKUs grows.
Problem with your approach is that sales analysis will be brutally difficult. That is because you do not have a dedicated table of line item so as soon as you turn around and say you want a sales report by item you will be not able to do that at all.
Just point out once again that not having a child table for items is quite unusual and while not necessarily wrong you need to know what you're doing and not just accidentally do it that way only to realize a month from now that you regret that choice and now have to tear apart the app to rebuild it.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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__You5 years ago
Qrew Legend
So, 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
------------------------------