IBM®
Skip to main content
    Country/region select      Terms of use
 
 
   
     Home      Products      Services & solutions      Support & downloads      My account     
 
developerWorks
AIX and UNIX
Information Mgmt
Lotus
New to Lotus
Products
How to buy
Downloads
Live demos
Technical library
Training
Support
Forums & community
Events
Rational
Tivoli
WebSphere
Java™ technology
Linux
Open source
SOA and Web services
Web development
XML
My developerWorks
About dW
Submit content
Feedback



developerWorks  >  Lotus  >  Forums & community  >  Lotus Sandbox

Lotus Sandbox

developerWorks
Edit Document Fields 3.0

Sandbox sample submitted by Chad Schelfhout.

Edit document fields without having to create agent
Category:Code Example
Audience:Application Developer
Product:Notes/Domino
Release:All Releases
Platform:All Supported Platforms
Date Posted:12/20/2002
File Size:5,084 bytes

Click here to download

Download Time Estimator
56 KB Modem0 hrs <1 mins
128 KB ISDN0 hrs <1 mins
384 K DSL0 hrs <1 mins
768 K DSL0 hrs <1 mins
T10 hrs <1 mins
T30 hrs <1 mins

Detailed Description:
If you have a need to update data for a document and you always create an agent
then this code is for you! All you need to do is paste this code into a Toolbar
button (SmartIcon). With the new Notes/Domino 6 functions this tool is easier
and smarter.

There are five simple steps to using this code:
1) Select the document to update.
2) Click your toolbar button.
3) Select the field to update.
4) Select the data type or action to be performed
5) Enter a new value.

Limitations:
1) Only perform the operation on one document at a time.
2) Field value is limited to 254 because of the @Prompt limitations.

Enhancements by version:
Version 3.0 (Notes/Domino 6):
1) Use @GetField to determine the data type and weather it is multi value,
which is used to set the default data type. Previous version always selected
Text.
2) Use @GetField instead of Abstract function to get the current value of a
field. This allows better formatting of the value. Because the data type can
be determined a multi value field can be formatted with ; between the values,
which is the format for entering a multi value. The @GetField also gets the
value of field with a data type of Number and Time/Date which can be converted
to text, previous versions using the abstract function would return null.
3) Changed the selecting of a field from a single select list to an editable
combo box. This will allow the creation of new fields. This is possible
because Notes/Domino 6 no longer requires the field be declared before setting
the value, this is a new feature of the @SetField function.
4) Check that a field name is entered/selected using @DoWhile, eliminating the
possibility of a field without a name.
5) Use the new @Sort function to sort and have the default field be the first
field, instead of the field subject.

Version 2.2:
1) Added Database and View Title to the dialog box title and removed from
message prompt. This should make the prompt shorter and cleaner.
2) Added the following new data types: Abbreviate Name, Abbreviate Name Multi
Value, Upper Case Text, Lower Case Text, Proper Case Text, Upper Case Text
Multi Value, Lower Case Text Multi Value, Proper Case Text Multi Value
3) Changed the multi value separator from : to ;,was unable to edit multi value
fields with times.

Version 2.1:
1) Added new data type of Password. This can be used to set the HTTP Password
on person documents in the Domino Directory.
2) Added field name in the dialog box title and prompt. Easier to remember
which field is being updated and that the correct one was selected.


The data types or actions are:
Text
Date
Integer
Password
Name
Common Name
Abbreviate Name
Remove Field
Text Multi Value
Date Multi Value
Integer Multi Value
Name Multi Value
Common Name Multi Value
Abbreviate Name Multi Value
Upper Case Text
Lower Case Text
Proper Case Text
Upper Case Text Multi Value
Lower Case Text Multi Value
Proper Case Text Multi Value

Please let me know of any other improvements that can be made and thanks for
all the feed back so far.




All Sandbox downloads are licensed as-is, unsupported, and non-warranted.

Additional reviews and comments disabled

Reviews
Edit Document Fields 3.0 (Submitted by Chad Schelfhout - 07/16/2001)
comment R5 Version (Submitted by Chad Schelfhout - 01/17/2003)
rating: 2 stars Has this been posted before ? (Submitted by Andy Cope007 - 01/02/2003)
rating: 4 stars Thanks! Great idea. Have been looking for this for a long time. Works perfect. (Submitted by Steffen Petersen - 08/01/2001)
rating: 4 stars Another version of this functionality, but with a full blown UI (Submitted by Jamie Magee - 01/20/2003)
rating: 4 stars How about functionality to add new fields. (Submitted by Slawek Rogulski - 02/13/2003)
comment The R6 version has the ability to add new fields (Submitted by Chad Schelfhout - 02/19/2003)
rating: 5 stars Nice job, but only works on R6 (Submitted by Valdecir Carvalho - 01/14/2003)
rating: 5 stars Slight typo in the doWhile code prevents new fields from being added ... (Submitted by Lefty Tsamis - 10/02/2003)
comment enhancement to allow modification of all selected docs (Submitted by Lefty Tsamis - 01/14/2004)
comment functionality enhancement (ability to APPEND values to field, store last used field name) (Submitted by Vladislav Gorbunov - 03/15/2004)
comment Edit Document Fields 4.1 (Submitted by Chad Schelfhout - 12/06/2004)
comment Permanent Home (Submitted by Chad Schelfhout - 04/18/2005)
rating: 5 stars I love it! Very useful (Submitted by Magne Eggen - 06/21/2005)

Lotus Software

Document options
Print this page
Print view

 Search
Search
Advanced Search

  Sandbox views
By Application Name
By Category
By Product
By Audience
By Date
By Submitter
Conferences

  Resources
developerWorks: Lotus Downloads
alphaWorks Downloads
    About IBM Privacy Contact