Create daily appointment records and update metric item

Your appointments table misses daily rows, leaving coordinators without a dated entry. Coordinators receive a dated appointment entry and yesterday's metric in the tracking item same day.