Tuesday, June 08, 2021

Have extra EURO 2020 fun with this Oracle APEX app

For the last 15 years, with every big football tournament (World Cup and Euro Cup), we've launched an Oracle APEX app where you can predict the scores of the games. You can find this year's app at https://euro2020.unitedcodes.com

Features

Many people do a challenge with their friends or company, for fun, for money... Instead of using a custom-made Excel, use of email, or use of paper, you can use the Euro 2020 Challenge site to track who's in the lead.

  • You can enter the scores of every game and see how well your predictions compare to others (overall).
  • You can create a group e.g. your company, or a team, etc and see how well you play within your group.
  • You can see statistics of predictions

History

15 years ago, I built a site to promote the use of Oracle APEX. People loved it, so I decided to update the site with every new release of APEX. You can find some more history and screenshots of how the app looked here. Not that many changes have been done compared to the app from 2018, but this year it runs on Oracle APEX 21.1, so it shows that upgrading APEX apps is smooth.

Oracle APEX features

When upgrading to the new Oracle APEX version, the Advisor and Upgrade assistant were run. Some plug-ins (e.g. select2) got replaced by built-in features (e.g. Inline Pop-up). Most changes were done in the Admin section, where tabular forms were replaced by Interactive Grids, native Forms regions are now being used, and other parts that showed up in the upgrade assistant were applied.

Social authentication was updated, so you can sign-up and log in with Email, Facebook or Google.

Normally with an upgrade, we also update the Universal Theme version, but as it's using a custom theme we didn't do it for this app.

Go and play!

So, now head  to the site/app and start challenging your friends!


Good luck!

3 comments:

  1. Good stuff... but you've spelt Wembley wrong... and it's Eng-ger-land!

    ReplyDelete
  2. Hi, great game.
    I'll enjoy playing it, especially that Macedonia is participant for the first time.

    In order for Macedonian flag to be shown, please correct the class
    from class="flag mk_"
    to class="flag mk"

    BR

    ReplyDelete
  3. Thanks - we changed the flag.

    ReplyDelete