Hello i made a virtual column of( Size ) but want know how make it work

[Hassan_Tanna]

Hello i have a size column in a products table and made a virtual column of( Size ) in a purchases table but want know how make it work ! What should i do !

 

 

[Joseph_Seddik · Accepted solution]

Your should organize your data as follows:

Product Sizes Table:

You should create this table. Columns should include: Product Name (for example 1300, 1800, etc.), Size, Price, Stock, Restock, Minimum Order, and all other data that changes according to the Size of the Product.

Here you create one row for each available size for each product: 

For example:

prodSizeKey	Product Name	Size	Price	Stock	Restock	Min. Order
	1300	M	200	15	5	2
	1300	XL	250	20	5	2
	1400	S	150	3	2	1
	1400	L	200	12	5	2
	1400	XL	250	7	3	1

Products Table:

Remove all the columns that we have already included in the previous table. This table should only include the data that is dependent on the product itself regardless of its size, like for example, its photo and its provider. 

Orders Tables:

This should NOT include details about the product, so you should remove: Product ID & Quantity

Order Details Table:

The Order Id column should reference the Orders Table. Another column prodSizeKey should reference the Product Sizes Table. This table should contain the column Quantity and the Total price for this item. The Size column should be completely removed from the table as it is redundant. While the State and Team Member columns should be moved to the Orders Table not here. 

-----

Do these changes to your data before working on the app. I also strongly encourage you to read this short guide and follow the links inside, you really need to understand the point here:

https://help.appsheet.com/en/articles/895267-data-the-essentials

All the best!

تحيا مصر!

[Joseph_Seddik]

You are making this column have a fixed TEXT value for all rows that is "SIZE".

First, make it a normal column and remove the app formula. 

[graham_howe]

Actually it looks like SIZE is the name of a slice and this column is trying to reference that. I agree that the formula needs to be changed, but I think the purpose might be a drop down list to allow a valid size to be selected. If that is the case then we need to know a bit more about the tables and their relationships.

[Joseph_Seddik]

Look at the second photo closely, he has already referenced the slice. 

[graham_howe]

Agreed, that's what prompted my question, if it is a ref to another table, then I would expect that either the user needs to select the size, or, if it is pulling the size from the product table, then the formula should probably be something like Product[SizeID] depending on the table and field names.

[Joseph_Seddik]

I don't think one even needs a formula for that 🙂

[Hassan_Tanna]

i think its work now 

@Joseph_Seddik @graham_howe 

[Hassan_Tanna]

but i have another problem when i make order show me as explmle product code 1300 but i have from this product all the size L m XL i want when i choose the product be specific  if M OR XL @Joseph_Seddik @graham_howe 

[Joseph_Seddik]

Hi Hassan, I think you might have a problem with your data. Please show us screenshots of your source sheet. Thank you.

[Hassan_Tanna]

products 

purchases

orders 

 

order details

 customers 

@Joseph_Seddik @graham_howe 

[Joseph_Seddik]

and what is in the slice Size?

[Hassan_Tanna]

i dont have i deleted it because i thought i made it wrong , should i have slice size !

[Joseph_Seddik]

I have to ask you again. Please show us your data sheet. Thank you.

[Hassan_Tanna]

the sheet 

[Joseph_Seddik · Accepted solution]

Your should organize your data as follows:

Product Sizes Table:

You should create this table. Columns should include: Product Name (for example 1300, 1800, etc.), Size, Price, Stock, Restock, Minimum Order, and all other data that changes according to the Size of the Product.

Here you create one row for each available size for each product: 

For example:

prodSizeKey	Product Name	Size	Price	Stock	Restock	Min. Order
	1300	M	200	15	5	2
	1300	XL	250	20	5	2
	1400	S	150	3	2	1
	1400	L	200	12	5	2
	1400	XL	250	7	3	1

Products Table:

Remove all the columns that we have already included in the previous table. This table should only include the data that is dependent on the product itself regardless of its size, like for example, its photo and its provider. 

Orders Tables:

This should NOT include details about the product, so you should remove: Product ID & Quantity

Order Details Table:

The Order Id column should reference the Orders Table. Another column prodSizeKey should reference the Product Sizes Table. This table should contain the column Quantity and the Total price for this item. The Size column should be completely removed from the table as it is redundant. While the State and Team Member columns should be moved to the Orders Table not here. 

-----

Do these changes to your data before working on the app. I also strongly encourage you to read this short guide and follow the links inside, you really need to understand the point here:

https://help.appsheet.com/en/articles/895267-data-the-essentials

All the best!

تحيا مصر!

[Hassan_Tanna]

thank you so much for helping me appreciated 

تحيا مصر 

[Hassan_Tanna]

the Product Sizes Table. This table should contain the column Quantity and the Total price for this item

could you please tell me the expression how it will be ! 

[Joseph_Seddik]

The expression for which column please?

[Hassan_Tanna]

prodSizeKey In order details  column 

[Joseph_Seddik · Accepted solution]

No formula here, just a reference to the new Product Sizes Table. This column will allow the user when he is filling the form to select a Product and One of its available sizes. 

Other columns in the same table Order Details:

- OrderID - just a reference to the Orders Table. The column also have IsPartOf option checked. 

- Quantity - user enters the desired quantity of the selected product

- Total Price: A formula multiplying the Quantity and Price of selected item, it can be: [Quantity]*[prodSizeID].[Price]

You should NOT miss reading this:

https://help.appsheet.com/en/articles/961426-references-between-tables

[Hassan_Tanna]

great thank you so so much 🙂