Hello and welcome @Alyssa!
Airtable’s power is most obvious when introduced into workflows that have many moving parts that all need to be tracked simultaneously. I could see the workflow you are looking for being created in Airtable with a many-to-many relationship and a joins table.
You could create three tables in one base:
- The first table would be Products- which would hold a product, price, and it’s description.
- The second would hold Clients and their information
- The third table would represent Orders - which would link link the product and list the quantity needed, and link the client purchasing the order.
I understand if this isn’t the workflow you are looking for though—and would love to know a little more about what you’d like to final product to look like? Would you like one table with all an order’s information listed? That could definitely be accomplished using multiple fields!
I also recommend checking out the Airtable Universe for examples of workflows created by other users to track any and everything.
Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .