Linking HubDB table + CRM object by matching values

[Luke-Simp]

Hi all,

Looking to match CRM object "people" selected in module field to table column value. If match, then show the row info associated with that person. i.e. if "preferred_full_name" in CRM record is "Jeff Aernie" and "name" in HubDB table is "Jeff Aernie", then display listings of books associated with this author (with a few other filters applied).

Below is what I've got so far. Code works without trying to refer to CRM object but would like to be able to do this. Appreciate the help.

<h2>Jeff's Visible Book Chapters</h2>
{% for row in hubdb_table_rows(5643545, "type_of_publication=Book chapter&visible=yes&orderBy=-year_published") %}
{% if row.name == "module.person.properties.preferred_full_name" %}
{{row.name_of_authors}} ({{ row.year_published }}). <em>{{ row.publication_title}}</em>. {{row.booksbook_chaptersmusic_publisher_name_and_place}} <br>
{% endif %}
{% endfor %}

[Luke-Simp]

Thanks again. Really appreciate it.

[alyssamwilie · Accepted solution]

I believe if you remove the quotations in the following line it should work:

{% if row.name == "module.person.properties.preferred_full_name" %}