Question about layout

Jaros · 11-18-2021 08:47 AM

I am building a recipe app for calculating cost prices of menu items

I have three tables using the parent child relationship

There is a price list table, and a menu item table.

The menu item table has 10 ingredients columns and 10 qty columns and 10 price columns which use a dereference from the price list table to arrive at the cost per recipe.

In the past the company used a table like the one below to record the cost and profitability of their menu items.

The app is working but because of the nature of appsheet it looks to them to be confusing as this is the format they are used to when reviewing their data.

They are happy with the input method but the review method is not what they’re used to.

Is there anyway to arrange the row of data into a similar format below?

SkrOYC

You need to adapt your data to be kind of compliant to Database Normalization
Check every article on this link and you will have a better clue about how your data should be layout

Steve

Nope.