Hi-

I've just purchased the plug-in. I'm trying to replicate an Excel spreadsheet I have designed to calculate cost of a recipe (for baking). I have a question. 

I have designed a table called Product List, which lists: product name, manufacturer, date purchased, price, weight of the product. The last column calculates product price per 1g of weight. This table is user restricted - so each user can only edit and see their own table.

I'm trying to create a second table which will calculate the price for the recipe, based on the product prices entered in the Product List table. Basically, I'd like a user to be able to pick a product from a dropdown list (list of products entered in the first table, Product List table), enter the weight used in a recipe, and then have a column which will calculate the cost per weight used in the recipe. So 3 columns: Product name, weight, price where product name is selected from a drop down list, weight is entered by the user, price is calculated (weight * price per 1 g from Product List table).

Also, the second table would calculate price for the recipe based on the logged in user's Product List table.

How can I create the second table to perform these calculations?

I have attached screen shoots of my tables I designed in Excel. There, I had one table for the list of products. Second tab was calculating recipe cost based on the products chosen.

Here is a link to the Excel file. https://akademiatortu.pl/wp-content/uploads/Wycena-przepisu.xlsx

Thank you. Unfortunately it will not work simply because it can not calculate a sum under a calculated function column.

I have also tried creating a table with MySQL call to database, but unfortunately I cant add columns to that table where user could add his own data as well.

I'm afraid this plugin will not work for me. How can I request a refund? I only just purchased the plugin. Thank you.