Adding Search Columns to Datasets
Dynamic Pages use “datasets” to serve content to dynamic widgets and pages. Datasets use Google Sheets or Airtables to contain the data. If you’ve already built a dataset for Dynamic Pages, it’s easy to add a few columns to your Google Sheet or Airtable to enable it to properly contain data that can be used with the Search widget as well.
Here is an example of an Airtable that includes the appropriate search columns: https://airtable.com/shr5OwNhM5YSXn1vM
If you’re new to Dynamic Pages, be sure to see our Dynamic Pages documentation.
The following instructions can be applied to both Google Sheets and Airtable. The goal is to simply add a few new columns to your spreadsheet. In this example, we will use an Airtable.
- Open your Airtable (or Google Sheet)
- Add the following fields:search_title search_description search_tags search_image search_link
- Start by clicking “Add field”
- Name the field “search_title”
- Continue adding all the fields.
- Be sure that the each field name is entered correctly. There should be no capitalization and no spaces. Only underscores should be used between words.search_title search_description search_tags search_image search_link
- Note: you cannot add your own search categories. Our search widget was built to look for these exact categories.
Populating the Search Columns
The next step is to populate the new search columns you’ve created. This is the data that the search widget will scrape in order to display search results.
If you’ve already populated your spreadsheet for Dynamic Pages, you can probably re-use information already in the spreadsheet. In our real estate Airtable example [this is the exact Airtable used in our Heights template], we’ve copied the existing titles, descriptions, images and links that were already in the table.
You’re free to enter specific, custom data in your own dataset. However, in these instructions, we will use data already in our table.
- Select all the cells in the listing_titles column
- Paste the entire column into the search_title column.
- Repeat this process until you’ve populated all new search columns
Using the Same Spreadsheet for Dynamic Pages and Search
Our Search widget has been updated to accept both Google Sheets and Airtable as sources. This means that the Search widget can utilize the exact same Google Sheet or Airtable you’ve used for Dynamic Pages (or Connected Data used in other widgets). To do this, simply select the appropriate Google Sheet or Airtable in the Search widget options. See our Search widget documentation for details.
When you add new search columns to a dataset (Google Sheet or Airtable), you will need to update your Collection in the Without Code builder. While we won’t go into detail on Collections, keep in mind that Collections are what the builder uses to connect your datasets to Dynamic Pages and Connected Data (see our Dynamic Pages documentation for details)
While Collections update automatically when new data is added or changed, Collections do not automatically add new Collection Fields that reflect new columns. This means that when new columns are added to a Google Sheet or Airtable already linked to a collection, you must add these as Collection Fields.
To add a new Collection Field, go to your Collection (Content > Collections). Select the appropriate Collection, and click the “Add field” link at the bottom of the Collection Fields.
Name the new field exactly as the column is named, i.e. “search_title”. Repeat this process as needed to add all search fields.
Note that you can also delete the collection and add it again as a new collection to save some time. Just be sure that any existing Dynamic Page or widgets using Connected Data link up with the collection afterward.
For a complete overview and video tutorial of Dynamic Pages, check out our 5-part video series:
Dynamic Pages Tutorial Video Series