Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Replacing calendar End Time with New calculated end time

  Asked By: Meredith    Date: Aug 19    Category: Sharepoint    Views: 5683

Situation: I have a regular calendar on my main page. I have added a Calculated
field in the calendar list to represent a new "end time", dirived from another
field configured as a number field that represents a "time offset". The
calculated field works properly to come up with a new end time based on the
formula I wrote in there.

Requirement: I want to take that new "end time" and insert it into the regular
calendars end time field, in effect - replacing it.

Any clever way to do this? A workflow perhaps?, I don't have the skill yet to
write custom code.



10 Answers Found

Answer #1    Answered By: Beatrice Serrano     Answered On: Aug 19

A SharePoint Designer workflow  should be able to do this, yes. In fact,
it could probably be used to do the calculation as well. The tricky
part is to make sure that you don't get into a circular update loop -
make sure you have some way to separate updates from the workflow from
"normal" updates of the item by other means. Without that, your
workflow will run over and over indefinitely.

Answer #2    Answered By: Maya Lewis     Answered On: Aug 19

I'll keep that circular update in mind as I play around with workflows. Thanks
for the reply.

Answer #3    Answered By: Paola Mcmahon     Answered On: Aug 19

Yes, keep it in mind, but also FYI they have fixed that issue in SharePoint 2007
SP2. Workflows that activate "on change" will no longer trigger themselves.
There is a recent post on the SharePoint Designer team blog about it.

Answer #4    Answered By: Justin Mckee     Answered On: Aug 19

What effect  do you want it to have? It's not hard to change fields in
views, etc.

Answer #5    Answered By: Jared Bell     Answered On: Aug 19

The normal SharePoint calendar, which has a start and end  time field, in my
application it has to insert  a new calculated  end time  into the normal calendars
end time.

The effect  of this is that the calendar  events will now display the new

Answer #6    Answered By: Bernice Puckett     Answered On: Aug 19

so you're not talking about replacing  the field  itself, but rather
updating the value of the original end  time field... correct?

Answer #7    Answered By: Mackenzie Lewis     Answered On: Aug 19

I have already done something similar to this using SharePoint Designer
Workflows. I had a list  of timeslots (with start and end  times) which I then
added as a select list to my calendar  appointments. My workflow  made the
appointment "snap" to the selected timeslot's start and end times.

There is a function in SPD workflows which allows you to add a specified number
of minutes, hours or days to a date, and another one which allows you to set the
time portion of a date. I used a combination of these two functions. You can
store these values in workflow variables during the workflow and then update the
item at the end of the workflow when all calculations have been performed.

BTW I did get looping problems when I added  the workflow to be initiated on
change of the item as the workflow was updating the item, and therefore
initiating the workflow again, and so on...!

Answer #8    Answered By: Kurt Gilbert     Answered On: Aug 19

check the article hope this signifies solution.

Answer #9    Answered By: Jaya Deoghar     Answered On: Aug 19

Thanks for tha input. I don't think it will replace a particular field  the way
I want, but it has some neat things to try on something else I'm working on.

Answer #10    Answered By: Candi Branch     Answered On: Aug 19

Exactly. Just the value................

Didn't find what you were looking for? Find more on Replacing calendar End Time with New calculated end time Or get search suggestion and latest updates.