One of the missing features in Notion (which this site is built on) is the ability to limit database views to 1 or 4 items. You can currently only limit to 10 items. This is a problem because in many places on the site I want to show “Latest Item” or “Latest 4 Items”. There is a workaround however and it makes use of an indirect stats table, lookups and formulas. The basic structure is this:
- Create a unique auto incrementing identifier on the target table
- Create a Stats database that will have one row that houses summary stats about the target database
- Rollup the max identifier into the stats table, we’ll call this MaxId
- Create a formula on stats that converts the max identifier to a number (this is necessary because you can’t rollup the rollup again back into the target table)
- Rollup the new max ID number into the target database
- If target database Id = MaxId then it is the latest
You can do this for latest 2, 3, 4, 5 or any number by calculating the MaxId - LIMIT
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