I am having a database maintained in zoho creator. I would like one of the columns to have hyperlinks so that when a user clicks a field/element inside the column a separate page opens up.
my fields consists of
song singers lyricist year Track
bad MJ MJ 1990 Listen
good Enrique lysk 1995 Listen
The database looks like this but I want everything in the
1) Song column to be hyperlinked to an URL so that the user can buy this song say from an online music store.
2) Singers column to be hyperlinked to a URL so that when people click on it it takes them to the say an Amazon.com site where they can find albums of this singer
3) Track column should be hyperlinked/embeded so that users can listen to that track 'correcsponding to the song column in an embeded player or hyperlinked to a site that has this song.
I already have this database with fields and would like to append the database with the said rules.
I gather that one should need to write some functions to this but I am complete novice in this and any help will be highly appreciated.