Dashboard Request Portal // Embedding Google Form with BloX

[intapiuser]

Solution:

To manage requests for new dashboards (or any other data collection needs) you can embed a Google Form straight into a dashboard using BloX! Get started with this BloX template and follow the steps below. 

You can then create a dashboard to manage and track the responses by connecting to Google Sheets.

Embed Your Google Form

Collect Responses Straight From a Dashboard

Manage and Track Requests

Steps:

1. Create your Google Form

2. Configure settings to allow the form to render for any browser, even if no user is signed in to a google account. Then specify additional options. 

3. Set up response collection to populate a Google Sheet.

4. Select Share then the embed <> Symbol to get iframe code

5. Modify the code for BloX

Double quotes are swapped for single quotes.

Before:

<iframe src="https://docs.google.com/forms/d/e/1FAIpQLScxLrVbjkRK25fkSwyRUQt7QZKO9h6-pBesI-7XuEXWK5GzSQ/viewform?embedded=true" width="700" height="520" frameborder="0" marginheight="0" marginwidth="0">Loading…</iframe>

After:

<iframe src='https://docs.google.com/forms/d/e/1FAIpQLScxLrVbjkRK25fkSwyRUQt7QZKO9h6-pBesI-7XuEXWK5GzSQ/viewform?embedded=true' width='640' height='2931' frameborder='0' marginheight='0' marginwidth='0'>Loading…</iframe>

6. Import the BloX template.

7. Using the template, replace the text in line 20 with your modified code. 

You're all set!

8. To take it even further, connect to the google sheet and build a dashboard to monitor and track requests.