function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
NETxCKNETxCK 

simple image formula not so simple

I'm trying to embed a graph from compete.com as an image formula for an account.  The URL is always displayed at a unique URL like this:

http://grapher.compete.com.edgesuite.net/google.com_uv.png

where you see google.com should be replaced with "& Website", but I think the _uv.png at the end of the URL is causing me problems.  This looks like it should be very simple, yet I keep getting syntax errors. 

If anyone can provide me with the correct formula I'd appreciate it.

-Chris
HerosHeros
I have found that I could not use that link directly within the formula.  The workaround that I found is that I created an Image Location field on my Leads.  I then created a formula that says:

IMAGE( Image_Location__c , "Other Text" )

I then went to a Lead and Inputed (below) into my Cusotm Lead Location field:

 http://grapher.compete.com.edgesuite.net/google.com_uv.png

That gave me the following: 
NETxCKNETxCK
Hmm.... The problem I have is that I want to use the website field to automatically merge into the formula so that it automatically displays on a page without me having to enter them in per record.  I have done this successfully for alexa graphs:

IMAGE( "http://traffic.alexa.com/graph?w=379&h=216&r=max&z=&y=r&u=" &  Website , "Alexa Data", 216,  379 )

There has to be a way.

Thanks for the effort.
NETxCKNETxCK
Gave it a few more tries and finally figured it out:

IMAGE("http://home.compete.com.edgesuite.net/" &  Website  & "_uv.png", "compete.com")

I think I was only off by a character or two, but it works now.
NETxCKNETxCK
I finally did figure this one out, here is the formula if anyone cares:

IMAGE("http://home.compete.com.edgesuite.net/" &  Website  & "_uv.png", "compete.com")

It seems very simple, not sure where I was getting the errors from but it works nicely now.

-Chris