Need Opinion/Suggestion for Quotation System Design

[EugeneB]

Would like to develop a quotation system to allow multiple quote items. What is your recommendation on the database/system design.

Similar to the sample app - Quote Generator however this is only one quote item per quotation but we would like to have multiple quote item per quotation.

one of the idea is to have

1. multiple columns field for each quote item but this we will be limited by number of quote item per quotation. (based on the max column field we created)

any other idea / suggestion do we have to cater for this requirement?

[Lynn]

Hi @EugeneB
Did you have a look at the Quote and Proposal sample app, it may help.

[EugeneB]

Yes, but the quote and proposal app is only quote one item. was looking how we could do it better for multiple item quote.

[Brand-It]

Here is a good help document for you to start…

help.appsheet.com

The "Item-Detail" Data Pattern

A classic data model pattern to capture many Detail records that correspond to a single Item record

Unfortunately the link to the ‘Order Capture Sample App’ seems to be broken. That sample app was very helpful me.

[EugeneB]

Thanks @Brand-It the sample app https://www.appsheet.com/samples/An-app-for-managing-customers-products-and-orders no longer available.

do you know any sample app, has the similar scenario?

[Brand-It · Accepted solution]

This one is also pretty similar…

https://www.appsheet.com/Template/AppDef?appName=OrderCaptureHow-to-71626#Data.Tables

[EugeneB]

Thanks @Brand-It this is good example, where do you find this? can’t seem to find this from the sample app Copy & Customize Sample Business Apps

[Brand-It]

You’re welcome…

[Steve]

https://www.google.com/search?q=site%3Aappsheet.com+sample+app