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

Jayson_Pancho · 07-21-2018 05:00 PM

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

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

Jayson_Pancho

Translate