COVID19: Employee Self Declaration using Google Forms and looker Studio

C

Employees can report any COVID19 symptoms that they have using the Self-Declaration form. The data entered in this Google Form will be displayed in a Looker Studio report.

Demo Form: https://docs.google.com/forms/d/e/1FAIpQLSci3kNzmGKimuToRML391ilg66VVRnHQI7pNNvI332n6TyiBw/viewform

Demo Report: https://datastudio.google.com/s/ogDjRhJqYi0

You can copy the form and the report and use it in your organization. Follow the below instructions to copy.

 

How to copy the form and store the responses in a Google Sheet?

  • Click the link below

    https://docs.google.com/forms/d/1NBQIGfI8i2zbm7GhfnVZlKYzGfUtN2nWE-kHooLAIj8/copy

  • Login to your Google account

  • Click the button ‘Make a copy’

  • Click the tab ‘Responses’

  • Click the ‘Create spreadsheet’ icon Create spreadsheet

  • Select the ‘Create new spreadsheet’ option. Click ‘Create’. That creates a new sheet.

  • Click the ‘view form’ button Google Forms View Form Icon and test it by entering some data. You should see the spreadsheet being filled by the this data. Proceed further only after filling some sample data.

 

How to create a data source and copy the Looker Studio report?

  • Log in to your Google account

  • Click the below link to open the report

    https://datastudio.google.com/s/ogDjRhJqYi0

  • Click the copy button Copy Google Data Studio Report icon on the top-right side of the report.

  • Open the drop down below ‘New Data Source’ and click ‘Create New Data Source’

  • Click the connector ‘Google Sheets’

  • Select the spreadsheet that was created previously.

  • Click ‘Connect’

  • You will be shown the list of fields that were added to the data source. Make sure that ‘type’ for each of the fields matches with the below image. If any field does not match, use the drop down to change it. Note: Timestamp field’s type should be ‘Date Hour Minute (YYYYMMDDhhmm)’ and not ‘Date (YYYYMMDD).

COVID Self Declaration Data Source Fields

  • Click ‘Add to report’

  • Click ‘Copy Report’. That creates a copy of the report for you to use.

 

About the author

sasi

I share practical knowledge that I have gained as a Google Data Studio freelancer since 2017. Subscribe for Google Data Studio Templates, Tutorial and Tips.

By sasi
I share practical knowledge that I have gained as a Google Data Studio freelancer since 2017. Subscribe for Google Data Studio Templates, Tutorial and Tips.
Sasi - DataSasi.com