ChadSmiley Blog

The goal of Edit Document Fields it to provide a universal way of editing fields without knowing anything about a database.  Yes, there are other applications that have more robust features (FieldControl or ChangeFieldValue) but they require additional databases or additional design elements in each database.  This tool will continue to be a toolbar application (if it can be called an application), using Lotus Formula language and will always be free!  

Version 6.0.0 (Notes/Domino 6): Blog Post Download Code

1. Added the following new data type/actions:

• Trim
• Trim then Unique
• Added history to prompts.  All prompts that where edits are now edit combo a history of ten values will be kept.  Use 'cFieldHistoryValues' to set the amount of history to keep.
• Added prompt before updating documents to confirm what is going to happen.  Set 'cEnableConfirmation' constant to @False to disable this feature.  This information will always be printed to the status bar.
• All constants start with c, some can be customized as noted.
• Improved error message when validating the entered formula.
• Improved error message when executing the operation on a document.
• Added ability to continue executing the operation on all remaining documents even if an error occurs.  Each time an error occurs there is an option to stop execution.  The the failed document NoteID(s) will be shown again at the end and written to the status bar.

Version 5.1.1 (Notes/Domino 6): Blog Post Download Code

1. Added the following new data type/actions:

• Left
• LeftBack
• Right
• RightBack
• Corrected issue with semicolons in values or formulas.

Version 5.1.0 (Notes/Domino 6): Blog Post Download Code

1. Added some more *smarts* when selecting categories with documents the categories are not included at all.

Version 5.0.1 (Notes/Domino 6): Blog Post Download Code

1. Validated formula data type before updating documents
2. update the prompting for which field to edit to include ability to add new fields

Version 5.0.0 (Notes/Domino 6): Blog Post Download Code

1. Use profile document to store the last field edited per form
2. Use profile document to store the last data type and formula for each field
3. Added new data type of Formula, thanks Lefty Tsamis for the work and idea
4. Added new data type of Password Convert, Password is now Password Set
5. Switched from UNID to NoteID to allow 500 documents to be updated
6. Two pass - gathers the documents before any documents are updated, eliminates updated documents twice and ensures all documents are processed
7. Use of Eval function instead of checking the datatype for every document, thanks Lefty Tsamis again

Version 4.1.0 (Notes/Domino 6): Blog Post Download Code

1. New data type/actions:

• + Append Values - Appends new values to a field.
• Sort Ascending - Any type of list.
• Sort Descending - Any type of list.
• Replace - with the ability to update multiple fields at once.
• Replace Substring - with the ability to update multiple fields at once.
• Unique - Removes all duplicate elements in a list.
• Implode - Prompts for sperator and converts a list to text.
• Explode - Prompts for sperators and converts text to a list.
• Thank you to Lefty Tsamis for the ability to updated mulitple documents with the same value. Updated to gather the documents' UNID are first and then are updated using the UNID. This removes the problem of documents moving and trying to updated a document twice.
• Lefty Tsamis also added the ability to check the data type of the field for the selected document and have that be the default type instead of always being text.
• Thank you to Vladislav Gorbunov (Creator of FieldControl) for adding the use of the Notes.ini to store the last field that was edited.
• Vladislav Gorbunov also added the + Append Values data function.
• Added addtional checks so fields are not set to errors.
• Added Status Bar notification of what happened.
• Sorted the data types to find them easier.
• Added confirmation of update for more than one document

Version 4.0.0 (Notes/Domino 6): Download Code
Never Released

Version 3.0 (Notes/Domino 6): LDD Sandbox Post Download Code

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 (Notes/Domino 5): Download Code

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 (Notes/Domino 5): Download Code

1. Added new data type of Upper Case, Lower Case, and Poper Case

Version 2.0 (Notes/Domino 5): Download Code

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 multi value support for base data types

Version 1.0 (Notes/Domino 5):

1. Data Types

• Text
• Date
• Integer
• Name
• Remove Field
• Common Name

Permalink | Comments (0) | TrackBacks (0) | Category Edit Document Fields