A wide range of tools and additional features reside behind the <Power Tools> button on the IDB screen.
Pressing it reveals at screen bottom a collection of edting tools and other resources:
Here is a brief explanation of what each button controls:
| • | Alphabetize entries: Some users who wish to create an Input Form Mask want the variables displayed in alphabetical order. Use this button to achieve that result. |
The feature can be used to quickly detect spelling errors in your source documents involving similarly named variables. Let's say you have typed what you intended to be the same variable, but used a slightly different 'spelling' of the variable at various locations in the document. (E.g., [ClientName], [Client Name], and [Client_Name].) You can quickly determine whether all variables are properly 'spelled' by scanning the document and 'Alphabetizing' the results. Using Power Tool button 'Go to 1st instance of Selected Variable.,' you can quickly locate the 'offending' variable(s) and make the appropriate corrections.
| • | Should you even need to access the actual source record (not recommended), click the 'Manually Edit IDB source file.' |
| • | Likewise, should you ever want to look at (for editing, or just edification) all of the Instant Database records, click 'Open Folder.' |
| • | If you want the variables to 'jump out' on the screen, click 'Highlight' to paint each variable in yellow. The highlighting is 'on-screen' only. It does not print. |
| • | 'Go to 1st instance of selected variable' is self-explanatory. Just make sure that the cursor is on the proper field. |
| • | Clicking 'Create DropDown List' will place all variables in the left side of the Instant Database screen into a drop down list in the toolbar area of the Word screen. With this list, you can point-and-click those variables into a document under construction. Speed up the creation of source documents, and avoids spelling errors during the placement of variables. You can refresh this list as you add new (different) variables to your document. See IDB Drop Down List for more on this topic. |
| • | You can Print a List of all variables in the current Input Form Mask. The list created is actually a Word document which can easily be made into a client or customer intake sheet. Or use it in any fashion that an 'electronic' version of the variable data in 'list format' might suggest to you. |
| • | You can Export the current display of variables (and values, if provided) to an Excel spreadsheet. You can edit the data there. The result will be immediately usable by Pathagoras for Word. |
| • | Pathagoras provides a simple calculator for your use. Press the red calculator button to activate this feature. The calculator will overlay the IDB screen. The value obtained using the calculator can be inserted into the last selected 'value' box with a single click. |
| • | Click the 'AutoScan' checkbox to tell Pathagoras to automatically scan the document for [bracketed variables] whenever the IDB screen is called up. |
| • | The stand alone boxes toward the center of the Power Tools strip allow you to manually edit the Instant Database display. You would use this feature if you were creating (or editing) an Input Form Mask. You can move rows, insert blank rows and delete existing one. |
| • | You can Import or Export IDB records to share with external users or external programs. |
| • | If the Instant Database screen is not wide enough to show the full name of the variables, or you wish to show more variables than the default '10' you can widen the screen or make it taller by clicking the appropriate Page Size buttons. |
| • | If you prefer to use characters other than the default '[ and ']' (square brackets), change them here. You can use any combination of one or two characters except '<<' and '>>'. |
Page url:
http://www.pathagoras.com/help/index.html?power_tools.htm
