HubDB Rows not Pulling into Module

[ATaylor40]

I apologize if this is a poorly formulated question. I’m the marketing manager at a company with no in-house developer or access to developer resources, so I’m trying to troubleshoot on my own.

We have a HubDB table that was created four years ago (well before my time) to house our testimonials, which are then pulled into a custom three-testimonial module on the website. I updated the table yesterday with 9 new testimonials I want to swap out on the site, but none of them are pulling into the modules.

Below is the relevant code on the module.

{# Get Testimonials from HubDB #} {% set query_which_quote = module.quote %} {% set table_testimonials = hubdb_table_rows(3411978, "&which_quote="~query_which_quote )%} {% if table_testimonials == [] %} {% else %} {% for row in table_testimonials %} <div class="item"> <span class="quote-icon"> <img src="{{row.profile_image.url}}" alt="Prialto Testimonial by {{row.author}} of {{row.company}}" width="150px" height="150px" loading="lazy" class="quote-icon" /> </span> <div class="author"> <div class="text-wrap">{{row.author}}<span class="title">{{row.company}}</span></div> </div> <div class="quote">{{row.quote}}</div> <div class="stars"> <img src="https://www.prialto.com/hubfs/five-stars-01.svg" alt="5 stars"> </div> </div> {% endfor %} {% endif %} </div> </div> <div class="col-12 col-lg-4"> <div class="box">

Is there something I need to update in this code (beyond publishing the table update, which I’ve already done), or is there a cache that needs to be cleared?

Any recommendations for next steps would be appreciated!

[BarryGrennan]

Hi @ATaylor40 ,
Is this where your testimonial module is? #1 Managed Virtual Assistant Service | Prialto
I would guess it’s not a caching issue as an uncached version of your page is the same: #1 Managed Virtual Assistant Service | Prialto
(Cheeky plug for my Hubspot Cache Buster)
Looking at your code, I think the first thing I’d check is this:

{% set query_which_quote = module.quote %}

That would seem to be a field called “Quote” in your module (although the label could possibly de differnt to the name)
That field is being used here:

{% set table_testimonials = hubdb_table_rows(3411978, "&which_quote="~query_which_quote )%}

That filters the quotes shown such that what is in “Which Quote” column must match the “Quote” input in the module.
I am sort of spitballing without being able to see the module and the table, but that’s the first thing I’d look at. Do the quotes that show on the site have the “Which Quote” column filled in? Do the new ones? Do they match (exactly!)

---

Barry Grennan

Freelance HubSpot CMS Developer

Website | Contact | LinkedIn

[ATaylor40]

You solved it for me! There was a quote field in the module that was hidden behind a toggle and a separate, similarly named, quote field in the HubDB editor. I was mistakenly editing one and not the other. Thank you so much for your help!

[GRajput]

Hi @ATaylor40

The issue seems to be with this line:

{% set table_testimonials = hubdb_table_rows(3411978, "&which_quote="~query_which_quote ) %}

It’s filtering rows based on the which_quote column. Make sure your new testimonials have a value in that column that matches the module.quote.

To test, remove the filter and just use:

{% set table_testimonials = hubdb_table_rows(3411978) %}

If the new testimonials appear, the filter is the issue. No cache clearing needed, HubSpot updates published HubDB data automatically.

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.

Thanks!

[BarryGrennan]

@ATaylor40 no worries, glad I could help

---

Barry Grennan

Freelance HubSpot CMS Developer

Website | Contact | LinkedIn