Linking HubDB table + CRM object by matching values

Luke-Simp — Tue, 17 Jan 2023 00:26:23 GMT

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 %}

Re: Linking HubDB table + CRM object by matching values

alyssamwilie — Tue, 17 Jan 2023 14:19:03 GMT

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

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

Re: Linking HubDB table + CRM object by matching values

Luke-Simp — Wed, 18 Jan 2023 00:39:55 GMT

Thanks again. Really appreciate it.

topic Linking HubDB table + CRM object by matching values in CMS Development

Linking HubDB table + CRM object by matching values

Re: Linking HubDB table + CRM object by matching values

Re: Linking HubDB table + CRM object by matching values