GS-Base Help Index

https://www.citadel5.com

GS-Base 22.4

  1. Introducing GS-Base
  2. Notational Conventions (Numbers, Formulas, Dates)
  3. Creating tables, records and database notes
    1. Creating New Databases
    2. GS-Base Zip Database File Format
    3. Managing Database Fields and Tables
    4. Using Table, Form and Binary Views
    5. Adding Text Notes, Images/Files and Code Snippets Outside of Records
  4. Editing data fields
    1. Editing Field Contents
    2. Entering Unicode Characters
    3. Selecting Fields and Records, Scrolling, Shortcut Keys
    4. Inserting Images/Files vs Inserting Links to Images/Files
    5. Loading Images/Files from Entire Folders
    6. Using the Increment, Decrement and Operations Commands
    7. Inserting Series
    8. Entering Data: Drop-Down Lists
    9. Generating Passwords
    10. Encrypting Field Contents
    11. Default Field Values
    12. Using the Copy With Options Command
  5. Optimizing performance
    1. Improving Performance When Using Large Files
  6. Calculation functions
    1. Calculated Fields and Entering Formulas
    2. "Cross-table" calculation functions
    3. Using makeUnique() and isUnique() Functions
    4. Using objectStats() Functions to Obtain File/Image Data
    5. Using textStats() Functions to Obtain LongText and Code Field Statistics
    6. Using fileStats() Functions to Obtain EXIF Tags and Metadata from Multimedia Files
    7. Inserting Running Totals and Moving Averages

  7. Using Python in GS-Base

    1. Using Python Functions as UDF() Functions
    2. Installing Python and Integrating It with GS-Base
  8. Pivot tables
    1. Using Pivot Tables
    2. Pivot Table Functions
    3. Creating Pivot Table Reports
  9. Finding file duplicates, photo/mp3/mp4 duplicates, listing files and their history of changes
    1. Verifying File (Path) Lists in Tables
    2. Mass-Renaming, Copying and Deleting Files
    3. Searching for Photo/Image/Media File Duplicates in Folders and on Disks
  10. Displaying two tables from the same database and setting up a relation between them
    1. Using Dual Views
    2. Linking Tables in Dual Views by the 1-N Relation
  11. Joining, splitting and merging tables and records
    1. Joining and Splitting (Normalizing) Tables
    2. Merging and Unmerging Records
  12. Spell-checking
    1. Spell-Checking and Adding Hunspell Dictionaries
  13. Formatting: styles, hyperlinks, background images and in-cell charts
    1. Formatting - General Styles
    2. Formatting - Hyperlinks
    3. Formatting - Images
    4. Formatting - Charts
  14. Searching, filtering, sorting
    1. Searching / Filtering Records
    2. Searching / Saving Current Filters As Named Search Keys
    3. Searching - Duplicates
    4. Searching - Unique Field Values
    5. Searching - Quartiles, Mean Values
    6. Searching - Random Records
    7. Searching - Selected Records
    8. Full Text Searches and Replacing
    9. Find-As-You-Type and Find-Similar Searching Options
    10. Sorting
  15. Sending emails and verifying URLs
    1. Sending Email Messages
    2. Verifying URLs Entered in Database Fields
  16. Printing tables, forms, letters and labels, mail-merge
    1. Printing Tables, Forms, Letters and Labels
  17. File-level password protection and encryption
    1. Password Protection and Encryption
  18. Loading, editing and saving files in various file formats
    1. Opening and Saving Text Files
    2. Saving to PDF
    3. Opening and Saving MySQL *.sql Files
    4. Opening and Saving SQLite *.db Files
    5. Opening and Saving HTML Files
    6. Opening and Saving dBase/FoxPro/Clipper Files
    7. Opening and Saving Excel Workbooks
  19. Settings and Recently Used database lists
    1. Modifying Program Settings
    2. Managing the List of Recently-Used Files
  20. Using scripts within GS-Base and COM programming with external tools
    1. JScript / VBScript scripting: Samples
    2. C++ COM Programming: Samples
    3. COM Programming: Methods and Properties
  21. Contacting Technical Support