{"id":1643,"date":"2019-02-15T14:46:18","date_gmt":"2019-02-15T14:46:18","guid":{"rendered":"http:\/\/neroz.co.uk\/wordpress\/?p=1643"},"modified":"2021-06-03T21:56:16","modified_gmt":"2021-06-03T21:56:16","slug":"competition-results","status":"publish","type":"post","link":"https:\/\/neroz.co.uk\/wordpress\/competition-results\/","title":{"rendered":"Competition results ~ linking Google Sheets to WordPress"},"content":{"rendered":"\n<style>\ntable, th, td {\n  border: 1px solid black;\n}\n.igsv-table tr.even {background-color: #ffEEFF;}\n<\/style>\n\n\n\n<p>This is a test post to try linking a Google spreadsheet to WordPress.<br>The spreadsheet is for a fictional club and collates competition results and averages scores <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Results for Competition No. 1<\/h3>\n\n\n\n<p><!-- This is a comment&nbsp; --><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-embed-handler wp-block-embed-embed-handler\"><div class=\"wp-block-embed__wrapper\">\n<table id=\"igsv-1ZJhNvRGVQOZ66EiwQa7DWKFJ-VsCPJ9tUEE9mNnHBQI\" class=\"igsv-table\" lang=\"en-GB\" style=\"\" ><thead>\n<tr id=\"igsv-1ZJhNvRGVQOZ66EiwQa7DWKFJ-VsCPJ9tUEE9mNnHBQI-row-1\" class=\"row-1 odd\"><th class=\"col-1 odd\"><div><a href=\"https:\/\/neroz.co.uk\/wordpress\/comparing-the-in-built-vs-nextgen-gallery\/\">Photo<\/a> No<\/div><\/th><th class=\"col-2 even\"><div>Scorer 1<\/div><\/th><th class=\"col-3 odd\"><div>Scorer 2<\/div><\/th><th class=\"col-4 even\"><div>Scorer 3<\/div><\/th><th class=\"col-5 odd\"><div>Scorer 4<\/div><\/th><th class=\"col-6 even\"><div>Scorer 5<\/div><\/th><th class=\"col-7 odd\"><div>Average Score<\/div><\/th><\/tr><\/thead><tbody>\n<tr id=\"igsv-1ZJhNvRGVQOZ66EiwQa7DWKFJ-VsCPJ9tUEE9mNnHBQI-row-2\" class=\"row-2 even\"><td class=\"col-1 odd\">1<\/td><td class=\"col-2 even\">18<\/td><td class=\"col-3 odd\">17<\/td><td class=\"col-4 even\">17<\/td><td class=\"col-5 odd\">19<\/td><td class=\"col-6 even\">20<\/td><td class=\"col-7 odd\">18.2<\/td><\/tr><tr id=\"igsv-1ZJhNvRGVQOZ66EiwQa7DWKFJ-VsCPJ9tUEE9mNnHBQI-row-3\" class=\"row-3 odd\"><td class=\"col-1 odd\">2<\/td><td class=\"col-2 even\">14<\/td><td class=\"col-3 odd\">16<\/td><td class=\"col-4 even\">13<\/td><td class=\"col-5 odd\">15<\/td><td class=\"col-6 even\">14<\/td><td class=\"col-7 odd\">14.4<\/td><\/tr><tr id=\"igsv-1ZJhNvRGVQOZ66EiwQa7DWKFJ-VsCPJ9tUEE9mNnHBQI-row-4\" class=\"row-4 even\"><td class=\"col-1 odd\">3<\/td><td class=\"col-2 even\">15<\/td><td class=\"col-3 odd\">16<\/td><td class=\"col-4 even\">15<\/td><td class=\"col-5 odd\">16<\/td><td class=\"col-6 even\">17<\/td><td class=\"col-7 odd\">15.8<\/td><\/tr><tr id=\"igsv-1ZJhNvRGVQOZ66EiwQa7DWKFJ-VsCPJ9tUEE9mNnHBQI-row-5\" class=\"row-5 odd\"><td class=\"col-1 odd\">4<\/td><td class=\"col-2 even\">17<\/td><td class=\"col-3 odd\">18<\/td><td class=\"col-4 even\">17<\/td><td class=\"col-5 odd\">18<\/td><td class=\"col-6 even\">18<\/td><td class=\"col-7 odd\">17.6<\/td><\/tr><tr id=\"igsv-1ZJhNvRGVQOZ66EiwQa7DWKFJ-VsCPJ9tUEE9mNnHBQI-row-6\" class=\"row-6 even\"><td class=\"col-1 odd\">5<\/td><td class=\"col-2 even\">20<\/td><td class=\"col-3 odd\">15<\/td><td class=\"col-4 even\">19<\/td><td class=\"col-5 odd\">18<\/td><td class=\"col-6 even\">19<\/td><td class=\"col-7 odd\">18.2<\/td><\/tr><\/tbody><\/table>\n<\/div><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<p>In this table, a query is run and only selected results shown.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><table id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4\" class=\"igsv-table no-datatables\" lang=\"en-GB\" style=\"\"><thead>\n<tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-1\" class=\"row-1 odd\"><th class=\"col-1 odd\"><div><\/div><\/th><th class=\"col-2 even\"><div><\/div><\/th><th class=\"col-3 odd\"><div><\/div><\/th><th class=\"col-4 even\"><div><\/div><\/th><\/tr><\/thead><tbody>\n<tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-2\" class=\"row-2 even\"><td class=\"col-1 odd\">1<\/td><td class=\"col-2 even\">20<\/td><td class=\"col-3 odd\">13<\/td><td class=\"col-4 even\">16.58<\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-3\" class=\"row-3 odd\"><td class=\"col-1 odd\">2<\/td><td class=\"col-2 even\">19<\/td><td class=\"col-3 odd\">11<\/td><td class=\"col-4 even\">15.10<\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-4\" class=\"row-4 even\"><td class=\"col-1 odd\">3<\/td><td class=\"col-2 even\">18<\/td><td class=\"col-3 odd\">14<\/td><td class=\"col-4 even\">16.50<\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-5\" class=\"row-5 odd\"><td class=\"col-1 odd\">4<\/td><td class=\"col-2 even\">18<\/td><td class=\"col-3 odd\">13<\/td><td class=\"col-4 even\">14.80<\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-6\" class=\"row-6 even\"><td class=\"col-1 odd\"><\/td><td class=\"col-2 even\"><\/td><td class=\"col-3 odd\"><\/td><td class=\"col-4 even\"><\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-7\" class=\"row-7 odd\"><td class=\"col-1 odd\"><\/td><td class=\"col-2 even\"><\/td><td class=\"col-3 odd\"><\/td><td class=\"col-4 even\"><\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-8\" class=\"row-8 even\"><td class=\"col-1 odd\"><\/td><td class=\"col-2 even\"><\/td><td class=\"col-3 odd\"><\/td><td class=\"col-4 even\"><\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-9\" class=\"row-9 odd\"><td class=\"col-1 odd\"><\/td><td class=\"col-2 even\"><\/td><td class=\"col-3 odd\"><\/td><td class=\"col-4 even\"><\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-10\" class=\"row-10 even\"><td class=\"col-1 odd\"><\/td><td class=\"col-2 even\"><\/td><td class=\"col-3 odd\"><\/td><td class=\"col-4 even\"><\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-11\" class=\"row-11 odd\"><td class=\"col-1 odd\"><\/td><td class=\"col-2 even\"><\/td><td class=\"col-3 odd\"><\/td><td class=\"col-4 even\"><\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-12\" class=\"row-12 even\"><td class=\"col-1 odd\"><\/td><td class=\"col-2 even\"><\/td><td class=\"col-3 odd\"><\/td><td class=\"col-4 even\"><\/td><\/tr><tr id=\"igsv-1x9AaGjpR0l9sBNKFYUdkVRfb3Cx3A1wJksN6-NWzRx4-row-13\" class=\"row-13 odd\"><td class=\"col-1 odd\"><\/td><td class=\"col-2 even\"><\/td><td class=\"col-3 odd\"><\/td><td class=\"col-4 even\"><\/td><\/tr><\/tbody><\/table><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Test linking Google Sheets with Wortdpress<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_piecal_is_event":false,"_piecal_start_date":"","_piecal_end_date":"","_piecal_is_allday":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3,1],"tags":[41,47],"class_list":["post-1643","post","type-post","status-publish","format-standard","hentry","category-httpnerozcoukwordpresspage_id7","category-uncategorized","tag-linlithgow","tag-photo"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/neroz.co.uk\/wordpress\/wp-json\/wp\/v2\/posts\/1643","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/neroz.co.uk\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/neroz.co.uk\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/neroz.co.uk\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/neroz.co.uk\/wordpress\/wp-json\/wp\/v2\/comments?post=1643"}],"version-history":[{"count":0,"href":"https:\/\/neroz.co.uk\/wordpress\/wp-json\/wp\/v2\/posts\/1643\/revisions"}],"wp:attachment":[{"href":"https:\/\/neroz.co.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=1643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/neroz.co.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=1643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/neroz.co.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=1643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}