Create a custom Approval workflow using SharePoint Designer

Create a custom Approval workflow using SharePoint Designer

!!! Happy Friendship Day !!!!

This workflow is useful for 3 levels of approval required to filing form. Only form is visible when 3 levels approval completed.If any one Reject the form then Mail Sent to Created by user that your list entry is rejected for some reason.

Below some basic steps to creating approval workflow.

Step 1: It starts when a new item is created, modified or user can start workflow manually also.



Step 2: Created Workflow variable. Below Workflow variable description.

• TQM 25 Approval ID: This variable holds the ID of the task used to collect data from the approver.
• Approval: This variable holds the value of the “Approval” field in the task used to approve or reject the request.
• Comments: This variable holds the value of the “Comments” field in the task used to approve or reject the request.
• Collect: Task List Item ID Created for Task List.




Step 3: For First level Approval Task user is fill form on submission mail will go to person mentioned in field “Your Excellence Enabler”. Task is assigned to person whose name is mentioned in Your Excellence Enabler field. No condition is checked for Assigning task.

Actions Steps:

• Create a new approval task to be completed by the approver. This is implemented as “Collect Data from a User”. Task Id store in local workflow variable.

• Set workflow variable value whether user approved or Reject item. [ Refer Step 4 ]

• Same way store user comments on local workflow variable. [ Refer Step 5 ]



Step 4: Set Workflow Variable value as Approved or Reject.




Step 5: Set workflow variable comments value.





Step 6: So the action that we are going to use is the 'Collect Data From User' action.
1. The data that needs to be collected
2. The user that needs to provide the data, the human resource manager
3. A variable to collect, task ID.
Step 6.1 Click on Collect data new wizard will open




Step 6.2: we need to collect data from user so here we can add Approve / Reject Checkbox and comments multiline textbox.











Step 6.3 Final output of collect data.



Step 7: Once first level task is assigned to “your Excellence Enabler”. Mail Sent to Excellence Enabler to approve and Reject task.




Step 8: if Excellence Enabler Approve Task then Approval Mail sent to Created By and if Reject task then Rejection Mail Sent to Created By.
o On Approved of Excellence Enabler next task is assigned to Champion Approval.

o On Reject workflow is stopped.



Step 9: Same as Step 7



Step 10: Once All Approval completed Entry is display on list.




Once Again Happy Friendship Day Week Month Year Life time
Pritesh Gandhi

	# I like walking in the rain , becoz nobody can see my tears. # The Most Wasted day in life ,is the day ,in which we have not laughed. # Nothing is permenent in this world, not even your troubles... ! -- Charlie Chaplin
From Pritesh Public Profile

Reference URL :

http://www.u2u.info/Blogs/Kevin/Lists/Posts/Post.aspx?ID=39

http://cycogeek.fiesta25.com/blogs/cycogeek/page/Create-Custom-Approval-Workflow-with-SharePoint-Designer.aspx

How to know which User Submitted Survey and Which user does not?

How to know which User Submitted Survey and Which user does not?

Smile ,

This article is useful to know which user submitted complete survey and which user doesnot complete survey.

Just simply put condition on u list query "tp_level = 255" for getting all non-submitted (incomplete) responses. The below query just gives you the result for “ALL NON SUBMITTED (INCOMPLETE) responses”; for getting all submitted responses query will change to “tp_level = 1”.

Query Example

Non Submitted Response
=============================
Select userdata.tp_author,
(Select tp_Title from UserInfo where UserInfo.tp_ID=userdata.tp_author and tp_siteID='SiteID') As UserName
from USERDATA
where tp_ListId like 'LISTID'
and tp_level = 255

FOR Submitted Complete Survey
===================================
Select userdata.tp_author,
(Select tp_Title from UserInfo where UserInfo.tp_ID=userdata.tp_author and tp_siteID='SiteID') As UserName
from USERDATA
where tp_ListId like 'LISTID'
and tp_level = 1

	If you cannot love a person whom you see, Then How can you love GOD whom you have never seen -- Mother Teresa
From Pritesh Public Profile

Implement Bar Chart in Custom Sharepoint List Using Google Charting API

Implement Bar Chart in Custom Sharepoint List Using Google Charting API


Here is the orginal post thatClaudio Cabaleyro did:
http://www.endusersharepoint.com/?p=1539

Screenshot of Bar Chart in Custom Sharepoint List ,



-: Download Zip File From Here :-

Just One Day Remaining to My BirthDay

Cheers
Pritesh Gandhi

	I love everything that's old: old friends, old times, old manners,old books, old wines
From Pritesh Public Profile

Cascading Drop Down List (With Filter) - Custom Field Control

Cascading Drop Down List (With Filter) - Custom Field Control

: Download Code From Codeplex Here :

: Site For Reference :

The excellent SharePoint - Cascading Drop Down Lists provided by DataCogs is a great way to create relationships between fields/columns in SharePoint lists.

DataCogs Solution Page:
http://datacogs.com/datablogs/archive/2007/08/26/641.aspx

This was further enhanced by Patrick Tisseghem to allow a grandchild dropdown. Visit Patrick's Page at:
http://blog.12thwave.com/?p=7

Expanding on Patrick's modified version to allow a grandchild dropdown list, I've added the functionality to filter the items in the dropdown.

Also, the "Required Field" validation was not validated accurately and this has been taken care of in my modified source.

========================================================

Title : Re-Using SharePoint controls
Site URL : http://community.zevenseas.com/Blogs/Robin/archive/2009/07/03/re-using-sharepoint-controls.aspx
Desc : This post is going to be a summary of some of some the SharePoint controls I regularly use in my solutions. Cool thing about re-using the controls that are already out there is, that saves time in re-inventing the wheel and you don’t have to worry about keeping the look&feel consistent ;)

Cheers
Pritesh Gandhi
NIGHT IS LONGER FOR THOSE WHO DREAM...........
AND DAY IS LONGER FOR THOSE WHO MAKE THEIR DREAMS COME TRUE!!!!!!!!!

How to Get DataBase Name,Database Owner and Database size in a single Query ...

How to Get DataBase Name,Database Owner and Database size in a single Query ...

Nice Solution is Here

SELECT
A.NAME,
STR(CAST(SUM(SIZE) AS NUMERIC)*8192/1048576) AS 'DATA FILE(S) SIZE IN MB',
FLOOR(B.BACKUP_SIZE/1048576) AS 'BACKUP SIZE IN MB',
convert(sysname,DatabasePropertyEx(a.name,'Recovery')) as 'Recovery Mode'
,suser_sname(a.sid) as 'dbowner'
FROM (SELECT
MAX(BACKUP_START_DATE) AS BACKUP_START_DATE,
DATABASE_NAME
FROM MSDB..BACKUPSET
WHERE TYPE = 'D'
GROUP BY DATABASE_NAME) X
INNER JOIN MSDB..BACKUPSET B ON X.DATABASE_NAME = B.DATABASE_NAME
AND B.BACKUP_START_DATE = X.BACKUP_START_DATE
RIGHT OUTER JOIN MASTER..SYSDATABASES A ON A.NAME = B.DATABASE_NAME
INNER JOIN MASTER..SYSALTFILES C ON A.DBID = C.DBID
AND GROUPID != 0
WHERE A.DBID > 4
GROUP BY
A.NAME,
B.BACKUP_SIZE,
a.sid
ORDER BY A.NAME

	When your Dream turn to Dust, It's time to vacunm
From Pritesh Public Profile

Find Name of USER in Moss 2007 UserDatabase Table

How to find Name of user in Moss 2007 Userdatabase Table ?

Solutions is Here :

Select
(Select tp_Title As UserName from UserInfo where UserInfo.tp_ID=UserData. and tp_siteID='Site ID Add Here') As UserName
From UserData
Where tp_ListId like 'List ID of List'

Example

Select
(Select tp_Title from UserInfo where UserInfo.tp_ID=UserData.int10 and tp_siteID='00BAC987-FR94-000A-8760-9H316C1F3974') As UserName
From UserData
Where tp_ListId like '000efcc7-9092-4346-11a5-ae521425ffba'

Cheers
Pritesh Gandhi

	When you are waiting for the bus and someone asks, "Has the bus come yet?". If the bus came would I be standing here?
From Pritesh Public Profile

Reduce Lenghth of Multiple Line Of Text Box and Loadtip of Display Form

Reduce Lenghth of Multiple Line Of Text Box and Loadtip of Display Form

Hi ,

Download Webpart : Download Webpart

First Screenshot is display how to reduce multiple line text box character to display better view to end user.



Download Webpart Page :Reduce Length of Multiple Line TextBox

For More Details Use Below URL :

http://www.endusersharepoint.com/?p=1751

Second Good Article with using jQuery and loadTip :

Here is a great solution that Paul Grenier put together with JQuery. With this solution you get a popup for any issue, task or custom list. This does not work with link lists.

You will get a pop up when you mouse over the title of the list item. It will show all metadata for that item. What a wonderful solution so that you do not have to click on the issue to see all the details.

Orginal Post of Paul Garniar is Here : http://www.endusersharepoint.com/?p=1333

Download ASPX Page of LoadTip



References URL

http://www.endusersharepoint.com/?p=1223

http://www.bitsofsharepoint.com/ExamplePoint/Site/LoadTipBeyond.aspx

Cheers :

	Ugliness is better than beauty. It lasts longer and in the end, gravity will get us all.
From Pritesh Public Profile