https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/99230.aspxTue, 23 Sep 2014 08:08:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:99230sophieryder0https://www.infopathdev.com:443/forums/thread/99230.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=99230<p>Hi All,</p><p>I&#39;ve been building a form to create an appointment booking system.&nbsp; The method I&#39;ve chosen (which may not be the best way) is that&nbsp;I&#39;ve got a number of sharepoint list calendars that people will access in outlook as an overlay to their own outlook calendars (as well as directly in sharepoint if they please).&nbsp; They will enter their availability as calendar events (list items) which will be accessible to the contact centre advisors to see what time slots are free to pick from.&nbsp; The calendars available to pick&nbsp;from will be&nbsp;limited by a value in the form (location)&nbsp;based on a selected&nbsp;address.&nbsp; I was going to add all the calendars as sharepoint list data connections but I&#39;m limited to 15 connections so this is not feasible and would also be a bit of a management nightmare.&nbsp; I need individual calendars so each user can connect their calendar list to outlook and see only their own items.</p><p>Is there a way I can programatically create or update a data connection based on the location value e.g. if the value is lancaster I want to query x, y and z calendars and if the value is chorley I want to query a, b and c calendars?</p><p>As I mentioned I&#39;m not sure whether&nbsp;this is the best/only way forward.&nbsp; We are not limited to codeless solutions although ideally we&#39;re hoping to keep using SharePoint and InfoPath.</p><p>Happy to provide more details I&#39;m just not sure what else to elaborate on.</p><p>Thanks,</p><p>Sophie</p>