DDH Software, LLC Making a big world smaller

HB Functions

Author:George Sokol [Send Author Email]

January 02, 2020
Description:Wanting a quick way to see the effect of different functions (and what they do) I've created this database including all Handbase functions as well as some examples that could be used across many databases. Included: * Listing of all Handbase functions with x, y, and z inputs to see the various outputs. * Currency conversion function that shows how to take a floating number and then add commas and currency symbols to it. * Dave Haupert's Primary key example. * Some examples for doing date manipulation including how to calculate the day of the week (includes a fix to Dave Haupert's "Weekday" example), day of the year, how to return just the current year, and how to return the current month.
Has Data:Yes
Has Forms:No
Filters:Development, Functions, Date-Time, Date conversion
Sorting:Development Example
Version:HanDBase v.4.x Enhanced or greater
File:hb_calculations.pdb          Downloads: This Month 2115 / Total* 5144
Note:MAC Users will need to enter the filename hb_calculations.pdb when saving this file.
* since October 1, 2000.

Other Titles from George Sokol

04/26/2018 Hangman [Fun]
I've often written a hangman game to both learn and test the limits of a new development platform/system. This was my attempt in HanDBase to understand Conditional and Calculated Field logic as well as to explore the flexibility of forms. While not perfect, I hope you will find this fun and that it may help you in your own development.

01/16/2022 RGB Calculator [Development]
This app is designed for developers and graphic artists that want a quick way to calculate the RGB values for shading or tinting colors in their design. It provides both several pre-set calculations (25%, 50%, 75%) as well as the ability to enter your own percentage factor to create a custom calculation. To use this app: - Follow instructions in readme to install. - Create a new record, labeling it something descriptive such as "Dark Green" or "Background Color for my form" in the Description field. - Enter the R, G, B numbers at the top of the form. - If desired, enter the desired factor in the Factor field. Calculations should be automatic. There is a special feature to copy any of the calculated RGB values - just tap on the color band of the color you wish. Just note that this uses HanDBase's External-Combine Text feature so you should only do this after saving the form - otherwise it will copy the previous result.

01/21/2022 Hawk Projects 1.0 [Business Tools]
This app was built to provide a simpler experience to track small projects. All of the tasks are stored, managed, and captured in a single table - no need to link to a secondary database. Here are some key advantages: - Do everything from one form, one database, no secondary view needed for small projects. - Track both "Due" and Completed" tasks with ease and the associated dates with a click of a button. - Easily track project costs by task and subprojects. - Assign resources by tasks. - Create and track "child" or subprojects and roll up their costs into the Master Project! - Expandable notes form for tracking each project. - Built in Help. This app has a heavy use of forms so while you may be able to use it without them, it is strongly recommended you install "all" forms provided with the app.