Tags
Author
IsFreshest
Printed On
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, tech, gaming and rare advertisements from famous and not so famous magazines.
© AdRetro.com 2024