Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Replacing calendar End Time with New calculated end time

Asked By: Meredith Hawkins Date: Aug 19, 2008 Category: Sharepoint Views: 951

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.

Tagged:replacing calendar end time with new calculated

10 Answers Found

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

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, 2008

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, 2008

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, 2008

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, 2008

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
durations.

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

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, 2008

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, 2008

check the article hope this signifies solution.
http://akshaya-m.blogspot.com/2009/07/replacing-time-field.html

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

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, 2008

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.