Monthly Archives: February 2008

Solution (sort of): Set Priority on a Task Using SharePoint Designer

I have a business scenario like this:

  • A user uploads a document to a document library.
  • She selects a content type and enters meta data as needed. One of the meta data fields is a flag, "Urgent".
  • This triggers a SharePoint Designer workflow that, among other things, uses the "Collect Data from a User" action.

"Collect Data from a User" creates an item in a task list requesting approval for that document.

I needed to create a view of the task list that showed urgent requests for approval.

Solution: Put the word "URGENT:" into the title of these tasks. 

I would have preferred to specify the priority field directly.  However, I was unable to do that for several reasons:

  1. The collect data action does not provide a mechanism to update any field other than title (and those additional fields for which you want to collect data).
  2. The "assign a to do item" action has the same problem.
  3. It’s possible to insert an item into a list (i.e. insert an item into the task list directly) but this not a blocking action.  That means that the workflow will not wait for the user to complete that task.

I considered a few approaches before (thankfully) realizing we could just put "urgent" in the title.

  1. Start a workflow on the task list itself so that when a new task is created, it somehow cross references back to the document that started the first workflow, pull out the urgent flag value and update priority as needed. 
  2. Do something similar with an event receiver.  On create of the task, locate the associated document and update priority as needed.
  3. Use the "create list item" action in conjunction with the "wait for field change" action and an event receiver.  If we create a list item, we can specify all the fields we want.  Use an event receiver to update the original item when the user completes the task and the "wait for field change" action’s condition would be met and the workflow would proceed.  (For some reason, I had more or less settled on this approach before wisely deciding to walk away for a while).

There is a drawback to my solution (aside from the obvious fact that only the text of the title indicates urgency).  Since "collect feedback" only accepts hard coded title names, I need to use two different collect feedback actions whose only difference is that hard coded title. 

But, at least there’s a solution that does not require event receivers or custom SPD actions.

If someone has solved this in a more clever way, please let me know.

</end>

Sunday Funny: Keeping Your Son On His Toes

One of the many joys I take in being the parent of a ten year old boy is finding new ways to make him laugh or think a little differently about questions and things in the world.  I’ve used these techniques over the years:

===

Misconstrue his questions:

Son: What day is it?

Dad: One day before Wednesday.

S: No, what day of the month is it?

D: Oh, it’s 4 days after Jan 25.

===

Tickle him and tell him you’ll stop when he stops laughing.

===

Go down stairs to the TV room and announce, "It’s good to be the daddy."  Then, pick him up to get the warm spot on the couch and change the channel to something good, like the Scifi channel.

===

Read stories out loud.  Insert ridiculous sentences in the middle of the story.  My favorite is to add "killing him instantly" when the main characters encounters some minor trouble.  For example, "the knife slipped in his hand, cutting his index finger, killing him instantly."  Nothing quite gets your son out of a complacent and passive listening mode as the main character being killed instantly.

===

Read stories incorrectly.  Read sentences backward.  The best part of this is that the first couple of times I did this, my son thought he was helping me out by pointing out that I wasn’t reading the words in the right order.  The down side is that he really doesn’t want me to read to him any more.

===

Go to Burger King for lunch.  My son would eat BK morning, night and day if we let him.  When going, tell him, "I know you hate going there, but we simply have no choice."  When he tries to explain that he loves BK, talk over him and say things like "We don’t have time to argue about it!  We’re going and I don’t want to have a discussion!"

(This reminds me of my favorite Borg joke: "Borger King: We do it our way.  Your way is irrelevant."  hahaha!)

===

Open a book to page 9 and say, "hmm, that’s an odd page".

===

Fill the world with arch enemies.  "We’re going to run quick over toe 7-11, arch-enemy of 11-7".

"Your aunt lives in Ringwood, arch enemy to the town of Squarewood."

===

We drive up to Massachusetts from New Jersey several times a year and it often takes about 5 hours door to door.  As we arrive home and pull into the driveway say, "oh, I forgot, we need to make a quick dash to Home Depot."

===

When watching a violent episode in a TV show (such as Heroes), tell your son, "some times, at work, I need to destroy my enemies by burning them alive using the powers of my mind.  I don’t like doing it, but you gotta do what you gotta do."

===

When watching bad horror movies (see "It’s good to be the Daddy" above), ascribe improbable motives to the evil character.  For instance, tell your son that the reason Jason is so angry  is because he wants some cake and they won’t let him have any.

===

Explain phone numbers incorrectly.  Instead of telling your son to dial "201-111-2222", tell him it’s "2-011-1-12222".

===

What tricks do you use?

</end>

Technorati Tags:

Guest Blogging?

It seems fairly common in the political blogging world for a given blog to host a "guest blogger".  When I’m in political blog land I must be wearing a different pair of eye glasses because it never occurred to me that "guest blogging" might make sense for a technical blog like mine.  That is, until I read this post by Kanwal Khipple over at The Best of SharePoint Buzz- January 2008

Thinking on it, I believe there could be a lot of people out there in SharePoint land that have the itch to put together an article, short or long, technical or more business oriented, etc, but don’t run their own blog for all the usual reasons.  If you’re one of those people, I’d be happy to host it.  You can reach me via email or leave a comment.  I haven’t thought through any kind of guidelines, but I suppose that I’d want it to be oriented around SharePoint, but I also like to throw in some personal observations about consulting now and then.  I’m also trying to publish a "Sunday Funny" every week and I’m bound to run out of ideas for that.

If you’re a regular blogger already but would like to experiment with guest blogging, I’m definitely open to that too, either as a host or a guest 🙂

</end>

Technorati Tags: