New appsheet app

[Fouad_H_Saad1]

Please, I want to create new app used in food delivery.
One of the app field contain Enumlist for food types e.g (field#1), another field contain Enumlist for food prices (field #2), and 3rd field is (field #3) to summation the total cost of menu.

My question is how to connect those fields above? Where the app will record the price of food automatically (in field #2) when customer record in field #1? Also I want to take consideration if the customer record more than 2 types of food in (field #1).
Thanks for all

[Aleksi]

So… you would like to sum costs when the user has chosen foods with the field #1?

[Fouad_H_Saad1]

Thank you Aleksi.
If the customer request many types of food from Enumlist in (field#1) and (field#2) contain the prices of each type of food.
And I want to make field (field#3) will automatically calculate the cost of requested food. And thus how to connect those fields.

[Aleksi]

Are you reading foods and prices from another table?

[Fouad_H_Saad1]

From same table.

[Aleksi]

I mean do you read for example foods from another table?

[Fouad_H_Saad1]

Yes.

[Aleksi]

Then you can sum prices like SUM(SELECT(TableName[Price],IN([Food],[_THISROW].[Food])))