I have to create a way to track users coming to my center. I need to be able to track date and time they sign into the center and I need to be able to track date and time they sign out of the center each day. At the end of week need to sum all days present for each user.
I created a sign in form, but having issues resolving how to allow same user to log back into app and enter both sign and sign out times with getting a duplicate user error. Should I have a separate table for each, or is there something I am missing here?