Jump to content

Embedded Google Sheet Query Function NOT Working

Recommended Posts

Site URL: https://sportingleadfree.org/ammo-selector

I'm trying to embed a spreadsheet I've created on Google Sheets which uses a query function to display results from a selected item in a dropdown menu. 

When I "publish to web" and embed the code (using the steps in this video) it does not allow me to use the dropdown menu function in my Google Sheet to yield the query results. See here. Ideally, a visitor would use the dropdown menu to select the caliber they're wanting information on and the query results would show them what is available in that caliber. 

Here is the sheet I'm trying to embed. I would like it to look just like this on the website and function how it functions on Google Sheets.

Thanks so much!

Link to comment
  • 2 weeks later...
  • Replies 1
  • Views 292
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

On 8/23/2022 at 3:26 AM, hannahleomt said:

Site URL: https://sportingleadfree.org/ammo-selector

I'm trying to embed a spreadsheet I've created on Google Sheets which uses a query function to display results from a selected item in a dropdown menu. 

When I "publish to web" and embed the code (using the steps in this video) it does not allow me to use the dropdown menu function in my Google Sheet to yield the query results. See here. Ideally, a visitor would use the dropdown menu to select the caliber they're wanting information on and the query results would show them what is available in that caliber. 

Here is the sheet I'm trying to embed. I would like it to look just like this on the website and function how it functions on Google Sheets.

Thanks so much!

I check that it is fine at the moment

image.thumb.png.895adb56767ea2950fdb7561d75b91f2.png

Do you still need help?

BeyondSpace - Squarespace Website Developer

🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox)
🗓️ Delivery Date Picker (Squarespace Date picker form field)
💫 Gallery block 7.1 workaround
🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations)
🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates)

If you find my answer useful, let's leave a like or upvote so others with the same issue can find their solution. Thank you!

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.