Daily User Specific Columns

Hey guys! I’m trying to develop for a use case where a user needs to answer a several different questions every day (the same question) I’m wondering how I could go about building time based user specific responses.

I’ve come up with two possible solutions, one is to create an automation that will copy the rows containing the question, add today’s date, filter on the app by todays’ date and enable user specific answers.

The other solution is to use a form to store the response as well as n identifier to correlate it to what question was answered.

Welcome to the community, Madhav.

You can create a separate sheet to capture answers.
Use the Show form action for a button and write responses to that sheet.

You don’t need to use user-specific columns for this.

Thanks for the quick reply @sardamit