topic Re: Get row item.name in lowercase and withous spaces in CMS Development

Get row item.name in lowercase and withous spaces

peesen — Thu, 01 Apr 2021 12:03:20 GMT

Hello everyone

I need to get the values of a HubDB Multi-Select-Field and set all to lowercase and remove the spaces. How is this possible in HubSpot?

Thank you so much!

{% for item in row.departments %}{{ item.name }}{% endfor %}"

Re: Get row item.name in lowercase and withous spaces

dbeau79 — Thu, 01 Apr 2021 13:24:58 GMT

@peesen , so you want to get this for each row, right? Not all the options available in the column? If so you could do it as follows:

{{ item.departments|map('name')|join(' ')|lower }} ... this would replace your for loop.

Re: Get row item.name in lowercase and withous spaces

peesen — Thu, 01 Apr 2021 14:27:52 GMT

Hello @dbeau79 . Yes i need to get every row of the MultiSelect Field from the HubDB. When i replace my loop with your code i get no output. Can you please help me with more details?

Re: Get row item.name in lowercase and withous spaces

dbeau79 — Thu, 01 Apr 2021 14:32:06 GMT

@peesen , Can you drop in the code for your whole table loop?

Re: Get row item.name in lowercase and withous spaces

peesen — Thu, 01 Apr 2021 14:41:38 GMT

@dbeau79 Yeah for sure. This is my loop:

{% set tableId = 'team' %} {% if tableId %} <div class="module-team" style="margin: 0 auto;"> <div class="team_grid_wrapper" id="myTable"> {% set queryparam = "&orderBy=lastname&orderBy=firstname" %} {% set table = hubdb_table_rows('team', queryparam) %} {% for row in table %} <div class="team_block {% for item in row.departments %}{{ item.name }}{% endfor %} TEST"> <div class="team_img"> <span>Here comes the img</span> </div> <div class="team_text_wrapper"> <div class="team_text"> <h3>{{ row.lastname }} {{ row.firstname }}</h3> </div> </div> </div> {# Team block #} {% endfor %} </div> {# Team Grid Wrapper closed #} </div> {% endif %}

Re: Get row item.name in lowercase and withous spaces

dbeau79 — Thu, 01 Apr 2021 14:49:20 GMT

Ah, try this:

(swapped "item" for "row")

Re: Get row item.name in lowercase and withous spaces

peesen — Thu, 01 Apr 2021 15:00:37 GMT

@dbeau79Thank you so much, the lowercase output is now working perfect! 🙂 But how can i remove the spaces inside the names? Thank you so much for all your help! I really appreciate it!

Re: Get row item.name in lowercase and withous spaces

dbeau79 — Thu, 01 Apr 2021 15:08:19 GMT

@peesen , happy to help... probably a prettier way to do this but this will work:

{{ row.departments|map('name')|join(',')|lower|replace(' ','-')|split(',')|join(' ') }}

Re: Get row item.name in lowercase and withous spaces

peesen — Thu, 01 Apr 2021 15:47:49 GMT

@dbeau79Oh wow! This Version is even better than what i thought with just removing the spaces. Thank you so much for your help! Have a nice evening!