Oct 20, 2021 09:05 AM
I have tables named “Inventory” and “Customer”. What is the best way to create unique price list per inventory record for each customer?
I want to have => inventory A is $10 for customer A and $5 for customer B
Oct 20, 2021 09:43 AM
I would create a third table called “Inventory prices” which links to the inventory item from the Inventory table, links to the customer and has the unique price. Would that work for you?
Oct 20, 2021 06:11 PM
What i get is something like this
Can i make it like this?
Use case: it is easier to upload the latter format to my ERP system
Oct 21, 2021 07:31 AM
The excel sheet is what you’re working with currently? Please explain again (with Airtable exmaple) what you’re trying to achieve :slightly_smiling_face:
Oct 21, 2021 07:30 PM
Do you have a junction table?
If so, do you want to transform that junction table into a pivot table?
However, you cannot convert the results of the Pivot Table app to an actual table/tab in your base.
If your list of customers is small enough and does not change, you could use the junction table and a conditional rollup field for each customer in your Inventory table.
Oct 21, 2021 08:00 PM
Yes i do have junction table named “Price List” and looks like this
I dont understand enough about pivot table. But to be simple, i want to have something like this below picture where i can search the customer name easily