New appsheet app

AppSheet AppSheet Q&A
,
1

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

2

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

1 Like
3

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.

4

Are you reading foods and prices from another table?

5

From same table.

6

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

1 Like
7

Yes.

8

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

2 Likes