Airline Tickets

Airline Tickets

Master Tag
Catalog
Created
Feb 5, 2023 02:06 AM
Usage
Not
empty
Add
dateBetween
Format
formateDate
Web Tags
Database
Planning
Relation
Formula
Alternatives
Cover
For those looking for an easy way to manage their travel information, this Notion template for airline tickets can provide a great solution. This template is designed to help users keep track of airline tickets and associated information. It includes sections for collecting and organizing information like flight number, departure and arrival times, airline, layovers, layover wait time, bag price, total cost, confirmation numbers, and more.
For those looking for an easy way to manage their travel information, this Notion template for airline tickets can provide a great solution. This template is designed to help users keep track of airline tickets and associated information. It includes sections for collecting and organizing information like flight number, departure and arrival times, airline, layovers, layover wait time, bag price, total cost, confirmation numbers, and more.
Airline Tickets
Airline Tickets
 
Formulas
if(not empty(prop("Return Flight")), prop("Price") + prop("Bag Price") + prop("Return Bag Price"), toNumber(""))
Total Price
if(not empty(prop("Landing into (LO1)")) and not empty(prop("Departing from (LO1)")), format(dateBetween(prop("Departing from (LO1)"), prop("Landing into (LO1)"), "hours")) + " hrs " + format(dateBetween(prop("Departing from (LO1)"), prop("Landing into (LO1)"), "minutes") % 60) + " min", "")
Layover 1 Wait Time
if(not empty(prop("Landing into (LO2)")) and not empty(prop("Departing from (LO2)")), format(dateBetween(prop("Departing from (LO2)"), prop("Landing into (LO2)"), "hours")) + " hrs " + format(dateBetween(prop("Departing from (LO2)"), prop("Landing into (LO2)"), "minutes") % 60) + " min", "")
Layover 2 Wait Time
formatDate(prop("Take-off"), "LT")
Time