Manage Learn to apply best practices and optimize your operations.

Remove Obsolete Fields From Design List.

Ever noticed how Notes tends to accumulate obsolete fields in the design list
displayed when editing column, selection, or other fornulas, reducing the
usifulness of the list? Ever wanted to get rid of fields you don't want to use
anymore, but find that after deleting them from your forms they still appear in
the list? This is especially a problem when trying to adapt one of Lotus's
overly complicated templates to fit a real-world solution.

Well here is how to clean house:

To remove unwanted fields from the list in the designer, remove all references
to the field from the database and then compact the database.

You can remove unwanted fields from documents by using the formula:
FIELD fname := @Deletefield.

You also have to remove any references to the unwanted field that may appear in
formulas elsewhere in the database. To find references, use the design synopsis.

Once you compact the database, the unwanted fields will be gone from the list.
If they aren't, it's because they are still being referenced somewhere in the
Mind you, this is a time-consuming process, but if you don't have a tool to do
it for you, it will get the job done.

Dig Deeper on Domino Resources - Part 6

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...