Hi,
My site contains song lyrics, every song is an item in my database (only the lyrics).
I created a field in my database which is called "counter" that counts how many times visitors entered a specific song (the item).
In my home page I display the three songs which visitors watch the most.
I wanted visitors to be able to click on the text that shows the most viewed songs, and transfers them to the song's page (a dynamic page) with the song's name item.
Is it possible? I know how to direct a "text field" to other page in my site with a constant item but how can I add a dynamic link to a "text field", that can direct to dynamic page with other item every time? (depends on which song visitors watch the most).
![](https://static.wixstatic.com/media/a27d24_8ceb74fcec6c40708a84415fcb5e84a1~mv2.png/v1/fill/w_47,h_24,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/a27d24_8ceb74fcec6c40708a84415fcb5e84a1~mv2.png)
I had a similar problem: I wanted a table displaying query results to link to other subpages. The only way I could figure was to create another field in my table with a URL that points to that page.