Hello! I am creating an app that records daily temperature checks for staff at our property over the next seven weeks. I have a general operation of the app down, but realizing it will be a pain to scroll through 7 weeks of dates to enter someones temp each morning.
Is there a way to have the user enter their temperature and it assign it to the right date column in my excel spreadsheet? Currently each staff has a profile photo to click on, once clicked on I need to add the temperature reading for that day.
In my head I would love to be able to click on the photo and there be a line with the current date, and the next line open for the temperature reading. From there, the correct temp would be in the correct column with the date.
Thank you for the help!