Publishing vs. Sharing Forms -> Reports -> Dashboards
I have a sheet the collects information through a form. So, a user submits a request through the form, it gets recorded in the sheet. One sheet holds all user requests.
I have a report created that filters the rows based on the current user (and the email in the original form). This report is then displayed in a dashboard.
Now, I learned that if I publish the report and the dashboard, the current user filter doesn't work.
Do I need to share the report and the dashboard with the user then? So when they go to the dashboard they have access to the report filtered by the current user? And they see only the rows they submitted?
If yes, is there a way to automatically share a report with someone rather than me manually adding them after they submit the form?