A problem I wanted to solve was to be able to order the ads within an issue so that I could sort them by the order in which they appeared in the magazine.
I did not want to have to manually type in the order every time so I wanted a way to have a Notion formula calculate the order.
The way this works is with the following
- Define a relation column “Previous Item” - For each item in the database you need to link its previous item. This is the only thing you have to do each time, the rest is handled by a series of formula fields.
- Define a field “Is First” that is checked for whichever item in the database is the first item
- Define a field “Order” that is a formula
- if(prop("Is First Ad In Issue") == true, 1, toNumber(first(prop("Previous Ad Order"))) + 1)
- Create a rollup field “Previous Item Order” which pulls in the order from the previous item.
A catalog and collection of vintage, quirky, gay, fashion, tech, gaming and retro advertisements from famous and not so famous magazines.
Ad Collections
Soda Ads
Alcohol Ads
Car Ads
Gay Ads
Tech Ads
Cigarette Ads
Travel Ads
Fashion Ads
Cosmetic Ads
Pharmaceutical Ads
Food Ads
Appliance Ads
All Vintage Print Ads
By Decade
1930s Ads
1940s Ads
1950s Ads
1960s Ads
1970s Ads
1980s Ads
Publications
Life Magazine Ads
Tune In
Blog
About
X / Twitter
YouTube
© AdRetro.com 2025
Terms and Conditions · Privacy Policy
All original vintage advertising content on AdRetro is considered fair use or is in the public domain; we claim no copyright or trademark to the original artwork, products and brands. If you believe there is a violation you may submit a copyright complaint and we will quickly respond to it. Use of any of the images on adretro.com is prohibited without prior authorization. See our Terms and Conditions