Community
Showing results for 
Search instead for 
Do you mean 
Reply

Is There A Way to Find an Empty Field in All Contacts - Without Looking Up Every Field

Accepted Solution Solved
Bronze Super Contributor
Posts: 1,488
Country: USA
Accepted Solution

Is There A Way to Find an Empty Field in All Contacts - Without Looking Up Every Field

Is There A Way to Find an Empty Field in All Contacts - Without Looking Up Every Field?

John Purdy
ACT! Premium V. 20.0.159
HP ENVY 17m, 16GB, & Office 365, 32bit, 1TB HDD.

Accepted Solutions
Highlighted
Solution
Accepted by topic author jnpurdy
‎03-15-2019 07:20 AM
Copper Elite Contributor
Posts: 103
Country: Germany

Re: Is There A Way to Find an Empty Field in All Contacts - Without Looking Up Every Field

You may want to try to export all fields to excel and look for the empty field in excel.

Jan Teske
ACC
jbt consulting

View solution in original post


All Replies
Highlighted
Solution
Accepted by topic author jnpurdy
‎03-15-2019 07:20 AM
Copper Elite Contributor
Posts: 103
Country: Germany

Re: Is There A Way to Find an Empty Field in All Contacts - Without Looking Up Every Field

You may want to try to export all fields to excel and look for the empty field in excel.

Jan Teske
ACC
jbt consulting
Platinum Elite Contributor
Posts: 14,584
Country: Australia

Re: Is There A Way to Find an Empty Field in All Contacts - Without Looking Up Every Field

Bronze Super Contributor
Posts: 1,488
Country: USA

Re: Is There A Way to Find an Empty Field in All Contacts - Without Looking Up Every Field

I was thinking of any field that had never been used and has zero content.

John Purdy
ACT! Premium V. 20.0.159
HP ENVY 17m, 16GB, & Office 365, 32bit, 1TB HDD.
Nickel Super Contributor
Posts: 443
Country: Germany

Re: Is There A Way to Find an Empty Field in All Contacts - Without Looking Up Every Field

ACTDIAG has a report called "Fields usage report" that dumps field usage information into a crude text file.

Not suitable for automatic analysis due to a free text format, but better than nothing....

 

Excerpt:

Act! Field:                             Physical Column:                        Act! Fieldtype:     Physical Type:      Non-Empty: Density:   Max Len:   Min Len:   Avg Len:   Recommendation:         
--------------------------------------  --------------------------------------  ------------------  ------------------  ---------  ---------  ---------  ---------  ---------  ------------------------- 
Anzahl der Arbeitnehmer                 NUMEMPLOYEES                            Number              INT                 6          86%        0          0          0         
Bearbeitungsdatum                       EDITDATE                                Date                DATETIME            7          100%       0          0          0         
Branchen                                INDUSTRY                                Character           NVARCHAR(64)        0          0%         0          0          0         
Branchencode                            SICCODE                                 Character           NVARCHAR(8)         0          0%         0          0          0          Zero column usage. Review need for column.

Andreas Schlesselmann
Melville-Schellmann GbR
Germany
www.melville-schellmann.de