How do you determine what the <optionid> is for the "popular" or "not popular" dropdown options in the table?
I'm trying to create a custom module with “Choice options” that allow you to filter and show options on a page based on what is selected in the HubDB table's column. For example, I want all of our upcoming “Essentials” classes to be listed on a page using a custom module. Not sure I am doing this correctly...
I believe the value in the custom module would be something like…
Sure, you can use the hubdb_table_column hubl tag to get the list of options and then the getOptionByName method to get the option value. See http://designers.hubspot.com/docs/tools/hubdb
Can you tell me what I am doing wrong with these custom module values? How/where do I add what other columns in the table I want to be shown based on the course selected? Is this close? Not working as is...
Is the <columnId> just the name of the column select_course? I can't find id numbers for the table columns. Tried inserting the following into the custom module value choices and then then name of the widget {{ widget.select_course }} into the "Edit" field. Nothing shows up in preview.
Value 1: {% set col = hubdb_table_column (674971, select_course) %} {% set select_course = col.getOptionByName("Essentials") %}{{ select_course }}<h3>{{ row.course_name }}</h3><p><strong>Location:</strong> {{ row.class_location }}<br><strong>Date:</strong> {{row.date|datetimeformat('%A, %B %e, %Y') }}</p>
Value 2: {% set col = hubdb_table_column (674971, select_course) %} {% set select_course = col.getOptionByName("Drawings") %}{{ select_course }}<h3>{{ row.course_name }}</h3><p><strong>Location:</strong> {{ row.class_location }}<br><strong>Date:</strong> {{row.date|datetimeformat('%A, %B %e, %Y') }}</p>
Value 3: {% set col = hubdb_table_column (674971, select_course) %} {% set select_course = col.getOptionByName("Composer") %}{{ select_course }}<h3>{{ row.course_name }}</h3><p><strong>Location:</strong> {{ row.class_location }}<br><strong>Date:</strong> {{row.date|datetimeformat('%A, %B %e, %Y') }}</p>