Sorting Data

I am working on creating an app for teachers to use daily to sign in and give their updates as to how they are feeling. They will complete the basic COVID questions daily. What I was wondering, is if there is a way to sort the data daily to see who filled out the form and who did not using the app.

You can catch the timestamp of the question and the user’s email via the form. In your Data Editor, change the format to date only, then you can filter the form responses by date to show who has filled the form (and who has not, by looking at the complete list of your teachers).

With that being said you can filter the results in your google sheet to only display dtaes that are today. so the rest of the dates are not valid and you will see just the people who did it today.