LotteryPool™ iPad app

Official link to my certification on Oracle University – Oracle APEX Cloud Developer Certified Professional (OCI)

I developed the LotteryPool™ iPad app on my MacBook in my spare time for use at workplaces - LEGALLY - with the following features:

NOTE: Scroll down for the screenshots...

• CROSS-PLATFORM: The same app runs on iOS, Windows and Mac - without any changes.

• UNIVERSAL: Works on Tablets, Smartphones and Computers (iPad, iPhone, Laptop, Desktop, etc).

  • Supports multiple lotteries and groups/pools. 

  • Designed with a re-usable members list - members are added only once for the app. The same list is re-used across various lottery pools to selectively add members to - no need to create members for each lottery pool or enter their names, email addresses, etc redundantly. Remember, tablets are not meant for content creation or data entry. Once you create members, all you have to do to use this app is just tap, tap and tap...

  • You can store photos of each member using the same iPad for quick identification and showcase.

  • Color-coded columns based on data and system settings such as current date for visual cues.

  • Tickets: You could take pictures of the purchased lottery tickets using the same iPad and attach them to the pool/group to some of the 16 media container columns by tapping on them. If you shoot one picuture by placing 4 tickets of 10 entries each together, you could accommodate up to 640 tickets in these 16 containers. That's a large group - if you ask me :) If you have fewer than 16 tickets, you could just snap one image per slip. These containers also accept PDF, Word, audio, video, signature, etc. These lottery images are sent out as attachments for proof in email notifications to the members of the group before the draw happens.

  • The optional Entries tabpage has controls to accept Bar-Codes (merchant-specific) for the current lottery pool and Entry/lottery numbers (customer-specific) for each bar-code:

    • Bar-Codes: You can scan a ticket's bar-code by tapping the Scan button which opens the iPad's Camera. Simply focus the ticket's bar-code into the Camera and it populates the current row's Bar-Code column with the actual bar-code value. Bar-Codes can also be entered manually.

    • Entries: You could enter hyphen/space-separated entry numbers into the Entries list for each bar-code. If a ticket has 10 entries, you would enter 10 rows into this list against the ticket's bar-code.

    • Eg: 11-22-33-44-55-6.

  • Charts tabpage is a dashboard of MIS (Management Information Systems) Graphs for the current lottery pool records - for data visualization (big picture).

  • Several global MIS Graph Reports that display data from the entire database - for analytical insights.

  • The Website tabpage has 4 sub-tabpages that display the Homepage of the corresponding lottery agency (PowerBall, Mega Millions, etc with auto-sense with prize, draw date, winning number history, etc), Winning Numbers, Winning Number History and Winners' Stories pages.

  • The Help tabpage has 4 sub-tabpages for Help, Website (displays this webpage), License and About.

  • Actions popover menu for each row in Members List on Lottery Pool layout.

  • Slider popover menu in the Footer of all screens with menu items to go to all the screens - just swipe-n-tap.

  • Member Balances to track pre-payments and over-due payments (between Administrator and Member) along with a Positive/Negative Bar Graph report for it. This report includes only members with non-zero balances (credit/debit) to reduce clutter.

  • Paid By column for each Member of a pool to track payment coverage (between 2 Members or Member/Admin).

  • Email notifications of the OFFICIAL CONTRACT along with attachments of purchased lottery ticket images to all the paid group members with valid email address. Email Recipients, Subject line, Body content, etc are all composed dynamically by 100% based on the data in lottery pool members records - no need to enter a character - just tap the Send button. Paid members, Contribution, Price & Last Winnings values are used in composing additional info in the email stating that the previous week's winnings were also added up to the contributions to buy the current week's tickets. The Admin info is used to compose signature (name/phone) in the body. Generating this 100% automated official contract with one tap is the most important task of this app.

  • A 100% iPad-independent and tablet-optimized app to easily manage lottery pools all on iPad from anywhere without needing to use a PC or other tools.

SAMPLE CONTRACT EMAIL NOTIFICATION

Here is a sample contract email auto-generated by the app - by simply tapping a button - clearly stating the participants, amount paid/collected, number of tickets purchased along with proof of ticket images that will be sent out as a notification before the draw (these precautions cover most of the legalities of an office lottery pool). As you can see, it is generated dynamically by 100% from the data. The lines in red are added dynamically only if Last Winnings column has some value in it. The same goes for the email signature which uses values from the Member record of the Admin column:

From:    <Administrator of the current lottery pool>

To:        <All Paid members of the current lottery pool with valid Email addresses>

Cc:        <Administrator of the current lottery pool>

Subject: [LotteryPool™] Contract - PowerBall - 1/20/2014 - 300 million jackpot - 200 million lump sum

Hi all -

If you’re on this contract, you’re part of the lottery pool for the entries below:

Paid Members: 14

Contribution Per Head: $2

Collection: $28

Prior Winnings: $12

Total Amount: $40

Price Per Ticket: $2 (we rolled in the $12 winnings from our prior draw)

Total Entries Purchased: 20

Draw Date: 1/20/2014

Jackpot: 300 million (approx)

Jackpot Per Head: 21.429 million (approx)

Lump sum: 200 million (approx)

Lump sum Per Head: 14.286 million (approx)

I've attached the ticket image(s) to this email:

<Lottery Ticket Images>

Check it out - http://www.powerball.com

Good luck!

--

<Administrator name>
Lottery Pool Administrator
<Administrator phone>

Sent from my iPad mini

Learn Lottery Pool Rules...

NOTE: Scroll down for the screenshots...

Do post a comment on how you liked it...

Also, take a look at my MATRIX dB Explorer® tool...

HOME – APEXpert.us

My Certifications & Portfolio pages

An elegant Data / REST Flow Diagram I created.

PowerBuilder Compilers – Deployment Breakdown Structure

An Executive Dashboard in Power BI

Check out my elegant Screenshots

And my favorite Apps & Games

My music – MobileMusic.us

LotteryPool™ iPad app SCREENSHOTS

The main Lottery Pool layout which is a master-detail form of Lottery, Lottery Ticket images, Lottery Ticket Barcodes, Lottery Ticket Barcode Entries, Members in Lottery Pool, Lottery Pool Charts, Lottery Website and Help:

Global re-usable Member dropdown (reused on Member, Paid By, Admin, etc columns):

Tapping Scan button opens the Camera app to scan the barcode of the lottery tickets:

Popover menu with actions for each Member in Lottery Pool list row:

 Data-type specific keyboards (Alphanumeric, Numeric, Email, Calendar, etc):

  Lottery layout in full screen with color-coded columns without the Members in Lottery Pool list. This is the same form you find on the top of Lottery Pool screen but in full screen glory:

in [  ] days - column turns gray if more than 2 days, orange if 2 days, red if 1 or less days

Graph reports for each Lottery Pool group data:

View, Replace, Export, Delete options for the existing container data:

Website of the current Lottery. For PowerBall, PBxxx, Mega Millions, MMxxx names there is no need to enter the Website column - it senses automagically. For other names, need to enter Website column: 

 Slider menu in the footer with options to all the layouts (forms, reports) in the app:

Attach anything into the container fields (Camera, Camera Roll, Audio, Signature, Photos, Music, Files, etc). The Help tab has Help, My Website (THIS webpage on this website), License terms and About Lottery Pool sub tabs:

Member layout to add/edit members. This data is reusable across all Lottery Pools and needs to be entered just once:

Members in Lottery Pool in full screen mode. This is the same list data you find on the bottom of Lottery Pool screen:

We can edit or move a Bar code into another Lottery Pool on this layout:

We can edit Bar Code entries and move entries across Bar Codes on this layout:

LotteryPool™ app on iPhone (small-screen glory):