Whether you’re a frequent flyer that travels often for work or you fly only twice a year for vacations, why not gain points for each flight? Get rewarded for the trips you’re planning on taking anyway. Once you accumulate enough points, you save money on your flights. The only downside is the amount of time it takes to organize all the point transactions and flights… or at least it used to. Quickly log your flights and your point balance for each airline is automatically calculated with this Frequent Flyer Rewards template. Let’s fly through this template, organized by table:

Airlines

Customers are often loyal to specific airlines. Whether it is due to the perks they receive from the airline or simply because of the service, customers are much more likely to try to book their tickets with airlines they have taken in the past. Each airline has their own point based reward system that allows you to redeem points in exchange for flights. This table contains all airline information including your current point balance with the airline’s rewards system.

Fields

• Name. The airline’s name.
• Logo. The airline’s logo.
• Based out of. The airport the airline is based out of linked to the Airports table.
• Home base city. The city the home airport is Based out of pulled from the Airports table.
• Rating. The airline’s rating on a scale of 1-5.
• Rewards ID. The unique rewards ID associated with the airline. All points are typically tied to this account.
• Point balance. The net point balance calculated based on the number of points redeemed and credited in the Flights table.
• Flights taken. A link to the Flights table to identify the various flights you’ve taken operated by the airline.
• Flight count. The number of flights taken operated by the airline.
• Airports with hubs. A field linked to the Airports table to identify the various airports that contain hubs for the airlines.
• Airport hub count. The number of airport hubs contracted.

Views

• All airlines. Displays all airlines sorted in alphabetical order.
• Highest point balance. Displays airlines that you currently have the highest calculated Point balance sorted by highest balance to lowest
• Most frequently used. Displays airlines that you have taken the most flights with sorted in alphabetical order.
• Highest rated. Displays airlines that have a Rating of 4 or 5 on a scale of 1-5 sorted in alphabetical order.
• Airlines gallery. Displays all airlines in the form of a gallery view sorted in alphabetical order.
• New airline. Displays a form that can be used to add a new airline to the list.

Flights

Points gained or redeemed are usually applied to the account based on the flight. The more distance a flight covers, the higher the reward points typically awarded. Even if you take the same flight but on different days, this table treats each flight and date combo as its own entity, keeping track of your points independently. If you can’t remember which flight you redeemed your rewards points on, easily take a peek at this table.

Fields

• Number and date. An automatic formula that creates a flight Number and flight date for a unique combination.
• Number. The flight’s number.
• Operated by. This field looks to the Airlines table to identify the airline that is operating the flight.
• Date and time. The flight’s date and time of departure.
• Source airport. The airport the flight is leaving from. This field is linked to the Airports table.
• Destination airport. The airport the flight is headed towards. This field is also linked to the Airports table.
• Point transaction status. This single select field denotes whether you have submitted a request to apply the flight points to your rewards account with the airline.
• Points. The number of points rewarded or used for the flight.
• Credited points. This field displays a green check mark if you were credited the points for the flight and a red x if you have not yet received points or if you redeemed points for the flight.

Views

• All flights. Displays all flights sorted in chronological order of Date and time.
• Current year. Displays all flights that have a Date and time in the current year sorted by earliest to latest flight.
• Redeemed points. Displays flights where rewards points were redeemed sorted by earliest flight date to latest flight date.
• Credited points. Displays flights that had points credited sorted by earliest flight date to latest flight date.
• By point transaction status. Displays all flights stacked by Point transaction status in the form of a kanban view.
• New flight entry. Displays a form used to enter a new flight to the list.

Airports

It’s common for frequent flyers to use the airport name to describe their destination. Many travel booking platforms use the airport code to identify the source and destination airports. This table contains all airport information including the airport code and various flights taken into and out of this airport. Additionally, if you have a preferred airline, easily identify whether the airport you’re headed to contains your favorite airline’s hub!

Fields

• Name. The airport name.
• Code. The airport’s unique 3 letter code.
• Photo. The airport’s photo.
• Flights taken. This field is linked to the Flights table to identify the various flights you have taken form this airport.
• Located in. This field is linked to the Cities table to identify which city the airport is located in.
• Address. The airport’s address.
• Airline hubs. This table looks to the Airlines table to highlight the airlines the airport serves as a hub for.
• Hub count. The number of Airline hubs associated with the airport.
• Flight count. The number of Flights taken out of the airport.

Views

• All airports. Displays all airports sorted in alphabetical order.
• Frequently used. Displays airports that have been used for more than one flight sorted in alphabetical order.
• Airport gallery. Displays all airports in the form of a gallery view sorted in alphabetical order.
• New airport. Displays a form that can be shared to add a new airport to the table.

Cities

This table identifies airports and airline hubs within the airports that reside in the city.

Fields

• Name. The city’s name.
• Airport name. This field looks to the Airports table to display airports located in the city.
• Airline hubs. This field looks to the Airports table to identify the Airline hubs located at airports within the city.

Views

• All cities. Displays all cities sorted in alphabetical order.
• New city. Displays a form used to enter a new city.