SIGN IN YOUR ACCOUNT TO HAVE ACCESS TO DIFFERENT FEATURES

Login with Google
CREATE AN ACCOUNT FORGOT YOUR PASSWORD?

FORGOT YOUR DETAILS?

AAH, WAIT, I REMEMBER NOW!

CREATE ACCOUNT

ALREADY HAVE AN ACCOUNT?

Login with Google

QUESTIONS? CALL: 865-637-8986
  • SIGN UP
  • LOGIN

SimpleIndex

  • LEARN MORE
    • GENERAL INFO
      • Getting Started
      • How To Scan Documents
      • Barcode Scanning Guide
      • Searching & Viewing
      • News & Updates
      • Schedule a Web Demo
    • FEATURES
      • Streamlined Interface
      • TWAIN and ISIS Scanning
      • Zone OCR and Dynamic OCR
      • Database Integration
      • Required Documents Check
      • Automated Processing & 1-Click Interface
      • SharePoint Document Scanning
    • –
      • Document Classification
      • PDF & MS Office Text Parsing
      • Barcode Recognition
      • Optical Mark Recognition
      • Match Documents to Existing Data
      • Imprinting & Watermarking
      • Screenshot OCR
  • SOLUTIONS
    • General
      • All-In-One Scanning & Sorting Tool
      • Affordable Document Management
      • Instant Integration
      • Network Scanners & Copiers
      • Remote Document Capture
      • Reduce Click Charges for Data Capture
    • Specific
      • Sales Tax Exemption Forms
      • Federal Tax Returns
      • Invoice Processing
      • Material Safety Data Sheets (MSDS)
      • Patent ID and Title Extraction
      • Mortgage & Loan Documents
    • Feature Demos
      • Zone OCR with Template Matching
      • Full-Page OCR & Multi-User Workflow
      • PDF Text Processing
      • Organize Office Documents
      • Integration with RPA Bots
      • Compare with Other Solutions
  • SUITE
    • SimpleCoversheet – Print Bar Codes
    • SimpleExport – Data File Converter
    • SimpleView – Search, View & Edit
    • SimpleQB – QuickBooks Integrator
    • SimpleOCR – Freeware OCR
    • Buy Suite Apps
    • Buy Suite Bundles
  • DOWNLOAD
  • SHOP
    • COMPARE VERSIONS
    • SIMPLEINDEX WORKSTATION
      • Machine License
      • Concurrent User
      • Subscription License
    • SIMPLEINDEX SERVER
    • SUITE APPLICATIONS
    • SUITE BUNDLES
    • MAINTENANCE & RENEWALS
    • FIND A DEALER
      • Dealer Locator
      • Become a Dealer
    • CONTACT SALES
  • SUPPORT
    • WIKI HELP
    • KNOWLEDGE BASE
    • SIMPLEINDEX UNIVERSITY
      • SimpleIndex University – 100 Series
      • SimpleIndex University – 200 Series
      • SimpleIndex University – 300 Series
    • PRIVACY POLICY
    • CONTACT SUPPORT
  • My Account
    • Downloads
  • MY CART
    No products in cart.
  • Home
  • Simple Software Knowledge Base - Article

How do you configure the Autofill feature?

Wednesday, 28 February 2018 by dwilder

The Autofill feature of SimpleIndex is an easy way to associate many index fields with one document without retyping data that already exists in another application.

Autofill uses a database lookup to retrieve records that match a key value or values entered by the user or extracted with SimpleIndex. Blank index fields are then filled in automatically with the data from this lookup. The result is a document database with many different possible search fields, of which only one needed to be entered during scanning.

You can use one, two or three index fields as the key values to extract data from your data source.  These index fields can be any of the various types of manual and automatic fields.  Once the fields are matched the lookup information will get filled in to the Autofill Index fields.

Instructions

  1. Navigate to the Indexing & File Naming step in the Job Options Wizard under the File menu.
  2. Create an Index field(s) in SimpleIndex that will be used for the key matching value(s), which will pull the information from the database.  This Index field can be any Type other than Autofill.
  3. Click the “Autofill Settings…” button on the top right.
  4. Select the “Datasource:” configured in the Database step in the drop down or click the “New Data Source…” button to create a new connection.
  5. Click the Load button, which loads the data from the database.
  6. Select the Table or View that the data is in in the “Table or View:” drop down.
  7. Select the key field from the database that will be used to match against to pull the other data from the other columns in the selected Table or View from the “Database Key Field 1:” drop down.  If other index fields are required for matching the correct records select these in “Database Key Field 2:” and “Database Key Field 3:”
  8. Select the key index field from SimpleIndex that will be entered or extracted and used to match against the database in the “Index Key Field 1:” drop down.  If other index fields are required for matching the correct records select these in the “Index Key Field 2:” and “Index Key Field 2:”, making sure that the correct SimpleIndex fields are linked to the correct database columns.
  9. Click Finish
  10. Create new Autofill index fields for each piece of additional data needed to be filled in based on the key field(s).  The Template for each of the Autofill index fields should be the exact name of the column from the data source that should be filled.

By checking the “Allow manual input in Autofill fields” the users can edit the filled data manually.  By checking “Automatically select first matching record” it will select the first record in the table that matches instead of asking which record should be used, when multiple records in the data source have the same data.  By checking “Match on single Key Field” it will match on just one of the key fields, instead of requiring all key fields be match, when multiple key matching fields are used.  By checking “Cascading List Mode” each autofill field is displayed as a drop down list populated by the records that match the key field(s) and each selection filters the next list for matching values.

Related Links

  • SimpleIndex.com – Automatic Indexing Using Existing Data
  • SimpleIndex.com – Invoice Processing with Full Page OCR
  • SimpleIndex Wiki – Autofill
  • SimpleIndex Wiki – Cascading List Mode
  • SimpleIndex Wiki – Data Source
  • SimpleIndex Wiki – Access
  • SimpleIndex Wiki – SQL
  • SimpleIndex Wiki – ODBC
DatabaseDatabase AutofillDocument AutomationDocument RetrievalMS AccessMySQLODBCOracleServer OCRSQL ServerWorkflow
Read more
  • Published in Database & Retrieval, Indexing & UI
No Comments

Search

Contact Us Today!

=

Search Knowledge Base

Recent KB Articles

  • Database Export Error
  • SimpleIndex Not Autorunning Jobs
  • Prompt Before Appending with Identical Filename
  • Error in Program Load: 481 - Invalid Picture
  • Order of Import
  • How do I purchase, register and activate Simple Software products?
  • What are SimpleIndex Specifications?
  • License Activation Issues

Feature Cloud

Metadata ISIS Driver Full Text Indexing Office PDF Document Indexing Document Capture Solution Image Scanning Command Line Interface ODBC Document Automation Fast Scanning Remote Capture MS Access Search PDF Archive Scanning Software Barcode Recognition Software Scanned Document Indexing Document Numbering System Unattended Processing Text Processing Personal Document Management PaperVision Barcode Printing Automatic Data Capture Document Retrieval 1-Click Processing Barcode OCR PDF417 Document Classification Command-Line SimpleCoversheet Barcode Reading Software Workflow Software SimpleView Patch Code QuickBooks Online PDF Data Extraction Software Microsoft Word Data Extraction TIFF PDF Annotations SimpleSend RPA OMR PDF Barcode Recognition OCR Form Processing Bar Code Scanning Paperless Office

Online Support Options

Check our Wiki Help, Knowledge Base and Training Videos, or Contact Support if you still need Help

How to Buy

Solutions start at just $500! Buy SimpleIndex online or from an Authorized Dealer in your area.

Authorized Dealers

Authorized DealersSimpleIndex is a great addition to any system integrator's product line. Become an Authorized Dealer.

Get a Web Demo

Get a free online demo with a scanning specialist who can configure SimpleIndex on your computer remotely.
Sign up for a demo now!

Download a Trial

SimpleIndex Trial30-day trial downloads are available for all Simple Software applications.
Download Now!

SimpleIndex Applications

SimpleIndex Applications Packaged apps built with SimpleIndex.
SimpleInvoice for AP
Sales Tax Manager
Mortgage LoanStacker
MSDS and Patents
SimpleIndex

© 2022 Meta Enterprises, LLC | Knoxville, Tennessee | A Family Owned Company
© 2022 SimpleSoftware | Consulting Services in the Field of Software as a Service

TOP
Manage Cookie Consent
We use cookies to optimize our website and our service.
Functional cookies Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
View preferences
{title} {title} {title}
});