I'm trying to create a proposal form for our landscaping business. I like to provide a summary of hardscape items, softscape items, and a plant list in addition to the summary page that would pull the totals from each of those pages.
Ideally creating a database of all materials we use where the summary pages pull from and automatically total each item and total each page.
It would also be helpful for efficiency to be able to autofill or pull from a dropdown.
Also if it's possible to hide each line item price except on the summary page.
Create a work order from the proposal form as well from the proposal?
I know I'm asking a lot but any direction would be appreciated!

