Hi Guys, I have two tables, the 1st one is w...

(Jayson Pancho) #1

Hi Guys,

I have two tables, the 1st one is where I create the schedule, and the other one is for the timekeeping.

The 1st table has the column Name / Date / Time IN Schedule.

The 2nd table has the Punch Ref Number / Name / Date / Time IN schedule / Punch In Time/ etc…

The Name is to the USEREMAIL(), the Date is TODAY().

What I need is for the Time IN schedule will autofill based with the matching Name and Date columns on both tables.

How to??? thanks

(Aleksi Alkio) #2

How about… ANY(SELECT(1stTable[Time IN Schedule],AND([Name]=[_THISROW].[Name],[Date]=[_THISROW].[Date])))

(Jayson Pancho) #3

@Aleksi_Alkio Thanks!

Translate