La fonction de suggestion automatique permet d'affiner rapidement votre recherche en suggérant des correspondances possibles au fur et à mesure de la frappe.
Hello, I am working on a database driven page of training opportunities and running into some issues with filtering. The end goal is to have a block of text come up if a certain combination or varibales are not found in the tabl, however I don't want this to repeat for each row in the table I was to only see this message once.
Here is a snippet of current code I am using
{# Finance Tab #}
<div class="finance-tab padding40tb">
<h2>Finance</h2>
{% if table == [] %}
<p class='align-center'>Sorry, there is an error on this page.</p>
{% else %}
<div class="trainings">
{% rich_text "my_rich_text" label="Enter text here" html="<p>Take some time to get the most out of Church360° Members by attending one of our free training webinars!</p>" %}
{# Finance Webinars #}
<div class="webinars padding20tb">
<div class="section-subheader">{% header "my_header" header_tag="h3", overrideable=True, value="Webinars", label="Header" %}</div>
<div class="table-header">
<div class="table-header-row">
<div class="box box1">Title</div>
<div class="box box2">Date</div>
<div class="box box3">Time</div>
<div class="box box4">Link</div>
</div>
</div>
{% for row in table|sort(False, False, 'date') %}
{% if row["ss-module"].name is containing "Finance" %}
{% if row["type"].name is containing "Webinar" %}
<div class="boxes">
<div class="boxes-row">
<div class="box box1">{{ row.name }}</div>
<div class="box box2"> {{ row.date|datetimeformat('%B %e, %Y') }}</div>
<div class="box box3">{{ row.time }}</div>
<div class="box box4"><a href="{{ row.url }}" target="_blank" class="cta-green-solid">Register</a></div>
</div>
</div>
{% endif %}
{% endif %}
{% endfor %}
</div>
{# End Finance Webinars #}
{# Finance Seminars #}
<div class="seminars padding20tb">
<div class="section-subheader">{% header "my_header_2" header_tag="h3", overrideable=True, value="Seminars", label="Header" %}</div>
<div class="table-header">
<div class="table-header-row">
<div class="box box1">Title</div>
<div class="box box2">Date</div>
<div class="box box3">Time</div>
<div class="box box4">Link</div>
</div>
</div>
{% for row in table|sort(False, False, 'date') %}
{% if row["ss-module"].name is containing "Finance" and row["type"].name is containing "Seminar" %}
<div class="boxes">
<div class="boxes-row">
<div class="box box1">{{ row.name }}</div>
<div class="box box2"> {{ row.date|datetimeformat('%B %e, %Y') }}</div>
<div class="box box3">{{ row.time }}</div>
<div class="box box4"><a href="{{ row.url }}" target="_blank" class="cta-green-outline">View Recording ►</a></div>
</div>
</div>
{% endif %}
{% endfor %}
</div>
{# End Finance Seminars #}
</div>
{% endif %}
</div>
{# End Finance Tab #}
@cph_design - I like @Jsum answer because of scoping issues within for loops can make it impossible to keep a running total of things outside of a for loop (meaning, you can't set variables or override variables outside of the for loop).
But, if you want to count the results, you could use the follow:
from within the loop:
{{loop.length}}
from outside of the loop:
{{table|sort(False, False, 'date')|length}}
If this answer helped, please, mark as solved 😄
tim@belch.io | forms.belch.io | Design your own Beautiful HubSpot Forms; No coding necessary.