Determing what to show basing on the date selection

hello . i have a form that captures log in information and saved it in a gsheet.
form fields are : Date,name,time in,

i what to design a form that displays the name of the loged in person after selecting he’s login date from a calendar
form fields are
date, name ,time out

I’m afraid I don’t understand your request. Can you explain further what you’re trying to accomplish?

I when the name field to auto fill. Basing on the date of their loging