Google Spreadsheet Tables

Build a dynamic table in minutes, without need to code. Revise the data directly with Google Sheet, instantly!

How to create a table with Google Sheet

Login to your Gmail account and go to Google Sheet site.

1. Create a new spreadsheet

2. Create your table (columns and rows)

3. Remember to make your table "public": you only need to click the "Share" button and then "Done".

How to enable Google API Key

To let the Udesly Styler communicate with your Google Sheet, you need to enable the appropriate API Key

Follow these simple steps to enable API Key:

1. Login your google account;
2. Go to [Google Developer Console] (https://console.developers.google.com);
3. Click on "Credentials" and select "API Key" from the "Create Credentials" dropdown menu;
4. Click on "Library", search for Google Sheets and enable API Key just created.

Widget Options Panel

In this panel you can customize the widget parameters:

1. Google Spreadsheet ID: Insert here the ID of your Google Spreadsheet (the ID is the part following the latest slash in your spreadsheet url);
2. Google API Key: Insert here the Google API Key you have generated;
3. Google Spreadsheet Cell Range: insert here the cell range of your spreadsheet. Remember to separate colon coordinates (e.g. A1:C6);
4. Google Spreadsheet Sheet Name: Insert here the name of the sheet you want to make visible.

How to style the Table

Udesly Styler general settings can be checked following this link To stylize the table, we suggest to keep in mind the Navigator, that is the list of all the selectable elements of the table. Each of these elements can be customized. Here are some useful indications:

1. Data Table: here you can customize the perimeter of the whole table, including the settings filter. you can customize layout, typography, effect, etc;
2. Griddle Filter: stylize the filter box, which serves to filter the contents of the table;
3. Griddle Settings Toggle: stylize the elements that are visible only if the "settings" button is pressed in order to remove or add columns from the table;
4. Griddle Table: stylize the area of the entire table (no setting filter);
5. Griddle tabble Heading: stylize the table heading. E.g. you can assign it a different background color to the rest of the table;
6. Griddle Table Heading Cell: stylize the single cell of the heading;
7. Griddle Table Body: stylize the body of the table: all the rows and columns underlying to headings;
8. Griddle Row: highlight a whole row. E.g. to insert a different hover effect for that specific row;
9. Griddle Cell: if you have the need to insert padding among rows, you can do it working on this parameter because, by enlarging the padding here, it will enlarge across the row;
10. Griddle Pagination: if your table has more than 10 items, you can stylize the pagination by working on this parameter;
11. Griddle Page Select: stylize the page selector.

This plugin supports markdown editing in order to make it able to contain both links and images. Follow this link to discover markdown major properties.

License

Griddle is licensed under the MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

“Copyright (c) 2018 - Udesly - GRIDDLE”