User specific columns? Pricing

Hello again,

I am working on a glide app for my business.
We have several customer types, each of which receive different pricing for the same material.

In my workbook I have two tabs, one for users, and the other for products.
The user tab classifies customer types, and I was wondering if could use this information to filter the columns of pricing in the products tab to a specific customer type.

In your products sheet, inside the Editor, you can have:

  • A template column to take in the customer type for the signed-in user. (assuming you turned on user profiles already)

  • An If Then Else column to bring in your logic for the price (I think it’s some sort of multiplier?)

  • Make a math column to multiply the base price with the multiplier and show it to the signed-in user.