Hi Appsheeet Community,
I am creating a lunch-ordering app.
On the new order page, I have an action "Add Todays Item". I want to set this up to add to lookup the Menu table, search for [Item Name], referenced by the day in [Day Available] enumlist.
The action is on the Customers table. Orders are added to Orders table. I am using the following expression. It works on the Order table but when used on the Customers table, it can't find the column [Day Available]
ANY(
Select(Menu[Item Name],
[Day Available] = INDEX(LIST([_THISROW].[Day Available]), WEEKDAY(TODAY()))
)
)
How do I tweak this expression?
Thank you.
@Suvrutt_Gurjar your help is greatly appreciated!
Maybe this?
LOOKUP(
WEEKDAY(TODAY()),
"Menu",
"Day Available",
"Item Name"
)
User | Count |
---|---|
36 | |
32 | |
30 | |
18 | |
16 |