1

I figured out how to change the fields in a calendar to add extra info about events. Is there a way that I can take the fields that popup when I try to add a new event and get a dropdown table based on existing SP lists?

For example, location is a field that needs to be filled in when a calendar event is made, so how can I make the location field a dropdown populated by my Locations SP list.

Further than that is there any way to do this and combine a SQL Server Table and a SP List together? Like if I had my SP list but I also had a DB of locations that would be changed by those who have access to the DB but not the SP lists?

0

For your first part, there isn't something out of the box that can handle it. You can either

  • Use some custom Javascript code to change the input to a dropdown, and save the value into the textbox. SPServices, http://spservices.codeplex.com/documentation, may have something that can do that

  • Add a separate field for location that is a dropdown, keep the original location, and use a workflow to update the original location field from the new field.

For your second part, you can use SQL tables in SharePoint via BCS (Business Connectivity Services) more details: http://msdn.microsoft.com/en-us/library/office/ee556826(v=office.14).aspx

  • I'd prefer to stay away from JS as it would be difficult for non-programmers to maintain, but the second option is more what I meant, but doesn't really solve the problem. How can I make the choices for the dropdown column be the elements of a sharepoint list? For example, if I make a new column of type choice (which gives me a drop down), it defaults to having "Choice 1", "Choice 2", and "Choice 3". If I have a Sharepoint list with 50 or 100 locations like "Houston" or "North Building", how can I make the dropdown automatically query that list and make the results the drop down choices? – user3380049 Oct 29 '14 at 15:20
  • Instead of a choice column, you want to use a Lookup column, which allows you to point to another SharePoint list. – David Lozzi Oct 31 '14 at 15:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.