Is there a way to progamatically count the number of fields in a database?
My boss would like for me to report this information on a few databases.
Subject: Number of Fields in a database?
I wonder, what important management information he attempts to draw from that.
After all, what is his concept of a field? An item stored in a document? A field for users to enter data? What about computed or computed-for-display fields? It all depends.
Documents can have (and usually do have) more items than there might be fields on any form, that is potentially used to modify the document. The NotesDocument object has a property Items. Loop through all documents in a database, retrieve the Items array, add it to an array of all item names (and make it unique) and finally count the elements in that array.
On the other hand, the NotesForm object has a property called Fields, which could be used in a similar approach to collect all fields on forms (instead of items in documnts).
Subject: Number of Fields in a database?
Use db.GetFields(False) which will give you all the field names in the Database.
GetFields is an undocumented Database property.
Subject: RE: Number of Fields in a database?
So is @Command([CalendarFormat] ; “5” ), but unless you know of a probblem it creates why not use it?
Subject: Number of Fields in a database?
Use Doc.Fields to get the count
Subject: Number of Fields in a database?
Thank you for your help, it worked!