World Cup in Business Central: predictions and results ⚽🥅
A World Cup prediction extension for Business Central that lets users share forecasts, track matches imported from a JSON source, register predictions, and compete on a leaderboard with automatic scoring based on exact scores or correct outcomes.
post Gerardo Rentería Blog
"The extension setup allows the source URL to be configured."
Key points
- Extension imports World Cup matches from public JSON sources and displays date, time, round, group, teams, stadium, and results
- Users enter predictions for each match and earn points automatically: 3 for exact score, 1 for correct outcome
- Leaderboard ranks users by total points and tracks exact hits and correct outcomes across all predictions
- Role Center widget visualizes World Cup matches and results; setup page configures the external data source URL
- Solution includes tables for matches and predictions, pages for calendar and forecasts, codeunits for import and scoring logic, and control add-in for visual display
Quotes
- “The extension setup allows the source URL to be configured.” (Shows how the solution provides flexibility for connecting to different external data sources)
- “The scoring logic is simple: 3 points for an exact score prediction. 1 point for predicting the correct match outcome.” (Explains the core gamification mechanism that motivates user engagement)
- “The leaderboard brings all predictions together into a general ranking that makes it easy to see who is leading.” (Describes how the extension creates social competition and user engagement through visible rankings)
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
- table “GDRGWCMatch”
- page “GDRGWCMatchList”
- table “GDRGWCPrediction”
- page “GDRGWCPredictionList”
- codeunit “GDRGWCPredictionMgt”
- table “GDRGWCLeaderboard”
- page “GDRGWCLeaderboard”
- table “GDRGWCSetup”
- page “GDRGWCSetup”
- codeunit “GDRGWCImport”
- page “GDRGWorldCupScoresPart”
- other “GDRGWorldCupScoresViewer.ControlAddIn”
Not found in BC28-30: table “GDRGWCMatch”, page “GDRGWCMatchList”, table “GDRGWCPrediction”, page “GDRGWCPredictionList”, codeunit “GDRGWCPredictionMgt”, table “GDRGWCLeaderboard”, page “GDRGWCLeaderboard”, table “GDRGWCSetup”, page “GDRGWCSetup”, codeunit “GDRGWCImport”, page “GDRGWorldCupScoresPart”.
Context
- Features: Match import from external JSON, User predictions per match, Automatic point calculation, Leaderboard ranking, Match filtering and refresh, Role Center widget, External data source configuration, Competitive scoring system
Source: Gerardo Renteria, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.