Help

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

Solved
Jump to Solution
803 2
cancel
Showing results for 
Search instead for 
Did you mean: 
john_klacynski
5 - Automation Enthusiast
5 - Automation Enthusiast

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
john_klacynski
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

john_klacynski
5 - Automation Enthusiast
5 - Automation Enthusiast

Exactly what i need, thx for the help. Perfect