Creating a Purchase Order from my Supplier Database

I have a Supplier CRM in a base with tables for Company and Products (linked to the Company table). Can I create an Order Form and fill the fields in the form by selecting the Company Name and the Products I want to order from my Records in each Table?

Ideally, I’d like to create all my Purchase Orders, numbered and dated, and store the Purchase Orders.
A form like:

COMPANY: Joe’s Soap

DATE: [Today’s Date]



7 x Pink Soap
2 x Green Soap
4 x Yellow Soap

Can it be done in Air Table?

1 Like

It would be helpful also for me!

Hi @Wilma_Hartmann
What about a form like this :'s%20Soap&prefill_Date=2020-02-23T00:00:00.000Z

Hey! @Noamsay Your solution doesn’t do the job. What if there are 10,000 products?