Solved: Need help with expression setup - Page 2

Eli1 · 09-29-2021 04:44 AM

Hi Appsheet user community,

I have a fairly detailed questions involving user expressions.
I have two tables:
Table 1 (“Restaurant check in and out data”): Has a user’s email’s (“Email”), a timestamp (“Timestamp”), and a location (“Location”).
Table 2 (“Sheet1”): Has a location (“Location”), a start time (“Cartridge start time”), and an end time (“Cartridge end time”).

What I am trying to do is build an bot that sends an email if four conditions are true.

Condition a) The email in table 1 matches up to an email I am storing in User Settings (under “Email”).
Condition b) The location in table 1 matches up with the location in table 2.
Condition c) The timestamp in table 1 is greater than or equal to the start time in table 2.
Condition d) The timestamp in table 1 is less than or equal to the start time in table 2.

You all probably have more experience with this then me, so if you have any expression suggestions, please write in and reply.

Marc_Dillon

Hmmmm, ok, maybe I understand. Does this seem like what you need?

ISNOTBLANK( FILTER(
  Restaurant check in.... ,
  AND(
    [email] = USERSETTINGS("Email") ,
    [location] = [_THISROW].[location] ,
    [timestamp] >= [_THISROW].[catridge start time] ,
    [timestamp] <= [_THISROW].[end time]
  )
) )

View solution in original post