How Oh Saratoga! Is Tracked
The OA Tour of Oh Saratoga!
1
There is an Enable OA forum on Vintage Computer.  Bravo!
Registration is free and easy. Join us.


  



 We start with a user-customized menu for the Oh Saratoga!Go Ahead! Click on Oh Saratoga! Spreadsheet event. This menu has been called from a  master polyglot  menu. Look   
it is set to open a Spreadsheet named Oh Saratoga!.  That's because we begin with a check or cash submitted as a registration fee. To bypass a worksheet  we would instead select    Registration   
Go ahead,  click Oh Saratoga! on the right.


The Oh Saratoga! Worksheet
There! You have opened  the   
  Big Oh!  worksheet.

When You Select  INCOME, the explanatory line  becomes the input line:   Enter Three Letters » »
On this SS, we want to find the person submitting the money 
Francis G. McCloskey.

Therefore  fgm will be entered as a search string.

Go ahead, Click Income and see if we find him. Then follow the sequence.







There he is, click and.....
well first understand a database definition has been stored on the SS.

The selected name here is going to be passed within the Spreadsheet to its db.name field along with the selected name's unique identifier primary key. Both will be loaded into a user-defined menu which in turn is going to open a database window and read the client record of Francis G. McCloskey.


Now CLICK HERE to Select Francis G. McCloskey and the first of several customized menus will pop.









The Worksheet is visible in the background of this custom menu.

A macro has passed the name and key identifier [not visible in this view] from the worksheet to the menu.

A successor menu will open a database report window and copy the db definition and data from the Spreadsheet into the db window for detailed processing. Let's select 100 dollars.



Upon hitting Enter a follow-up menu asks for check number.


We'll leave it at its default    Cash   


Click on the menu.












User is offered an opportunity to assign the income to a category.


By typing R, the 100.00 will be assigned to Registration.


If the income has to be split among categories, navigate via the cursor.


Here we shall press R for REGISTRATION . . .



And. . .

 the 100.00 gets applied to   REGISTRATION 


The Program Asks How Many in the Party?

Followed by a mouseable Response Box: A sophisticated thank you or acknowledgement letter is a major output goal of this script. It is designed to be a receipt for payment, a personal greeting, and  a newsletter [full of site reports] rolled into one. But the reports have to be assembled one after the other and appended according to location and date customized for this recipient, so that for those who donate regularly, there are no repeats.

Let's see if Enable OA can make it happen.


A  YES  in the Response Box launches a sized memo window [the memo field is defined in the REGISTER table].

The personal part of the letter is typed here and is stored temporarily in the recipient's memo field. The letter can have optional boilerplate, at the opening and closing.

Note the Shift/F10 prompt to call the menu when finished.






Ooops, I made a mistake. In the window to the right I say a locally defined memo field. 

Not!

The locally defined memo fields will show in a minute. This memo field with its sized window is not locally defined. It's in the REGISTER table.  Click For The Menu to close this window and continue to build the letter.









Click

on

Close Window

in

the

Menu.














This menu gives you the choice of drawing opening boilerplate from several areas.














Read what I wrote while executing this window.



Then Click The Window to Move On.

























Click the Window Another Time [and then back to manual scroll]










  


   Now comes the final output, the thank-you letter to the registrant. OA pops open the letter in a Mozilla composer window. See how there is appended to the end of the personal part of the letter all the field reports which the recipient has not previously received. [OA has already generated the shell with four randomly generated colors. These shells can be seen in the letter. They are also used to email and store each report. The colors continually change. I'll show this process at a future time. The report from the field is pasted into the shell and re-saved as a html file. The beauty of OA is that it can read and process html files... or any ASCII file.

OA then opens and reads the saved html report in the shell which OA created for it, extracts the tracking data and re-outputs it as an html file with a concatenated filename of its city location and date integer. At the beginning of each month OA automatically finds and lists all 3 month old html files in its table, creates a Winzip archive with the current month as the name and writes each old file into the compressed Winzip archive before deleting them from the database and hard drive. It sends a parameter-rich command to Winzip]. Now here is the final letter ready for printing. OA sends the assembled parameters to Mozilla Composer and up pops this window.


Meanwhile, in the OA window the application continues.

  We Answer  YES  [Mouse Over for some tooltips... as you scroll].


























Thank You For Hanging In This Long With This Hastily Assembled Tutorial. There is a Contact Us Option on the Scrolling Menu. 

To Join the circle and learn more about OA click here.