Forum Discussion
Entering a contact column within Sharepoint
Hi,
I'm pretty new to Sharepoint and I'm trying to use it to manage my bookings for my business. I would like to have a column within the Sharepoint list that allows me to enter the name and/or email address from someone within our contacts (Admin Center: Users: Contacts).
Sorry if the above doesn't make absolute sense, perhaps if I describe how things are set-up, it might make more sense.
I run a mountaineering business, all of our guides are freelance guides and their names and emails are saved as contacts within Office 365. They do not have access to our Office 365.
I'm trying to create a Sharepoint list for our bookings and one of the columns will be the guide's email address, which I was hoping could be pulled from the contact list, but I can't see a way to do that. Only active users' contact details can be pulled up within this column.
Create a list called Guides for example. It could contain columns for Guide Name, Guide Email etc.
Then in your main list, let's call it Bookings, add a lookup column against the Guides list you just created, and pull in the Guide Name column, and also choose "Add a column to show each of these additional fields:" and select Guide Email. Then when you add a new booking, you'll be able to add the name of the guide right from the new item screen, and when you save, that guides email will also be added to the item in the Bookings list. Hope this helps
radioroundup Great, thanks for that, that makes sense. I assume I'd have to update this list if we add new guides to our contacts. This doesn't happen very often, so wouldn't be too much hassle to do.
