SharePoint QA
NancyCentury
Member
I need to add a custom column (hyperlink) to my list that will always point to the same location, for every item.
I know I can add workflow on item creation to populate this column with the URL I want, but I REALLY would prefer to just have the item create with that hyperlink already set up.
Why is there no default value option for hyperlinks, and how can I enable it? Is it truly one of those "you just can't do it" situations?
Why not using calculated column? It does not consume your resources and it is available immediately.
NancyCentury
Member
I would- but how to construct the formula?
Use the following formula:
="<a href='http://yoururl.com'>Enter URL Text here</a>"
You will also need HTML Calculated Column http://pathtosharepoint.wordpress.com/2009/07/09/html-calculated-column-update-2-1/
NancyCentury
Member
I must be missing something or I am not understanding you correctly... your example was the link itself. I assumed I would need a formula that will work as a calculated column but contains the full URL as well as the text to display. In your example, the URL was http://www.yoururl.com but the link displayed was "enter URL text here."
How do you combine the URL and the display text so that they function in a calculated column?
Sorry my post was reformatted by this forum. Check the previous post again and you will find the correct formula.
NancyCentury
Member
It's not allowing me to create the column... sigh.
What's the problem?
NancyCentury
Member
When I go to create the new calc. column, I enter the formula as specified with field type as "single line of text" and get the "unsupported/syntax error" error message. I cannot create the column.
!? Well I just pasted it again and it worked :)))) on another SharePoint. Maybe you could try typing it in... because formatting might get lost on web.
NancyCentury
Member
Mine returns "The formula contains a syntax error or is not supported."
Maybe my URL is too long or contains too many odd characters... it's the URL that you would get if you clicked the "add new item" link under a traditional Project Documents web part. So it is pretty convoluted.
My goal is to allow that same hyperlink within each Project List item, which will take the user to the upload page, since I don't have a traditional list view web part for this library- I have a data view web part. That way they can have all the functionality they need from within each list item.
I am out of options... The formula works and it should work... but I really do not know how could I help you becasue I cannot access your SharePoint directly... :(((
NancyCentury
Member
It's OK. Thank you for all you have done already! :-)
You must log in to post.
