The Google Sheets item type allows you to display simple Google Sheets data with Ditty. For general information on working with items check out the following articles:
Google Sheets Settings
Select the Gear/Edit icon shown on your Google Sheets item to adjust the settings.
General Settings
Set the general settings of the Google Sheets item.
- Spreadsheet Id – Add the spreadsheet id. This can be found in the url of the Google Sheet.
- Sheet Name – Add the sheet name. This is the name of the tab/sheet you want to display from your specified file.
- Use first columns as headings? – Choose if the first column contains headings or data.
- Limit – Set the number of items to display. Use 0 to display all.
- Offset – Set an offset from the first entry.
Links
Configure link settings for the Google Sheets item.
- Link Target – Set a target for the link.
- Link No Follow – Enabling this setting will add an attribute called ‘nofollow’ to the link. This tells search engines to not follow this link.
Customize (Layout Tags)
Customize the layout tags used in the layout for a Google Sheets item.
Note: Since layout tags are based on data contained within the Google Sheet, the Item Settings must be updated after adding a new Google Sheet before the associated Layout Tags are populated correctly.
Keep in mind that your layout may not use all of the tags shown on this panel. If the tag is not included in your layout, modifications in this panel will have no effect.
- Click the checkmark next to each tag to toggle visibility.
- Click the gear icon to open the available attributes for each tag.
- If you want to modify an attribute, click the pencil icon next to the attribute name. This will open a field to set a custom value for the attribute.
For more information view the documentation here: https://www.metaphorcreations.com/article/ditty/general/adding-new-items/#customize-tab
Google Sheets Layout Settings
Select the Pencil/Brush icon shown on your Google Sheets item to modify the layout for the item. Read more about what Layouts are and how they are used here: https://www.metaphorcreations.com/article/ditty/general/using-layouts/
Google Sheets Tags
Layout tags will be dynamically generated based on the contents of your Google Sheet. Since layout tags are based on data contained within the Google Sheet, the Item Settings must be updated after adding a new Google Sheets before the associated Layout Tags are populated correctly.
CSS Selectors
Layout tag CSS selectors will be dynamically generated based on the contents of your Google Sheet. Since layout tags are based on data contained within the Google Sheet, the Item Settings must be updated after adding a new Google Sheet before the associated CSS selectors are populated correctly.
- .ditty-item__elements – The container wrapping around the item’s content.
