Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How do i create order records in order table from product table with button

Solved
Jump to Solution
350 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello
I have a product table. And want to use a button to order the products. And then create order records in order table (pulling 3 columns from product table) and link the two tables. product id - order id

need some help im green

John

1 Solution

Accepted Solutions

Exactly what i need, thx for the help. Perfect

See Solution in Thread

2 Replies 2

The three fields which pull information from the products table should probably be Lookup fields, which will pull in data automatically once the order has products linked to it.

Assuming you only order one product at a time, you could use a script like this one in a Scripting block:

let ordersTable = base.getTable("The name of your orders table")
let productsTable = base.getTable("The name of your products table")

let product = await input.recordAsync("Select a product", productsTable)

await ordersTable.createRecordAsync({
    "The name of the field which links Orders to Products": [{id: product.id}]
})

Then you could add a Button field to your products table and use that to run the above script.

Exactly what i need, thx for the help. Perfect