How to control dynamic page SEO selections from DB internal order

Because I have dynamically generated pages which deal with “categories” - for example, a selection of Christmas motifs all shown on one page, is there a way to ensure that I can use an implicit internal sort order of the DB elements and pick up a field for SEO that would better illustrate the contents of the entire page rather than a single element? That is, because I don’t have access to my reference databases in the SEO selection, I cannot easily get my meta data which would be preferable for these page SEO descriptions, images etc … .

For example, I have various elements from a DB displayed on the page such as

Image of Santa, Description of Santa, other database fields
Image of Rudoph, Description of Rudolph, other database fields

What I would like to place in the SEO for this page is some sort of generic christmas title and description and image (which I have access to through a reference DB but of course, those are NOT accessible via the SEO selections).

Without adding yet another field in the DB and putting the desired information into ALL of them to ensure that the one field is populated for SEO use, IS THERE A WAY TO UNDERSTAND THE internal sort order or to force the sort order in some way such that I could populate and use JUST ONE of my entries in particular to pick my SEO description and image WITHOUT NEEDING TO REPLICATE IN ANOTHER FIELD THIS INFO FOR ALL INSTANCES of my entries.

In the same way you use reference DBases for this strategy for your page content, we don’t seem to be able to do the same for SEO.

Right now, I don’t appear to be able to even predict the database entry that will be picked up first for SEO from my dataset - it appears random, or even worse, picked up from some other non-dynamic static gallery on my page. I am trying to understand if there is a way to understand which row entry the SEO selections when you name a field on a dynamically generated page.

This problem would be solvable of course, if I could access another database through reference fields where I hold my category information.

Has anyone else been able to find a workaround to address this?

Deborah

This is quite a confusing post. Maybe you can outline what steps you are currently trying to/wanting to implement in a bulleted format?

I understand that you have two collections, tied via ref field and you’d like to be able to pull ref field data for your dynamic page’s SEO, but you’re saying more that’s quite murky.

Yes … I’m sure it is confusing. Ideally, I would like to be able to pull into an SEO setting, something from a reference to a different database through a reference field. I can, of course, do that on the dynamic page itself, but I cannot do that directly through the choices offered in the settings menu for SEO which only offers the text and probably number fields as options.

In order to work around this, I was hoping to pick up a value from one of the existing fields.

Here is a pretend example of the data available in one of the instantiations of my dynamic page which picks up all items with the Category field set to CHRISTMAS

Note that I can of course, pull generic “CHRISTMAS” information from my reference database for the page itself - however, I cannot do that within the SEO setting menu, which doesn’t allow me to access the Reference DB field.

I could potentially workaround it by loading another text or image field with the information of interest
if and only if there was a guaranteed way to know how the items are ORDERED internally. That is, could I rely on the fact that in this Category, the “Elf” line would be the row from which any of the fields would be used if I referenced them in the SEO settings.

Otherwise, to make this workaround workI would have to fill in the “other fields” for every instance of the Category CHRISTMAS, which I don’t want to do.

Category Item Comment Image Reference DB Other Fields
CHRISTMAS Elf on a shelf pic1 . ChristmasDB “use for SEO page info”
CHRISTMAS Santa ho ho ho pic2 . ChristmasDB
CHRISTMAS Reindeer reindeer pic3 . ChristmasDB

Perhaps there is a more elegant way to do this for a dynamic page.

Currently, however, I am seeing an image picked up for social sahre that is NOT even in the working set of data available for this dynamic page based on CHRISTMAS (that is, I would have expected, the Elf, Santa, or reindeer image to be grabbed) - instead a random image from another gallery on my page seems to be displayed. Not sure why since because I believe all my fields in this case are not empty.

Hope this helps to clarify a bit. I believe I had already verified that there is no way to make use of Reference fields in SEO settings.