I am creating a Spreadsheet to hold a List of URLs, I have created a Query URL to filter the list and display the correct links in an html format, but I need the links to be clickable in the page
The URL is below https://spreadsheets.google.com/tq?tqx=out:html&tq=Select%20B%20WHERE%20A%20LIKE%20%22Abigail%22&key=1MDAiwcP-OYj52Va0vkcNN5cMTg2KSb7cyqLbg3GrblA
I have tried adding the Hyperlink html tags in the query and in the source data but neither have helped (in query generated error, in source just displayed in text as part of the result), I am able to click the link when I access with preview tag so the link is configured correctly:
https://docs.google.com/spreadsheets/d/1MDAiwcP-OYj52Va0vkcNN5cMTg2KSb7cyqLbg3GrblA/preview#gid=0