ayp_abr Posted September 26, 2022 Share Posted September 26, 2022 My site is still being developed, but as I am coming close to completion and going live with it I am running into a slight issue. The issue is I have a contact type form on my site which collects ratings (based on 3 or 4 questions, 1-5 scale), pretty standard. This is being populated into google sheets per square space set-up. My issue is I can't find a way to pull back the ratings and create a report on my site based on those ratings. My question is. Does Squarespace offer such a solution to query google docs and bring back those ratings? If this can be done on the fly that would be great, less human interaction the better. Thoughts? Thanks! AWL Link to comment
Ziggy Posted September 26, 2022 Share Posted September 26, 2022 This plugin allows you to pull tables and data into Squarespace, I'm not exactly sure what you're wanting to pull on to your website, but you can also embed a Google sheet directly by publishing it. https://www.squarewebsites.org/squarespace-plugins/custom-table-block If you can share a few more details I can probably help further. Please like and upvote if my comments were helpful to you. Cheers! Zygmunt Spray Squarespace Website Designer Contact me: https://squarefortytwo.com 🔌 Ghost Squarespace Plugins (Referral link)📈 SEO Space (Referral link)⬛ SquareWebsites Plugins (Referral link)☕ Did I help? Buy me a coffee? Link to comment
ayp_abr Posted September 26, 2022 Author Share Posted September 26, 2022 Ziggy- Thanks for your reply and I will check out that plug-in. This is what I am trying to do. I have a form on my site that will be a "review this program"... So my results may look like this: Think of this has 3 different submissions, stored in a Google Sheets app. The user reviews the program and submits to my google sheet (this is working). Three user reviews may look like this (the comma represents a cell in Google sheets, couldn't see how to build a table): User A, Program A, 5, 4, 3, 5 User B, Program B, 5, 5, 4, 5 User C, Program A, 5, 3, 5, 5 So with this data I want to report back to my site data like this: Program A, 5, 3.5, 4, 5 Program B, 5, 5, 4, 5 Basically query the data into 'results' of the survey by program, without the need to do anything else just set-up and let it update on the fly. AWL Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment