I'm examining Knack as a potential for my company to use as a replacement to spreadsheets for managing our prospects price quotes. We currently use google sheets. We have a default template for our building configurations that we duplicate for each new quote and then tailor it to the customer's particular needs. I am looking for more of an database solution that combines the efficiency of relationships with the flexibility of a spreadsheet. Ideally, I would like to create a new prospect record, click add new quote and have a editable table of building components (roof, walls, size, etc). I would also want the prices of these options to be automatically entered based on various rules and price table lookups.
Can Knack do all of this?
This is an example of the default items that are normally in a building.