Google sheets integration test
This is an image block at the top of the page - no banner
This uses Poster style.
A Test for Google Sheets Integration
Reference: https://support.squarespace.com/hc/en-us/articles/205814348-Displaying-files-on-your-site
The Quick Brown fox
This is a markdown block and above I've used span style to change the background colaur
Test using Noosa Business Solar sheet
This sheet could be populated from a Squarespace form
Probably best to have 2 worksheets within the Google sheet
First sheet would be populated either manually or from a Squarespace form
Second sheet is the one that is published and displayed in Squarespace. Be sure to turn off display of gridlines to follow the current style. Could then have multiple columns. But note on mobile / smaller screens the columns stay and you get a horizontal scroll bar which may not be all that visible
Example Data Entry Form connected to Google sheet
blah blah
In form below, have changed to Google Drive storage option - now goes to Google Drive at geoffrey@zeroemissionsnoosa.com
TABLEIZER! test
see https://tableizer.journalistopia.com/
just copy spreadsheet data, then paste html into code block
play around making it multiple column / responsive
| Submitted On | Name | |
|---|---|---|
| 06/28/2019 10:30:45 | Horace Horsecollar | horace@horsecollar.com |
Tableizer from google sheets column - to multicolumn with CSS
see above & https://www.w3schools.com/css/css3_multiple_columns.asp
https://www.w3schools.com/css/tryit.asp?filename=trycss3_column-count
Also see https://www.w3schools.com/css/default.asp
| 10 Leo Alley Lane Noosaville |
| 6 Commerce Court Noosaville |
| 6 Production Street Noosaville |
| AGS Architectural Glass Solutions |
| Alpha & Omega |
| Amo Gelato/Absolute Providores |
| Aspire Properties |
| Australia Post Office Tewantin |
| Belmondos Organic Market |
| Bissells Paint and Panel |
| Cetnaj Lighting |
| Coast Guard Noosa |
| Derek Beasley Private Landlord 25kW |
| Di Henshall Interior Design |
| Drop Bear Adventures |
| Eco Cottages - Cooroy - 100kW |
| Ella and Sunday 6.6KW |
| Embassy Stone 27.6KW |
| Exoticathletica |
| EZI Batten |
| Fairshore Noosa Resort |
| Flashpackers |
| Gamlin Roofing |
| Good Shepard Lutheran College |
| Gull Bros 66kW |
| Heads of Noosa |
| Kananda |
| Kellick Marine Concepts |
| Kim Wallace Ceramics |
| Laguna Bay Air Conditioning |
| Laguna Boating 10KW |
| Makris Wholesale Foods |
| Mikes Customs 6.6KW |
| National Storage Noosa |
| Noosa Canvas & Vinyl |
| Noosa Cat |
| Noosa Council Offices |
| Noosa CV Radiators Repairs 14kW |
| Noosa Earth |
| Noosa Engineering & Crane Hire |
| Noosa Fish Providores |
| Noosa Heads Surf Lifesaving |
| Noosa Keys |
| Noosa Leisure Centre |
| Noosa Library |
| Noosa Marina |
| Noosa Metal Fabrication |
| Noosa Party Hire |
| Noosa Radiators |
| Noosa Seafood Market |
| Noosa Sound Resort |
| Noosa Village Shopping Centre 250kW |
| Noosa Wholesalers |
| Noosa Yacht Club |
| Page Furnishers |
| Paint Right 20KW |
| Peregian Beach Home Hardware |
| Rene's Marine and Tropical Aquariums |
| SALT Solar |
| Sofitel Noosa |
| Solar on trailers? |
| Storage First Noosa |
| Storelocal |
| Sun Motel |
| Sunshine Mowers 20KW |
| T&G Automotive |
| Tewantin Bowls Club |
| Tewantin newsagent Office Choice 44kW |
| Tewantin RSL |
| The Hub Thrift Shop |
| The J |
| Trade Tools |
| Zabe Espresso |