topic Re: Find number if within set range in CMS Development

Find number if within set range

ben-duchy — Wed, 21 May 2025 08:59:02 GMT

I'm hoping someone can help me with this one as the HubSpot reference on the range function is a little basic on the details.

I have created a new HubDB table that displays house information and set a basic HubL loop that pulls in all rows, displayed as a HTML table. The first column shows the house name, and the last column displays the SQFT.

I would like to add a new column to display a range based on the SQFT but show 100 either side of it, for example if the SQFT column shows 250, the new column needs to show 150 - 350.

Using a simple calculation can do this, but for the next part I'm totally stuck!

From this calculated range, I would like to show a second HTML table that shows each row in the same way as the first table, albeit without the SQFT and range columns, but instead show a relevance column.

The relevance column needs to cross reference it's own sqft for example 250, but then only display other house names where 250 is within their range, for example ' The Alderley' has 250 sqft which is within range of The Kensington (200 sqft) and The Warwick (275 sqft) - both of these would be displayed within the relevance column of The Alderley

Re: Find number if within set range

BarryGrennan — Wed, 21 May 2025 10:04:42 GMT

Hi @ben-duchy,

I think I'd need to see your code to full visualize what you mean but it sounds like an "if in" conditional should do the trick.

{% set the_range = range(5, 11) %} The range:{{the_range}} <br> {% set specific_number = 5 %} {% if specific_number in the_range %} {{specific_number}} = yahtzee! {% else %} {{specific_number}} = womp womp! {% endif %}

So you'd be plugging your values into something like that.

Again, without the code in front of me I'm struggling to visualize exactly what you'd plug in where and what sort of for loops you'd need to add, but my guess is it'd be along those lines.

It sounds like you may need some nested loops too if the relevance column needs to loop through other houses.

Barry Grennan

Freelance HubSpot CMS Developer

Website | Contact | LinkedIn

Re: Find number if within set range

ben-duchy — Wed, 21 May 2025 11:44:27 GMT

Hi @BarryGrennan,

Genius, thank you 😀

I had to tweak it slightly, but you ultimatley pushed me in the right direction...

{% set house_types = hubdb_table_rows(123456, "&limit=10000") %} <table> <thead> <tr> <th>Builder</th> <th>House Type</th> <th>SQFT</th> <th>Relevance</th> </tr> </thead> <tbody> {% for row in house_types %} {% set current_ht = (row.house_type) %} {% set minus_sqft = (row.sqft - 100) %} {% set plus_sqft = (row.sqft + 100) %} {% set the_range = range(minus_sqft, plus_sqft) %} <tr> <td>{{ row["developer"].name }}</td> <td>{{ row["house_type"] }}</td> <td>{{ row["sqft"] }}</td> <td> {% for row in house_types | rejectattr ("house_type","equalto",current_ht) %} {% set specific_number = (row.sqft) %} {% if specific_number in the_range %}{{ row["house_type"] }}{% endif %} {% endfor %} </td> </tr> {% endfor %} </tbody> </table>