This question comes from a reader of the Notion course. It has been organized and shared here. If you encounter similar issues while using Notion, feel free to leave a comment.
Introduction
Content displayed in a Notion database must always be sorted according to a specific logic, which makes it impossible to achieve "random browsing." However, with Notion Formula, you can indirectly achieve this random browsing effect.
How the Formula Works
- Use the page's "Created Time," the "current time," and several large constants to perform calculations, producing a pseudo-random number.
- Have the database sort by these random numbers.
- Since the "current time" is constantly changing, the pseudo-random number changes every time you refresh the page.
- The sort order changes with each page refresh, achieving the effect of random browsing.
If you want to use this random sorting to build a random quotes display, check out the complete guide in another article.
How to Use
- Create a Formula property in your database.
- Copy and paste the formula below into the Formula property.
- Sort the database by this Formula property.
- Use the shortcut Ctrl+R to refresh the current page (allow at least 1 minute between refreshes).
Formula Code
mod(mod(timestamp(Created Time) * 1.00011979e+8 + 5.00067713e+8, 9.00066731e+8) * mod(timestamp(now()) * 8.00067089e+8 + 8.00068411e+8, 8.00053967e+8) + 9.00067309e+8, 9.00066571e+8)📘 FLO.W — Notion Personal Management System
FLO.W is a Notion-based personal management template that integrates tasks, notes, projects, habits, and more, complete with comprehensive tutorials.
Ready-to-use Notion template system
Complete tutorials included, beginner-friendly
Continuously updated and maintained
Learn About FLO.W Template✨ 1531+ users chose FLO.W
