I am using Daily Notes to keep track of my past trips. With the new Bases view type Maps, I wanted to display them on a map. I thought it would be nice to use colors to visually separate the most recent trips.
For this, I added a formula to the base, which I then pass to Maps in the view type settings. The formula calculates an RGB color based on how many days ago a trip happened:
"RGB("
+ ((255 - 127 * ((now() - date(file.name)).days / (now() - date(file("2025-10-09").name)).days)).round()).toString()
+ ", "
+ ((0 + 128 * ((now() - date(file.name)).days / (now() - date(file("2025-10-09").name)).days)).round()).toString()
+ ", "
+ ((255 - 127 * ((now() - date(file.name)).days / (now() - date(file("2025-10-09").name)).days)).round()).toString()
+ ")"
This was just a first idea to experiment with this new view type. I haven’t yet figured out a better way to access the oldest of my trips to set as a maximum for the calculation. I would appreciate any ideas to improve this.