How to delete fields that aren't on a form?

Hi all,

I have a list of fields that somehow appear on a Form ( I can see that when running Teamstudio Delta). But if you at the form in Designer none of the fields are there… How can I get rid of those fields and see them nowhere anymore.

Thank’s in advance

Michel

Subject: How to delete fields that aren’t on a form?

These field definitions can come from more than one possible sources.

  1. If the field name is all caps ie “MYFIELDNAME” then they were created by an agent and there is no field on the form by that name. This may or may not be an error. Lots of times I will have an agent create a field that I then use as a flag information used in a computation by the form. You need to be careful in deleting these as they may be perfectly valid.

  2. if the field definition is not all caps then it may well have been a field on a form at sometime and it has subsequently been removed. These will hang around so long as there are documents in that have the field in them. Again these may or may not extraneous.

To clean up fields that are no longer referenced on a form or in a document you need to make a new copy of the database File/Application/New Copy and copy the design and the documents. If fields persist that you think are unnecessary then you can create a view with a selection formula of @ISAvailable(“MYFIELD”) if you are sure that the field is in fact no longer necessary then an agent that calls

FIELD fieldName := @DeleteField

BUT be very very careful you can cause irreparable harm!

Subject: How to delete fields that aren’t on a form?

First you can use @DeleteField or @Unavailable to get rid of the fields in the documents.Then you shoud look where these fields are created, there must bee an agent or some kinde of code that creates these fields.