Help with a SELECT expression

[Jesus_Corral]

Hi guys! I hope you’re fine, I have a doubt

If for example I have a table called TIMESHEET
and I have the next columns inside of it

• employees (ref)
• date (date)
• entranceHour (time)
• outHour (time)

Here is what I want to do ->

How can I select the entranceHour and the outHour as well of a certain employee, I don’t want to select all the entranceHours and Out Hours, only those belonging to a certain employee.

I hope you could help me with that expression please!

[Robin_Hood]

Hi @ [Jesus_Corral]

You might want to look into FILTER()

help.appsheet.com

FILTER()

Select rows of table or slice

In AppSheet SELECT returns one column data at a time.

help.appsheet.com

SELECT()

Gather column values from row in table or slice

SELECT(TIMESHEET[KEY], ([employee] = “xyz”), TRUE)` : A list of distinct key (duplicates omitted) of the TIMESHEET of the employee xyz.

[Jesus_Corral]

Thank you Robin!

[Steve]

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

[Jesus_Corral]

Thank you Steve