I intend on recreating my company’s current system in Airtable.
I have two separate departments that share the same customers. How could I create one base for each department but having a shared table of customers? Furthermore, both departments shoul...
Because we control serial numbers for much of our products, I have one separate line for each purchased item. This means for the majority of items I can’t have qty>1. But I want to generate a Purchase Order pdf showing the sum of each product, to sen...
Hello! I searched for this, but I could only find similar results – but not the result I need.
I have a Purchase Order table and a PO_ITEMS table where I create one line for each item I’m buying. I need to control serial numbers of these items, so ea...
Hello y’all!
I’m trying to run an automation on multiple linked records from one record, but it doesn’t work because the action expects one record id.
Do you know a way to achieve this?
My scenario is this:
I have an invoice linked to multiple purcha...
I’m setting an automation to copy a value from a lookup field (formatted as currency) to a currency field.
The tests run fine, but the automation doesn’t get the value from this lookup field when it goes live. It works if I set a manual value in the ...
It makes sense. I’ll try in a test database, but it will result in more work or I’ll have to find a way to create the Serial Numbers lines automatically.
I’m trying to do it in Page Designer. But it only shows the lines for each order item. It doesn’t sum them.
You can see it in the example below. It’s the same product, but it shows each purchase order line. I need it to sum all the quantities for the...
Hey @ScottWorld , thanks for taking your time.
What you described is what I currently have and what’s depicted on the image I sent. The issue is the table in Page Designer shows every record in PO_ITEMS and not a summary of them. For instance, it doe...
