A simple, two-column table can be a very useful Input Form. These tables are easy to create, easy to send to a client, easy to complete, and easy to process.

   To create the form, simply draw a two column table in a Word document. Type into the left column the variables you want to gather from the client. (Brackets are optional. If you choose to omit the brackets to make it 'friendlier' for your clients, Pathagoras will add back the brackets when scanning the completed Input Form.) Leave the right column blank. E.g.

 

[Client Name]


[Client Address]


[Client City, ST ZIP]


[Spouse Name]


[Child@1 Name]


   (You can copy and paste the above table into a Word document if you wish to use it as a starter sample.)

   Save the table as a Word document.

   If you want the client to complete the form, email it to him or her with a request to complete the data in the right column. If an office staffer is charged with completing the form, the staffer would simply recall the form and fill in the data at the right from the client's hand written intake sheet.

   The only drawback to the above form is its looks. The form looks boxy and, if you intend the client or customer to complete the form, it is not very professional looking. Further, the variable names that appear at the left may not be friendly or descriptive enough for the end user to know without assistance what is being requested. But if appearances are a secondary concern (or you plan to use the form for 'in-house' data collection only), nothing beats the simplicity of a two-column table.

lightbulbsmallNOTE: You can mail the form as an attachment to a email, or simply as the body of the email. (Make sure you select HTML or Rich Text as the email format. If you send in 'plain text,' the table will be lost.)

   When completed and returned by the client/customer in a reply email, just copy the table and paste it into a Word document.

   Scraping the data:

   When the form is complete, tell Pathagoras to create the records following these steps:

Press <Alt-D> to call up the Instant Database form.

Press the red Power Tools button

Click the  'Import' button and select 'Import data from two-column on-screen form'.

The Instant Database screen will populate with the variable names and associated values. Continue in the normal manner to save the record.

Don't forget: some clients are not good spellers. They don't always accurately remember dates. You still need to double-check behind the informant.