Solved

Create a hyperlink for each individual item in a simple SharePoint 2010 list

Posted on 2013-06-14
2
645 Views
Last Modified: 2013-06-15
The Goal is to have a unique link that opens the view form for the item linked.  Need to embed the links in another application, with each link unique to each item (not the bulk list.)

Would "be nice" to create a column for each item that is a link to the item, so when downloading the list to excel, the links are formed in the column according to their unique item.

Bonus is the links fire the view item sub-form.  Thanks as always...
0
Comment
Question by:VirtualKansas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 39249564
Hello,

set the list to open the form in the full page, not the modal dialog. Open an item. Look at the URL. That's the format you need. It has the item's ID number in there.

Create a view that shows the item ID. Export that view into Excel. Create a formula that stitches together the URL as seen in the browser, using the ID in the current row (as exported with the view).

Copy the formula results and paste as values. There are your links.

cheers, teylyn
0
 

Author Closing Comment

by:VirtualKansas
ID: 39250179
OK; that's a good solution.  A few other steps may be to automate, but thank you.  Helps to have a second set of eyes; was too thick headed yesterday to think of this.  Thanks again...
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question