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