Can I make the output of this snippet as a list rather than inline
{dbselect: SELECT Colourway FROM Colourways ORDER BY Colourway ASC LIMIT 900; space=02HdgZGm0jNamFkoQbvhd3; menu=yes; multiple=yes}
{=Colourway}
Can I make the output of this snippet as a list rather than inline
{dbselect: SELECT Colourway FROM Colourways ORDER BY Colourway ASC LIMIT 900; space=02HdgZGm0jNamFkoQbvhd3; menu=yes; multiple=yes}
{=Colourway}
You should be able to do this using {repeat}. You can click the three dots in the command chip to insert a repeat. Then, the way you format the repeat command in the snippet depends on how the output is formatted.
Please give that a try and let me know if it works for you.
Here's an example I used:
{dbselect: SELECT Name FROM CRM ORDER BY Name ASC; space=3DO7w36GdXYVxP9NUz1pv9; multiple=yes; menu=yes; name=customers}
{repeat: for item in customers}
{=item["name"]}{endrepeat}
Thanks Dylan. Just what i needed.