How can I set the selected choice to use it like a filter?

[naixs]

<select class="list-city dropdown" name="city">
{% set types = hubdb_table_column(module.hubdbtable_field, "city").options %}
{% for choice in types %}
<option value="{{ choice.name }}">{{ choice.name }}</option>
{% endfor %}
</select>

{% set table = hubdb_table_rows(module.hubdbtable_field, 'city=(choice-selected-here)') %}

[stefen]

@naixs looks like your using "city" as the name for that form input. If you are using a form the native browser way, it should add a query paremeter to your URL when you submit the form which should look like this example.com/page?city=new%20york

You can use HubL to look for that query parameter in the URL when the page refreshes to add the "selected" attribute.

Here's what that looks like with your code:

<select class="list-city dropdown" name="city">
{% set types = hubdb_table_column(module.hubdbtable_field, "city").options %}
{% for choice in types %}
<option {% if choice.name == request.query_dict.name %}selected{% endif %} value="{{ choice.name }}">{{ choice.name }}</option>
{% endfor %}
</select>

HubSpot has a great tutorial for a basic HubDB filtering system that you can reference here.

[naixs]

Thanks for the answer, I tried with this option but the "if" is not working and didn´t change the selected choice

<div>
<form id="form_id" method="get">
<div>
<h4>FILTER BY LISTING TYPE: </h4>
<select class="list-city dropdown" name="city">
{% set types = hubdb_table_column(module.hubdbtable_field, "city").options %}
{% for choice in types %}
<option {% if choice.name == request.query_dict.name %} selected {% endif %} value="{{ choice.name }}">{{ choice.name }}</option>
{% endfor %}
</select>
</div>

</form>
</div>

[stefen · Accepted solution]

It only works if you have your query parameter in the URL that the HubL is looking for. Open the preview URL in a new window, then at the end add your "&name=1" and see if it works.

[sharonlicari]

Hey @naixs 

Thank you for sharing this information, I'll tag a few experts could share their knowledge with you.

Hey @John @stefen @Jsum  any advice you can give to @naixs ?  

Thank you & Happy Friday

Sharon