Add Support for Line Items and Printable Order Forms

[Sohail2949000]

1. Problem Statement
   Currently, our team uses Teable as our central hub for tasks, inventory, and tickets management. However, we are forced to use a separate, external Order Management System because Teable lacks a critical function: the ability to add multiple products or line items within a single order record. This fragmentation creates inefficiency and prevents us from having a true all-in-one workspace. Furthermore, we cannot generate a clean, printable order form directly from Teable.

2. Proposed Solution
   We request the development of a native Line Items feature. This would allow users to:

Create a single "Orders" table.
Link each order to a "Products" table.
Add multiple products to one order form within a dedicated sub-view or section, specifying quantities, prices, and discounts per item.
Automatically calculate the order total based on the line items.
Generate and print a professional PDF order form directly from any order record.
This solution would consolidate our operations into Teable, eliminating the need for a separate system and improving our workflow significantly.

3. Considered Alternatives

Airtable: While it offers similar functionality, its pricing model is prohibitively costly for our team size.

Google Sheets: We are currently using a manual workaround with Sheets, formulas, and App Scripts. This is error-prone, difficult to maintain, and lacks the database power and interface of Teable.

4. Additional Context
   Our team heavily relies on Teable and believes this feature would be a transformative addition for any business handling orders, invoices, or any record that requires a one-to-many relationship (e.g., invoices with multiple items, bills of materials, event registrations with multiple guests).

[NickCrews]

Can you make a new table called "Lineitems" which has columns

• M:1 relationship with the "Orders"
• M:1 relationship with the "Products" table,
• discount
• quantity
• etc

?