Url/Hyperlink Embed in Zoho Creator

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.

for eg
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.

Thanks you
LVL 1
haravallabhanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsmith1962Commented:
Is this an Oracle database question?
0
VishnukumarCommented:
You can use formula fields to construct the hyperlink corresponding to the songs


 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
haravallabhanAuthor Commented:
@Vishnukumar

Great, thanks! can you please give me an example on how I could hyperlink using the formula. That will be quite helpful.
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

haravallabhanAuthor Commented:
@Johnsmith1962
Thanks for your comment. It is not an Oracle DB but from Zoho applications.
0
thmhCommented:
in zoho right  click cell  > hyperlink ,

or you can create hyperlinks cells in excel and import excel to zoho  spreadsheet ,
in excel07 right  click cell  > hyperlink ,
in zoho sheet import > local file
0
haravallabhanAuthor Commented:
IF you guys give me an example using the formulas that will be more helpful
0
thmhCommented:
here it is
Capture1.JPG
0
thmhCommented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.