Linking HubDB table + CRM object by matching values
SOLVEHi 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 %}
1 Accepted solution
Linking HubDB table + CRM object by matching values
SOLVEI believe if you remove the quotations in the following line it should work:
{% if row.name == "module.person.properties.preferred_full_name" %} | If this answer solved your question, please mark it as the solution. |
 | Alyssa WilieWeb Developerat Lynton |  |
 |
Linking HubDB table + CRM object by matching values
SOLVELinking HubDB table + CRM object by matching values
SOLVEI believe if you remove the quotations in the following line it should work:
{% if row.name == "module.person.properties.preferred_full_name" %} | If this answer solved your question, please mark it as the solution. |
| Alyssa WilieWeb Developerat Lynton | |
|
