use flow to list in-between numbers in a year range

[automaniaaaa]

Hi Guys,

I run an auto parts store.

Products are linked to a vehicle via a metaobject and then made "accessible" to site search and filters when flow passes that data into separate metafields

The issue I'm having is on our Make, Model, Year form. Specifically on the "year" portion since products fall in a year range not a singular year and I don't want to list each year manually

Is it possible for flow to look at the year range e.g. 2012-2015 and list out the start, end and in-between years in the metafield? Here's the example of the output I'd like:

Also, is it possible for flow to treat "current" (we use for models which don't have a defined end year) as the current year and automatically update the year range when the year ticks over? Here's the example of the output I'd like:


By solving this, we would able to list all the applicable years Make Model Year form on the front end in a concise/standardized way

[automaniaaaa]

Hi would love any advice. I can't PM you (your PM settings must not be on). Please msg me directly when you've got that setup

[automaniaaaa]

Alternatively if you could steer me in the right direction in this public forum (even if only general principles) perhaps that advice could benefit someone else in future also...

[Mivicle]

To parse values from a single string and form a new string, it’s convenient to use the Run code action. If you don’t have programming skills, an AI like Anthropic Claude or ChatGPT should be able to handle such a script effectively.

[paul_n]

Not sure what type of metafield you have, but something like this in liquid might work when setting that metafield:

{% capture this_year %}{{ "now" | date:"%Y" }}{% endcapture %}
{% capture first_year %}{{product.myMetafield.value | first}}{% endcapture %}
{% for year in (first_year..this_year) %}
{{ year }}
{% endfor %}