User settings: Were a User can set own markup percentage on products

[Arthur_Siloka]

Hi, I have a product catalog app where I want users to set their own listing prices on the products. For instance, on the app, a product is listed to $10 and a users wishes to add another $3 (30%) to mark a profit, how can I achieve this?

I have set up a product table with my listing price and settings table with useremail and user profit percentage. I want the user retail price (ie, $13) to show on the product detail page.

I have tried, using user settings but it’s not working somehow.

Anyone with answers? Thanks

[tony1]

@Arthur_Siloka What about something like this? Your products table has a Base Price column and your user settings has a Profit Fraction (e.g. 0.1 means 10%). Then you add a virtual column to your Products table with the formula [Base Price] * (1 + USERSETTINGS("Profit Fraction")).