Configure directory component for Podcasts
In this guide, we'll walk you through step by step on how to set up the Podcast template.
Use spreadsheets with up to 2500 rows. Otherwise the page loading speed will critically decrease, potentially leading to complete freezing.
Table of contents:
Create your spreadsheet
Publish and get a link to the spreadsheet
Replace the link
Add dynamic data source URL to the page
Additional information
Make a copy of the spreadsheet available at the following link:
https://docs.google.com/spreadsheets/d/1EEwr3HeRns23qNB7Fpk5nf-0zezg4Saqlgk3nZIaqUU/edit?usp=sharing
Remember: Each column of information in your Google spreadsheet should have a name to avoid errors on the site.
Publish your new spreadsheet as a .csv file and copy the resulting link:
Go to the dynamic component settings:
and replace the link in the CMS URL section:
We have a detailed guide and video Dynamic data from Google Sheets spreadsheet that walks you through setting up dynamic pages step by step.
The template has two dynamic pages
And we need to go to the page settings and add the link to the Google Sheet in .csv (which we previously added for the dynamic component) into the Dynamic data source URL section for the booth pages.
You can now start editing your Google Drive spreadsheet by adding your information.
All the changes you make will be automatically updated in the component on your website within a few minutes after the modifications are made.
Information on the item card
Description of columns in the standard Sheet
Component settings
imgUrl - the direct link to the image should include the file extension at the end, such as .jpg, .png, etc.
If you are using a component without images, you can leave this field empty.
Date, Title, descriptionShort and description - provide purely informational content.
page - page name that will be appended to the cards in the dynamic component on the homepage, and clicking on a card will navigate you to the dynamic page /episode.
spotify and itunes - this column contains the code for embedding the player onto the page.
To obtain this code, you need to click the "Share" button and copy the code:
Search bar
Placeholder - text for the search bar. Use {{amount}} to display the total number of items in the directory. Leave empty to hide the search bar.
Filters
Source column - allows you to select a column from Google Sheets that will be used for filtering.
Label - allows you to specify the name of the filter.
Sorting - indicates the order of sorting.
Show items by filters - keep only selected filters. The filters bar is hidden if only 1 filter is selected. Switch "All" and "Any" to change the logic for multiple filters.
Multiselect - allows you to choose multiple filters at the same time.
Hide filters - allows you to hide specific filter.
Show more
Item limit - sets the maximum number of items to display initially. Additional items will be accessible via a "Show all" button.
Button text - the text displayed on the button that reveals all items when clicked. Leave empty to hide the button.
No results
Text - text displayed when no items are matching search or filters.
Sorting
Sort by column - specify the column to sort the items by. Select ascending order to display the items from A to Z or from 0 to 9. Select descending order to display the items from Z to A or from 9 to 0.
Item visibility
Show by columns - display items only if they match certain conditions. The value is considered FALSE if it's empty or 'false'. Otherwise, it's TRUE. Switch "All" and "Any" to change the logic for multiple conditions.
Items on click
Item URLs - Specify which URLs will be opened when you click on the directory items. Choose the field in your CMS that contains the URL. Add a prefix to open a dynamic page (e.g. /tools/unicornplatform).
Use spreadsheets with up to 2500 rows. Otherwise the page loading speed will critically decrease, potentially leading to complete freezing.
Table of contents:
Configure Podcast directory component
Create your spreadsheet
Publish and get a link to the spreadsheet
Replace the link
Configure Podcast dynamic page
Add dynamic data source URL to the page
Additional information
1. Create your spreadsheet
Make a copy of the spreadsheet available at the following link:
https://docs.google.com/spreadsheets/d/1EEwr3HeRns23qNB7Fpk5nf-0zezg4Saqlgk3nZIaqUU/edit?usp=sharing
Remember: Each column of information in your Google spreadsheet should have a name to avoid errors on the site.
2. Get a link to the spreadsheet
Publish your new spreadsheet as a .csv file and copy the resulting link:
3. Replace the link
Go to the dynamic component settings:
and replace the link in the CMS URL section:
At this stage, the setup of the dynamic component is complete, and we can proceed to configure the dynamic pages.
We have a detailed guide and video Dynamic data from Google Sheets spreadsheet that walks you through setting up dynamic pages step by step.
4. Add dynamic data source URL
The template has two dynamic pages
And we need to go to the page settings and add the link to the Google Sheet in .csv (which we previously added for the dynamic component) into the Dynamic data source URL section for the booth pages.
🏁 Setup complete!
You can now start editing your Google Drive spreadsheet by adding your information.
All the changes you make will be automatically updated in the component on your website within a few minutes after the modifications are made.
Additional information
Information on the item card
Description of columns in the standard Sheet
Component settings
An example of displaying information from a Google Sheet in a card on the website.
The spreadsheet contains the following information
imgUrl - the direct link to the image should include the file extension at the end, such as .jpg, .png, etc.
If you are using a component without images, you can leave this field empty.
Date, Title, descriptionShort and description - provide purely informational content.
page - page name that will be appended to the cards in the dynamic component on the homepage, and clicking on a card will navigate you to the dynamic page /episode.
spotify and itunes - this column contains the code for embedding the player onto the page.
To obtain this code, you need to click the "Share" button and copy the code:
Component settings
Search bar
Placeholder - text for the search bar. Use {{amount}} to display the total number of items in the directory. Leave empty to hide the search bar.
Filters
Source column - allows you to select a column from Google Sheets that will be used for filtering.
Label - allows you to specify the name of the filter.
Sorting - indicates the order of sorting.
Show items by filters - keep only selected filters. The filters bar is hidden if only 1 filter is selected. Switch "All" and "Any" to change the logic for multiple filters.
Multiselect - allows you to choose multiple filters at the same time.
Hide filters - allows you to hide specific filter.
Show more
Item limit - sets the maximum number of items to display initially. Additional items will be accessible via a "Show all" button.
Button text - the text displayed on the button that reveals all items when clicked. Leave empty to hide the button.
No results
Text - text displayed when no items are matching search or filters.
Sorting
Sort by column - specify the column to sort the items by. Select ascending order to display the items from A to Z or from 0 to 9. Select descending order to display the items from Z to A or from 9 to 0.
Item visibility
Show by columns - display items only if they match certain conditions. The value is considered FALSE if it's empty or 'false'. Otherwise, it's TRUE. Switch "All" and "Any" to change the logic for multiple conditions.
Items on click
Item URLs - Specify which URLs will be opened when you click on the directory items. Choose the field in your CMS that contains the URL. Add a prefix to open a dynamic page (e.g. /tools/unicornplatform).
Updated on: 16/10/2024
Thank you!