Nomad Planning Template (Wifi Tribe)

Expand for information on columns (Can be deleted once you are comfortable with columns)

Expand Row button - The box with the two arrows will expand the trip so you can see additional details about the trip. Trip Name - This is just a free text field for the name of your trip. Primary City - This is a selectable list field. Main function of this is that it rolls up into the country list so you can track the main cities you have visited in that country. You can add new options by typing them directly into this field. Country Visited - This is where you can select the country visited from the Countries page. If you want to add/modify the options then that needs to be done from the Countries page. Schengen - This is going to auto populate when you populate the Country Visited column. This is going to driven the Schengen day calculation. If you want to change a countries Schengen zone status you need to do that from the Countries page. Schengen Days Remaining - Once you have got the dates and countries populated you can press the

Refresh Schengen Days

⁠

. This will refresh the Schengen Days page and will populate the remaining days at the end of each future trip that is in the Schengen zone. You will have to push it every time you make changes to get the updated count. Disclaimer - This is in no way a guarantee that you are within your visa but rather a tool to help catch exceptions where you might go over your allowed days. If you are anywhere close I would double check using other online sources. Here is an example of another online calculator

Schengen Calculator⁠

Decision - You have two options, Committed or TBD. This option will enable/disable some buttons as well as affect the Overall Booking Status. Trip Start/End - This is where you will put the start and end of the trip. It will highlight red if there is overlap. Remaining Time - This shows the remaining time of each trip. It will auto generate using the current date. Fill in Travel Gap - This button will look to see if there is a gap below the current trip and give you the option to auto fill in that gap with one trip. If it is the last trip in your list then it will want to auto generate a trip for one month after the end of that last trip. It will be disabled if, the trip is in the past OR there is no gap. Delete Trip - This will allow you to quickly delete a trip but only if the status of the trip is TBD. Overall Booking Status - This is a formula based column. It will put the trip in one of the follow statuses, “Past” - trip is in the past, “Current” - current trip based on dates, “Needs Decision” - Trip is in TBD decision status, “Needs Booked” - either transport or accommodations need booked, “Booked” - everything is fully booked Incoming Transport Status - toggle to mark that you have booked your incoming travel. Accommodation Status - This has multiple options for the status of booking accommodations. The only statuses that are complete are Fully Booked and Free Stay!! Outgoing Transport Status - toggle to mark that you have booked your outgoing travel. **Hidden Columns** Add Schengen Days - This works with the Refresh Schengen Days button to build out the table on the Schengen Days page. Bucket List Items - This shows any items add to the Bucket List page and can be viewable by expanding the row. Row - This is a row counter that mostly has to do with background functionality Total Days - This is used to roll up the total days in a country into the Countries page and any other rollups. Travel Schedule Filter - that is used in the background by the

Active Trips

⁠

Rolling Year

⁠

All Trips

⁠

buttons to filter the trips.

Use this button to clear the below data once you are comfortable with the Coda. I would delete this button as soon as you do that. I would make sure you review all the pages to look at the examples because this is going to clear data on multiple pages.

⁠

Delete Sample Data

⁠