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.
Collections
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