update master calendar from sub calendar with Sharepoint Designer 2010 Workflow
-
25 April 2012 1:39If I enter an item in "Calendar A" for Monday, it will update in "Calendar B". Then if I enter an item in "Calendar A" for Tuesday it will update in "Calendar B" but it will also delete the entry in the "Calendar B" Monday entry. I need both items displayed in "Calendar B"! Any assistance you could provide would be greatly appreciated!!
Semua Balasan
-
26 April 2012 7:36Moderator
Hi ,
I understand that you want to update parent Calendar list using workflow .There is a limitation :When these parent and child Calendar list are not in the same site ,then the OOTB workflow cannot create or delete item in the parent Calendar list .
You can try with Calendars Overlay in Calendar list .In this way ,you can add multiple events from all sub sites to show on the parent Calendar .
- Open the parent Calendar in browser .Choose Calendar tab and click ‘Calendars Overlay”.
- Choose New Calendar .Specify the site url and click Resolve .Then the Calendar lists in the site will show up in the drop down list .
- Choose the Calendar and check ‘Always show ’ .Then all the events from these Calendars will display together on the parent Calendar in different colors .
Entan Ming
TechNet Community Support
-
26 April 2012 9:27Entan thanks for you reply! I forgot to mention both calendars are in the same site!
-
30 April 2012 2:25I have a site called "Projets". Within this site I have 2 calendars. If I enter an item in "Calendar A" for Monday, it will update in "Calendar B". Then if I enter an item in "Calendar A" for Tuesday it will update in "Calendar B" but it will also delete the entry in the "Calendar B" Monday entry. I need both items displayed in "Calendar B"! My manager would then like to export "Calendar B" to Excel! Any assistance you could provide would be greatly appreciated!!
-
04 Mei 2012 2:34Moderator
Hi ,
Since you need to export the events to Excel ,i would recommend to use SharePoint Designer workflow to update Calender B .Open the Projects Site in SharePoint Designer .
- Create a worflow for Calendar A .Set the start option as 'Automatically start when an item is created '.
- Add an action 'Copy list item' .Copy current item to Calendar B .
- Publish the workflow .
In this way ,when an item is created in Calendar A ,the item is copied to Calendar B .
Thanks
Entan Ming
TechNet Community Support
-
04 Mei 2012 11:56But what happens if the previous item gets updated? will it overwrite and replace? or just add another entry?
-
06 Mei 2012 0:49Entan, this doesn't work for me. It creates the new entry but also keeps the old entry. If I enter a item in the "Calendar A" it will copy to "Calendar B". But if go back to "Calendar A" to edit it will create the new entry in "Calendar B" but also keep the old entry in "Calendar B" I need the entry(s) in "Calendar B" updated(if needed) for each day!