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
etc
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
etc
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?
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
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
The excel sheet is what you’re working with currently? Please explain again (with Airtable exmaple) what you’re trying to achieve
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.
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
Use case:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.