first question i have a delivery food servic...

(Laura Ramazzotti) #1

first question

i have a delivery food service i made a form that a costumer can choose everyday one food recipe from a drop down list (ref from another table)

each recipe is describe in a single row with name,photo,calorie,price how can i show the list of the ingredients for each recipe in an enum list so he can exclude one or more of the ingredients ? second question in the above table where i have all my recipes , each recipe has a date

how can i show in the above form only the recipes that has the date of tomorrow ?

(Suvrutt Gurjar) #2

Hi @Laura_Ramazzotti, For your second question, you may wish to create a slice on your recipe table with filter expression [Date]=Today()+1

If you wish only only tomorrow’s recipes to reach users device ,you may wish to enter this expression in security filter of the table.

(Aleksi Alkio) #3

Question #1 - Create a simple Incredients table with one column. Then add a Enumlist field for your your recipe table where you can add all incredients that the recipe contains. You can then show all recipents as an Enumlist again where the user can exclude them one by one.

(Aleksi Alkio) #4

LOOKUP is always giving you just one value. If the condition matches, it will give you the first value from that list. When you need to have a list, you need to use SELECT expression.

(Laura Ramazzotti) #5

thanks again and never mind i founf it with a valid if


(Aleksi Alkio) #6


(Laura Ramazzotti) #7

Thank you but this is not the solution I was looking for

I used a valid if and select to make my correct list of recipes and this is working well but after I pick a recipe from this list in the form I need also some other fields to follow that selection

I tried in the initial value with table(price) but it didn’t work

Please help

(Aleksi Alkio) #8

You can use a deref expression like… [Recipe].[Price]

(Laura Ramazzotti) #9


the expression is corect but the result is wrong this is my expression =SELECT(recipes[Lunch recipe], [date] = [_THISROW].[today] )

and what i need is the column price from table recipes to follow in the the table form

(Aleksi Alkio) #10

If the [Recipe] is a ref field as you mentioned in the first post, the deref formula should work in app formula or initial value.

(Laura Ramazzotti) #11

@Aleksi_Alkio OK ! but this is correct for a ref fuction

… i am not using a ref fuction but a valid if

expression =SELECT(recipes[Lunch recipe], [date] = [_THISROW].[today] )

and the deref expression like… [Lunch recipe].[Price] that you gave me …the result is the recipe name again and not the recipe price

(Aleksi Alkio) #12

Okay… you are not using a ref field. Then you can read the price like… LOOKUP([_THISROW].[Recipe],Recipes,Lunch recipe,Price)

(Laura Ramazzotti) #13

perfect !!! thanksssss

(Laura Ramazzotti) #14

@Aleksi_Alkio for the Price this expression work perfect but what if i need that this LOOKUP([_THISROW

expression to bring me the list of the ingridients witch is at another table i try that same expression and it is working but it is only bring the first ingridient and not the whole enumlist that i need