type
status
date
slug
summary
tags
category
icon
password
I store English example sentences in a Notion database and sort them randomly for memorization.
Notion doesn't provide a random sorting feature by default, but we can implement it using a small trick.
When You Need Random Sorting in Notion
There can be various reasons why you might need a random sorting feature in Notion:
- When you need to display items randomly from a database
- When you want to fairly distribute work order in team projects
- When you want to shuffle the order of study materials or quiz questions to enhance learning effectiveness
- When you want to randomly select and fairly analyze customer reviews or feedback
Method for Random Sorting
- Create a New 'Random' Property: Add a new property to your database. Set this property type to 'Formula'.
- Enter the Random Value Generation Formula: In the formula field of the newly created property, enter the following formula:
(((((timestamp(prop("Created Time")) * 100011979) + 500067713) % 900066731) * (((timestamp(now()) * 800067089) + 800068411) % 800053967)) + 900067309) % 900066571
- Sort by the Random Property: In the database view, sort by the newly created 'Random' property. This way, the items in the database will be randomly rearranged every time you refresh the page every minute. (This doesn't work within the blog and link)
Example
Feel free to copy and use this database if you need it
Random DB
- Author:501
- URL:https://en.501story.blog/article/random-notion-database
- Copyright:All articles in this blog, except for special statements, adopt BY-NC-SA agreement. Please indicate the source!
Relate Posts
