Exponenciel - Efficient and affordable Sage ACT! add-ons

You are here: home > products > automatic data entry - from table for act! act22

Automatic DATA ENTRY FROM TABLE

» What's new in this version

Some of your fields work together? Every time you enter a value in FieldA, you need to change several other fields? No need to always re-type the same information! Enter your data once in a table and Automatic Data Entry From Table will automatically fill in the fields for you.

An example

Let's take an example: let's say that your Outside Sales Rep, Inside Sales Rep and Time zone fields are tied to your Territory field. With Automatic Data Entry from Table, you can have these 3 fields be filled in automatically when you fill in the Territory field.

A simple 3-step process

To create an automatic Data Entry scheme:

  1. You choose a Reference Field (in the example given above, that would be the Territory field)
  2. You choose your Target Fields, ie the fields to be updated (here, that would be the Outside Sales Rep, Inside Sales Rep. and Time zone)

  1. You enter your data in a table

That's it!

You may create as many schemes as you want. You may import your table from Excel or a comma delimited file.

Fast and simple

Once the scheme is created, Automatic Data Entry From Table will monitor the Reference field. Whenever its value changes, it will scan for the new value in the first column of the table and if it can match it (the match is not case-sensitive), it will automatically update the target fields.

Fast and simple, isn't it?

What's new in the version for ACT! 2010

  • It now works with opportunity fields.
  • You now have access to online help through the Help>Online help menu.

» The best way to discover this add-on
is to browse its online help

QUICK LINKS

 
   

Across this Web site, ACT! and ACT! Premium might be referred to as ACT! or Sage ACT!. Sage ACT! was the product name from 2010 to 2013.

home | products | support | order now | web design | resellers | contact us | privacy policy
Design by Exponenciel

Exponenciel has been a leading developer of Sage ACT! add-ons, Sage ACT! addons, Sage ACT! plug-ins, Sage ACT! plugins since 2001.
ACT!, ACT! for Workgroup, ACT! for Web, ACT! Pro and ACT! Premium are registered trademarks of Swiftpage.