Quick Data Entry

Quick Data Entry is an optional FormTrap component. Each QDE form defines the prompts, edits and logic to collect fields from an independent keying session on any network computer or detached computer, including notebook and pad computers. Fields are collected in FormTrap XML format, allowing direct input back into FormTrap forms. As is customary, the QDE program is fully integrated so you can test new forms and print them during development. Once the QDE form is complete, it is "built" and is then available from any PC to collect data and print forms, with the XML file also available to update your main DB.



This document is a series of tutorials to present gradually increasing levels of complexity using documents that should be useful to your business. The estimated times to complete each section are included, please tell us how long it takes you, we will then be able to update these estimates.

If you have forms you are prepared to contribute to the forms available that would be appreciated.

Send your contributed forms and any comments or constructive suggestion to support@formtrap.com, and please remember to document in Document Comments, as shown at the right.

Envelope (5 minutes)

We'll start with an envelope, printing the address and who from (in the top left corner).


Press New to open a new document.

This is the resulting window:

  • Name: key Envelope
  • Input: select QDE - Quick Data Entry
  • Data file: leave blank
  • Layout: select Base page only and press OK to finish

Activate bottom left Document tab and double click SECOND line (master area) to open master area properties.

All FormTrap QDEs have a master record, some may have additional details (Invoice for example), we'll cover those later.



Go to the bottom and press Add ... to add a field. This is the result and you can now define the first data field:


  • Name: key in the name of this field, whatever you like.
  • Prompt: is what the users sees in Data Entry, occasionally you may want a different (usually simpler) prompt.
  • Type: select Text (long). This is long text where Formatting will line-break long lines.
  • Hint: is optional and are instructions to the person keying the field. Key something so we can see this later in Data Entry. We're finished, so say OK to this window and the next. One field now appears under master, we'll run with this for the moment.

Select Form from the top of the area . From the left-top Page area, select Size as DL (or whatever envelope you use) and click the Orientation button to Size's right for Landscape. You should see an envelope-sized empty image in the main screen.

Select Toolbox from below the left-hand column, then select Long text. Drag and drop it where you want the LAST line of address, the screen should end up as shown.



Do the following to the Long text object on screen:

  • Press Mouse Right and select 12-point and whatever font you want to see.
  • Drag the object out to size by pulling the right-hand handle until it is close to the right end of the envelope (maximum length of the text object).
  • Replace Long text with Address here or similar so you know what the field is (this doesn't matter for this very sparse form but does when forms get busier).
  •                              
  • Highlight the text, then right click and select Link to (left, above).
  • A window opens, select Master and Name and address (middle above).
  • Finally press the Vertical Alignment button and select Bottom (right above).


OK, we're ready to test the form via QDE.

Select Data and Test to open QDE.

Select Envelope and press Next .

Hover over the question to see the hint. Hints are help for the QDE user and can be as large as required.

Key in the Name and address. Press , then press to see the result.

Congratulations, that's your first QDE form completed.

Top

Lookups (Sent From Company)

We'll put "sent from" as a lookup object at top-left. Lookups are integral to FormTrap, and you will re-use this many times in all kinds of forms. 

Still on the Data screen choose New (Field) and answer as below:


  • Name: is Sent from
  • Type: select Drop down editable
  • Values: collects drop down list choices. Enter as shown, each on a new line, with (other - key over this) as the final choice.  See later for handling multiple companies' envelopes.
  • Hint is very important as the user WILL need instructions on what to select.  Key something like what is shown.

    Press OK to finish.

Select master (top line) and double click to open Properties.

Select Formula tab and press Add ... and select Concatenated text field (text) from the two choices on offer.



Answer as shown:

  • Name: is Our Address
  • Concatenate: key Our Address.
  • Substitution: select Substitute from lookup table, then press OK.

Let me explain. The result of Concatenate is Our Address. This key is searched in the lookup table, and when matched, the value is substituted. Rather than read about Lookup Table now, follow what is below to set up Our Address in the lookup table:

  • Open Lookup Table Editor from the FormTrap group.
  • File, Open the file lookup.xml (a small file is provided) and select Add New Item.
  • Add as shown (exact spelling required for Our Address), then File and Save, go back to FTForm Plus.

        


Select Form , Toolbox and drag and drop Long text to the top left corner, then do the following to it:

  • Press Mouse Right and select 8-point and whatever font you want.
  • Pull the end of the field to the right until it is long enough (roughly 1/3rd of envelope width).
  • Replace Long text with KeyedLooked-up or similar so you know what both fields are (one for keyed, the other the lookup value).
  • Highlight Looked-up text, then right click and select Link to , master and Our Address.  This will "source" from the lookup.

  • Highlight Keyed text, then right click and select Link to , master and Sent from.  This will "source" from the keyed information.
  • File, Save to save the lookup file with the new entry.

Repeat Data, Test and see the finished envelope. What you will have is BOTH "Sent Froms" shown - obviously NOT what we want.  If you do not see the Lookup Table entry check the above, you probably miss-spelt either the our address Formula or the Lookup Table key. Note that you can view the XML file and save it (do so for re-use).

Top

Rules (conditional printing)

We'll put rules on the two "sent froms" so we print just the one, depending on what we selected. This is quite common in FormTrap forms and allows alternate presentations.




Start by highlighting just Lookup-up (NOT the blue highlight, you must highlight the text itself).

Once it is highlighted, select Rule (this icon ) and select Add… from the Rule window, then answer as shown.

This tests the answer to the drop-down being Our Address, which is what we have to look up).



Now highlight Keyed and enter the reverse Rule (ie with Apply NOT to result of matching ticked. 

Now we print the keyed value.


 

Finish by selecting Data, Test and key one of each type,  viewing the results.

Top

Complex Letter

We're going to view complex letters, then show how little is keyed in the corresponding QDE, then finally explain what the form design looks like.

Look at the set of letters here:




Select the QDE shortcut,








Select Letter (last in the list) then .

This opens the Master screen (this document has a Master - where top-of-page items are collected, then a choice of detail records that form paragraphs, then a standard trailing record that provides the letter end). Follow this and we'll explain later.










  • Select (invoice) Julian Marque ... from the first choice list.











  • Select any of the Answered by Initials.














  • Select Debtor 1st letter from the final choice list.
  • Press

Debtor 1st letter record screen shows and collects these:









  • Loan Type - select one
  • Due Payment Date is keyed as dd/mm/yyyy.
  • Instalment Amount is keyed without the dollar sign, no commas and you may leave out cents.
  • Payment Reference
  • Select End of Letter


  • Press

Press , when the screen with the choice pops up, select that to see the letter.


You can see the effect of Debtors 2nd letter and Debtors 3rd letter by pressing until the Master question Next Record shows, then select the other Debtors letters, answer the prompts and view those other forms.


We'll finish with the Change of Address, so press until you're back at the first page and answer the last few questions as shown.


The Paragraph record has short-hand paragraph selections, then offers (at Next Record) the opportunity to select additional paragraphs.

Select Address Change and finish by selecting End of Letter, or , then .

As you can see, this one form is capable of answering most if not all of the queries and administration your organization requires, and at incredible speed. Let's now take the hood off and see what is underneath in the Form Design.

Top

Letter Form Design

Load QDE Forms. If you cannot see

then go to the end of the line and select Active Files to see the full list of files,

, then select Letter (form).






Layout at bottom left shows the individual layouts. Double clicking or by selecting a layer shows this to indicate the active layer which shows in the main display.
Position and appearance is implemented by pressing at the top of layout.

The letter starts with a Report Header. The our company items are linked to Formula (Concatenated text type) which call in Lookups to substitute for the text you see on the form. our company formula and lookups are widely used in most forms, and are changed once only to IMMEDIATELY apply to all forms.

January 1st, 2016 we were able to change our company name and address with ONE set of lookup changes, for ALL forms.



The logo is handled the same way, with the screen shot showing the link name Our Logo.bmp. You can use your logo (you'll need .bmp format) by copying it over Our Logo.bmp in the substitutions folder. If your organization requires additional address lines (being in the UK for example), you would need to move the Tel: section down.



Press HERE to see the our xxx Lookup Table entries we use which include bank accounts, address variations between local and overseas documents, direct deposit information etc.




Report Header is defined like this, where Floating height ticked resets vertical space to what is required, with a 1/10 inch (30/300) Gap after.

This block is sourced from either Lookups (see next section to see the lookups for Short Name customers) or from the fields that follow Short Name.

The Header includes this text, omitted on most letters:

Remove empty lines via this icon . This removes lines with no data (and if not selected, vertical space size remains exactly Height).

Looking at Address, the fields are either Title, Initials, Last Name and Address or the single field Lookup Address, which is looked-up based on Short Name. Both the Address and Salutation use Rules to control what is printed, please ask Support@FormTrap.com if you require further details.

To experiment with the Salutation, please omit Short Name and fill in the other replacement fields.

Top

Lists and Lookups

This is the our xxx section of the lookup table and contains entries used in other forms (such as our swift code for Telegraphic Transfer from overseas). These are fixed lookups (there is no data in the names).



You can convert these to include data (where you run more than one company) by adding data to the end, see this entry for an example:

  our address-aardvaark




These are sender-type-iii lookups.



These add the selected Answered by Initials to the end to form the full key, however partial entries without the key are included and used to select "defaults" where the prompt is unanswered.



The files that provide choices for prompts may be EXTERNAL simple .txt files, named with the field name for general use over different forms, or named with field-form name for use in one form only. Changes and edits therefore require no change to the form, with these files names in the Substitutions folder providing choice lists for this form:

Top

Business Forms

We use QDE forms every day in the office. Our invoices, PO's Quotes and other documents produce good looking PDFs that are emailed out and archived, with just the totals transcribed to our Accounting System. These are some of the other documents in the suite with their main attributes, and you are welcome to experiment with them. You can change them to YOUR business very easily by changing the our xxx Lookup Entries and the Our Logo.bmp file to replace with your logo.

Use QDE to look at the data files and to look at PDF documents:

  • Manual Invoice allows payment in various currencies, with payment by Australian Electronic Funds Transfer or international Telegraphic Transfer.

    View a complete USA invoice with everything HERE and an Australian Invoice that uses short name HERE. All calculations are automatic, as shown below.

    Press to view the data entry files saved for these forms and use to see what is keyed (which is surprisingly little.

    • Value No Qty collects description and amount
    • Value With Qty collects description, unit quantity, price per unit and unit description, then calculates amount
    • Time x Rate collects description, time in hours and minutes and rate per hour and calculates amount
    • Support collects support months, supported value (leave unkeyed to drop in the total so far) and support percentage and calculates amount. For other than 12 months, also calculates and shows the annual amount.
    • Support Period collects a start of month and end of month dates
    • Discount collects description, discount %, discount on amount (leave unkeyed to drop in the total so far) and calculates amount
    • Comment collects comments
    • ENDS does end of document calculations

  • Credit is a negative version of the Invoice, in a different color. See the form HERE and view the data file via and to see what is keyed. Credit does not have the expansive features of Debit as we use very few of them.

  • Quote presents a full quotation and allows either an added-up quote or, when the quote includes options, presents a quote without total.

    View a long quotation without total here HERE and a short, with total quotation HERE.

    Press to view the data entry files saved for these forms and use to see what is keyed (again, surprisingly little).

    Quote also includes a lot of manual calculation embedded in the form, with these as the detail record types:

    • Value No Qty collects description and amount
    • Value With Qty collects description, units and price per unit and calculates amount
    • Time x Rate collects description, time in hour and minutes and rate per hour and calculates amount
    • Support collects support months, supported value (leave unkeyed to drop in the total so far) and support percentage and calculates amount
    • Support Period collects a start of month and end of month dates
    • Discount collects description, discount %, discount on amount (leave unkeyed to drop in the total so far) and calculates amount
    • Comment collects comments
    • ENDS does end of document calculations, if called for by the Master field Print total of Quote

  • Pro-Forma is used mainly for support renewals, for existing customers.

    View a Pro-Forma HERE.

    Press to view the data entry file for this forms and use to see what is keyed (again, surprisingly little), using much the same detail lines.

  • Purchase Order we order mainly from just two suppliers, connected with our Optical Mark Reading business (fill in the bubble forms - like census).

    View two Purchase Orders HERE and HERE. These and the data files illustrate how we use lookups to fill most of the form.

    Press to view the data entry file for this forms and use to see what is keyed.

    • TEK purchase order has lookups for the supplier and for Deliver To - we have a Melbourne one-man office which is responsible for most of our external POs.
    • Scantron also uses two delivery points. We could run the product names from lookups, but with so few orders, it is not worth while.

Top