Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sharepoint 2010 Custom Column - linked to External Data - autopopulate the other fields

Posted on 2013-11-12
2
Medium Priority
?
565 Views
Last Modified: 2013-11-21
I have a Calendar with additional custom columns. In the columns I have a field that I use Column Type :  External Data. I can see my data and it works great. I can select my External Content Type and I select my external data from source called CUSTOMERORDERS.

I have a field named CONumber that I want to select. I want this to auto-populate the other fields in the calendar and it does not. Basically when I select the CONumber field I want it to auto-populate CustName and CustState and CustID. These fields are in my CUSTOMERORDERS table (external data set)

How do I just select the CONumber and these other fields just automatically populate the corresponding data?
0
Comment
Question by:allenkent
[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 9

Accepted Solution

by:
skipper68 earned 2000 total points
ID: 39647805
You'd probably be best to create CONumber as a site column instead of on the calendar.  When you create CONumber, make it a lookup type and check the boxes at the bottom to include other columns to bring along when CONumber is added to a list.

Then, add the new "CONumber" site column from the existing field list to the calendar.  Now, whenever you create a new item and choose a CONumber, it will populate the other fields.  I remember the first time I figured this out, I thought it was magic :-)

If this isn't clear, I can see if I can put something together to help.
0
 

Author Closing Comment

by:allenkent
ID: 39666514
Site Column is an interesting idea. thank you.
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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

650 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