Empty Cart

Fields and Tables to Excel Wizard

fields-and-tables-to-excel-wizard-new-tile-side-view3-500
fields-and-tables-to-excel-wizard-new-tile-side-view3-500fieldsandtablesscreenshot
Fields and Tables to Excel Wizard This standalone Act! addon executable opens Excel, and creates a separate spreadsheet for every table (entity) within an Act! database. Tables included are; Contact, Group, Company, Activity, Notes, Histories, Opportunity and Secondary Contact. Each spreadsheet li ...Read more
$19.99 each
Act! Compatible Version


  • Description
  • Specifications

Fields and Tables to Excel Wizard

This standalone Act! addon executable opens Excel, and creates a separate spreadsheet for every table (entity) within an Act! database.

Tables included are; Contact, Group, Company, Activity, Notes, Histories, Opportunity and Secondary Contact. Each spreadsheet lists all the fields and the following columns:

  • Display Name -- The name that shows on a layout
  • Table Name -- The internal name of the Act! table
  • Column Name -- The actual internal name of the field
  • Data Type -- Character, date/time, number, annual event, etc.
  • Length -- Size of field
  • Pick List -- Name of drop-down list
  • Is Custom -- Yes/No -- is it a custom field
  • Is Defined -- Yes/No -- is it
  • Is Primary -- Yes/No -- is it a primary field
  • Allow Edit -- Yes/No -- Allow editing
  • Allow Blank -- Yes/No -- Allow blank fields
  • Allow Null -- Yes/No -- Allow null fields
  • Create History -- Yes/No -- Create history when updated
  • Trigger on Focus -- Shows the path if a trigger exists
  • Trigger on Lost Focus -- Shows the path if a trigger exists
  • Trigger on Change -- Shows the path if a trigger exists
  • Default Value -- Shows the default value if present

This extract is helpful if you are working on XML reports or with reporting tools such as Crystal Reports.

 

Note: This wizard is only compatible with the desktop versions of Act! (not Act! Cloud/Web) 

Perpetual
Act! Pro or Premium Desktop v22 and higher

Related products

Results 1 - 3 of 3

Patricia Egen Consulting, LLC

803 Creek Overlook, Chattanooga, TN 37415
Main office: 423-875-2652 • Arizona office: 480-788-7504 • Florida office: 754-300-2827
support@egenconsulting.com