Add Meal of the Day from Parent to Child Record using Action

AppSheet AppSheet Q&A
,
1

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**.**

EmadK_0-1671352588760.png
EmadK_0-1671352588760.png777×389 12.7 KB

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!

2

Maybe this?

LOOKUP(
  WEEKDAY(TODAY()),
  "Menu",
  "Day Available",
  "Item Name"
)
1 Like