![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
I'm trying to create a custom task form that includes a field for an
importance rank (1,2,3, etc) and a second field that calculates a priority score based on the number of days until the due date multiplied by the importance sco ([Due Date] - [Today's Date])*[Importance Rank]. How do I do this? And how do I then publish the form so that it is my default tasks form? Thanks SHC |
Ads |
#2
|
|||
|
|||
![]()
Sounds like you've already figured out the formula, except that today's date is returned by the intrinsic Date() function.
Publishing is a matter of using Tools | Forms | Publish and setting the default form for your Tasks folder. See http://www.outlookcode.com/d/newdefaultform.htm -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "SHC" wrote in message s.com... I'm trying to create a custom task form that includes a field for an importance rank (1,2,3, etc) and a second field that calculates a priority score based on the number of days until the due date multiplied by the importance sco ([Due Date] - [Today's Date])*[Importance Rank]. How do I do this? And how do I then publish the form so that it is my default tasks form? Thanks SHC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error message in custom form when adding a new field | [email protected] | Outlook - Using Forms | 0 | March 1st 07 10:53 AM |
Copying Data form user field to custom field | [email protected] | Outlook - Using Contacts | 1 | September 4th 06 06:32 PM |
problem in adding value to custom field in inbox | Zoom | Outlook and VBA | 1 | May 28th 06 01:40 PM |
Adding User Defined Field to Task Form | Gordon Staley | Outlook - Using Forms | 4 | May 2nd 06 08:24 PM |
Populate Company field from Contact field in custom task form | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 07:37 PM |