Knowledge Base Article

Dashboard Request Portal // Embedding Google Form with BloX

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

2019-09-27_15h21_36.png

Collect Responses Straight From a Dashboard

2019-09-27_14h19_19.png

Manage and Track Requests

2019-09-27_13h47_10.png

 

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. 
2019-09-27_13h59_05.png
3. Set up response collection to populate a Google Sheet.
2019-09-27_14h02_54.png
2019-09-27_14h03_44.png
4. Select Share then the embed <> Symbol to get iframe code
2019-09-27_14h08_17.png
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. 
2019-09-27_15h13_55.png
You're all set!
8. To take it even further, connect to the google sheet and build a dashboard to monitor and track requests. 
Updated 03-02-2023
No CommentsBe the first to comment