none
Calculated field not working for recurring event.

    Question

  • hi,

    I have a Calendar where i create a recurring item. I also have a calculated field to show each day when event occurs e.g saturday, sunday, monday...

    When item is created the calculated for all recurring item's instances gets filled with the day Item was created but not the actual date. I'm using following formula.

    =TEXT(WEEKDAY([Start Date]),"dddd")

    is there any way i could update all reaccuring events with respective day on calendar.

    thanks

    Aqib

    Thursday, July 14, 2011 3:52 PM

Answers

  • You could try creating a custom content type with custom fields. That way you can control your own rendering and logic and expose the extra calculated field.

    See this: http://msdn.microsoft.com/en-us/library/ee231593.aspx

    Otherwise, you are petty much stuck with what you have got.


    Please remember to mark as answered, if applicable. -- With Regards Shailen Sukul Entrepreneur/Software Architect/Developer/Consultant/Trainer (BSc | Mct | Mcpd (.Net 2/3.5/SharePoint2010) | Mcts (Sharepoint 2010/MOSS/WSS), Biztalk, Web, Win, Dist Apps) | Mcitp(SharePoint) | Mcsd.NET | Mcsd | Mcad) MSN | Skype | GTalk Id: shailensukul Twitter: http://twitter.com/shailensukul Ph: +1 916 359-9557 Website: http://sukul.org Blog: http://shailen.sukul.org/ http://www.linkedin.com/in/shailensukul
    Wednesday, July 20, 2011 12:37 AM

All replies

  • That is because only one start date is stored in SharePoint for the whole series and it is earlier or equal to the start date of the first
    occurence. This is by design and calculated fields will not work this way.

     

    One possible way could be(and I have not tested this) to add an extra field and use and event handler to update it.


    -- With Regards Shailen Sukul Entrepreneur/Software Architect/Developer/Consultant/Trainer (BSc | Mct | Mcpd (.Net 2/3.5/SharePoint2010) | Mcts (Sharepoint 2010/MOSS/WSS), Biztalk, Web, Win, Dist Apps) | Mcitp(SharePoint) | Mcsd.NET | Mcsd | Mcad) MSN | Skype | GTalk Id: shailensukul Twitter: http://twitter.com/shailensukul Ph: +1 916 359-9557 Website: http://sukul.org Blog: http://shailen.sukul.org/ http://www.linkedin.com/in/shailensukul
    Friday, July 15, 2011 1:47 AM
  • Thanks for the reply,

    I don't thing we can edit recurring events as it throws exception. 3

    the solution which i was thinking is to create an item added event. Once recursive item is add I will iterate through that item get its data and delet it.

    Than I will create same entries in Calendar with non Recursive events.

    will this be the exact solution? or should i go for anything else.

    thanks

    Aaqib

    Friday, July 15, 2011 7:33 AM
  • Essentially, you will be deleting recurring events and creating individual entries for the recurrences.

    This will get you around the issue, but you lose the advantages of managing events as a series of recurrences.

    If this satisfies your requirements, go for it.


    -- With Regards Shailen Sukul Entrepreneur/Software Architect/Developer/Consultant/Trainer (BSc | Mct | Mcpd (.Net 2/3.5/SharePoint2010) | Mcts (Sharepoint 2010/MOSS/WSS), Biztalk, Web, Win, Dist Apps) | Mcitp(SharePoint) | Mcsd.NET | Mcsd | Mcad) MSN | Skype | GTalk Id: shailensukul Twitter: http://twitter.com/shailensukul Ph: +1 916 359-9557 Website: http://sukul.org Blog: http://shailen.sukul.org/ http://www.linkedin.com/in/shailensukul
    Sunday, July 17, 2011 8:53 PM
  •  

    any other idea! as ive recently found out (in my requirements) that these recurrence events don't have an end date so, i can not create infinite list items for all recurring events.

    thanks Shailen for your help much appreciated.

     

     

    Monday, July 18, 2011 11:20 AM
  • You could try creating a custom content type with custom fields. That way you can control your own rendering and logic and expose the extra calculated field.

    See this: http://msdn.microsoft.com/en-us/library/ee231593.aspx

    Otherwise, you are petty much stuck with what you have got.


    Please remember to mark as answered, if applicable. -- With Regards Shailen Sukul Entrepreneur/Software Architect/Developer/Consultant/Trainer (BSc | Mct | Mcpd (.Net 2/3.5/SharePoint2010) | Mcts (Sharepoint 2010/MOSS/WSS), Biztalk, Web, Win, Dist Apps) | Mcitp(SharePoint) | Mcsd.NET | Mcsd | Mcad) MSN | Skype | GTalk Id: shailensukul Twitter: http://twitter.com/shailensukul Ph: +1 916 359-9557 Website: http://sukul.org Blog: http://shailen.sukul.org/ http://www.linkedin.com/in/shailensukul
    Wednesday, July 20, 2011 12:37 AM
  • as recurring events are created on the fly. I created java script function and calculated field as follows

    ="924d79c7795c"&TEXT([Start Time],"m-dd-yyyy")

    924d79c7795c is my guid to identify

    The JS is kept in CEWP on same page and it works with all the lists (Date) columns but still with Calendar's Current Events view it still uses start time of actual list item but not the recurring item displayed.

    I thought with js i could do it on the fly but it just dosent work.

    any idea. I actually dont want to go to Visual studio. (I will eventually if there is definately no other way).

    many many thanks

    Aaqib

    Tuesday, July 26, 2011 1:08 PM
  • i know its been forever but i dont suppose you could detail this out could you?
    Friday, April 12, 2019 5:46 PM