haravallabhan
asked on
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
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
Is this an Oracle database question?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Vishnukumar
Great, thanks! can you please give me an example on how I could hyperlink using the formula. That will be quite helpful.
Great, thanks! can you please give me an example on how I could hyperlink using the formula. That will be quite helpful.
ASKER
@Johnsmith1962
Thanks for your comment. It is not an Oracle DB but from Zoho applications.
Thanks for your comment. It is not an Oracle DB but from Zoho applications.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
IF you guys give me an example using the formulas that will be more helpful
here it is
Capture1.JPG
Capture1.JPG