topic Re: Cannot Resolve Property 'name' in CMS Development

topic Re: Cannot Resolve Property 'name' in CMS Development https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/675941#M29904 <P>And sorry one more question... since it has multiple states, I want to add a comma between each state with display: inline so it is all on one line. Any way I can do that?</P><P>They're just block elements right now <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2022-08-04 at 1.36.30 PM.png" style="width: 999px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/72185i124A2613CDE8EE4F/image-size/large?v=v2&px=999" role="button" title="Screen Shot 2022-08-04 at 1.36.30 PM.png" alt="Screen Shot 2022-08-04 at 1.36.30 PM.png" /></span></P> Thu, 04 Aug 2022 20:38:25 GMT unicorndev 2022-08-04T20:38:25Z Cannot Resolve Property 'name' https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/675834#M29895 <P>Hello there! I want to be able to print out my multi select field called 'state' (it was single prior, I'll change it later lol). My code says 'Cannot Resolve Property: Name' when I try to extract the value from my HubDB. </P><P>I was able to extract it successfully when I had a single select dropdown, but I need it for multi-select now.</P><P> </P><P>Here is my complete code:</P><P> </P><P> </P><LI-CODE lang="markup"> <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.2/css/all.css"> {% set int_state_ID = 1 %}  <div> <form id="form_id" method="get"> <div> <h2>FILTER BY STATE: </h2> <select name="state" form="form_id" onChange="this.form.submit()"> <option value="show-all">Show All</option> {% set states = hubdb_table_column(5440613, "state").options %} {% for choice in states %} {% set state_list = state_list~choice.id|list%} {% if choice.id == request.query_dict.state%} <option selected="selected" value="{{ choice.id }}">{{ choice.name }}</option> {% else %} <option value="{{ choice.id }}">{{ choice.name }}</option> {% endif %} {% endfor %} </select> <input name="name" type="text" id="search-by" class="autocomplete" placeholder="Search by name..."> </div> {# <div> <input name="name" type="text" id="search-by" class="autocomplete" placeholder="Search by name..."> </div> #} <div class="button button-decor" input id="submit-button" type="submit" value="Search">Search</div> {# <div class="button button-decor"><input type="button" onclick="location.href='http://21908587.hs-sites.com/uson-local-support';" value="Show All" /></div> <div class="button button-decor"><input type="button" onclick="location.href='http://21908587.hs-sites.com/uson-local-support-0';" value="View International Consultants" /></div> #} <div class="button button-decor" onclick="location.href='http://21908587.hs-sites.com/uson-local-support';">Show All</div> <div class="button button-decor-2" onclick="location.href='http://21908587.hs-sites.com/uson-local-support-0';">View International Consultants</div> </form> </div>  {% set queryparam = "" %} {% if request.query_dict.state in ["1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50"] and request.query_dict.name == "" %} {% set queryparam = queryparam ~ "&state=__contains"~request.query_dict.state|urlencode %} {% endif %} {% if request.query_dict.state in ["1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50"] and request.query_dict.name != "" %} {% set queryparam = queryparam~"&state="~request.query_dict.state|urlencode~"&zip__icontains="~request.query_dict.zip|urlencode %} {% endif %} {% if request.query_dict.state == "show-all" and request.query_dict.name != "" %} {% endif %} {% set table = hubdb_table_rows(5440613, queryparam) %}  {% if table == [] %} <p class='align-center'>Sorry, no listings found for that search. Try changing your filter and search again.</p> {% else %} {% for row in table|sort(False, False, 'state') %} <div class="consultant-listing"> <h2>{{ row["name"] }}</h2> <div class="information"> {% for row in table %} {% for state in row.state %} <div class="fac_state">{{ row.state.name|pprint }} </div> {% endfor %} {% endfor %} <div class="fac_city"">{{ row["city"] }}, {{ row["zip"] }}</div> <i class="fas fa-phone"></i> {{ row["phone"] }} <br> <i class="fas fa-link"></i> <a href="{{row["website"]}}">Website</a> <br><i class="fas fa-envelope"></i> <a href="mailto:{{ row["email"] }}">{{ row["email"] }}</a> <div class="location_details">{{ row["location_details"] }}</div> </div> </div> {% endfor %} {% endif %}</div></LI-CODE><P> </P><P> </P><P> </P><P>row.state.name is printing out null, so there is no value.</P><P>When I put down {{row.state}} it renders:</P><DIV class="">[{id=3, name='Arizona', order=2}, {id=6, name='Colorado', order=5}]</DIV><DIV class="">[{id=3, name='Arizona', order=2}, {id=6, name='Colorado', order=5}]</DIV><DIV class=""> </DIV><DIV class="">How do I properly extract 'name'?</DIV><DIV class=""> </DIV><DIV class=""><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2022-08-04 at 11.04.01 AM.png" style="width: 400px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/72171iCE6709DF60753F62/image-size/medium?v=v2&px=400" role="button" title="Screen Shot 2022-08-04 at 11.04.01 AM.png" alt="Screen Shot 2022-08-04 at 11.04.01 AM.png" /></span></DIV><DIV class="">Here is a screenshot of my HubDB table. So 'State' is multi-select now instead of select. I just want to extract the values of State and render it correctly on the webpage. </DIV><DIV class=""> </DIV><DIV class="">I also checked here: <A href="https://community.hubspot.com/t5/CMS-Development/How-to-Get-Filtered-Data-From-HubDB-from-Multiple-Select-Column/m-p/257682" target="_blank" rel="noopener">https://community.hubspot.com/t5/CMS-Development/How-to-Get-Filtered-Data-From-HubDB-from-Multiple-Select-Column/m-p/257682</A></DIV><DIV class=""> </DIV><DIV class="">...But maybe I need a second pair of eyes to check my code?</DIV><DIV class=""> </DIV><DIV class="">Thank you!</DIV> Thu, 04 Aug 2022 18:06:50 GMT https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/675834#M29895 unicorndev 2022-08-04T18:06:50Z Re: Cannot Resolve Property 'name' https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/675864#M29898 <P>Hi <a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/388114">@unicorndev</a> </P> <P> </P> <P>{{row.state}} is an array and your code looks like this:</P> <P> </P> <P>{% for row in table %}<BR />{% for state in row.state %}<BR /><div class="fac_state">{{ row.state.name|pprint }} </div> <BR />{% endfor %}</P> <P> </P> <P>What is the output if you do this instead:</P> <P>{% for row in table %}<BR />{% for state in row.state %}<BR /><div class="fac_state">{{state.name|pprint }}</P> <P></div><BR />{% endfor %}</P> Thu, 04 Aug 2022 18:56:20 GMT https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/675864#M29898 Teun 2022-08-04T18:56:20Z Re: Cannot Resolve Property 'name' https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/675928#M29902 <P>Thanks! I took out the forloop going through each row in the table because it was looping and printing out all states in every company name, even for fields it didn't belong to lol. I appreciate that so much, thank you.</P> Thu, 04 Aug 2022 20:23:03 GMT https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/675928#M29902 unicorndev 2022-08-04T20:23:03Z Re: Cannot Resolve Property 'name' https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/675941#M29904 <P>And sorry one more question... since it has multiple states, I want to add a comma between each state with display: inline so it is all on one line. Any way I can do that?</P><P>They're just block elements right now <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2022-08-04 at 1.36.30 PM.png" style="width: 999px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/72185i124A2613CDE8EE4F/image-size/large?v=v2&px=999" role="button" title="Screen Shot 2022-08-04 at 1.36.30 PM.png" alt="Screen Shot 2022-08-04 at 1.36.30 PM.png" /></span></P> Thu, 04 Aug 2022 20:38:25 GMT https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/675941#M29904 unicorndev 2022-08-04T20:38:25Z Re: Cannot Resolve Property 'name' https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/676118#M29913 <P>Which words from your screenshot would you like next to each other?</P> Fri, 05 Aug 2022 07:54:57 GMT https://community.hubspot.com/t5/CMS-Development/Cannot-Resolve-Property-name/m-p/676118#M29913 Teun 2022-08-05T07:54:57Z