How to build a random quote generator in Notion II New trick to show only a single database item

[@DumisaniNdubane]

Excellent tutorial. Random number formula worked when replacing slice() by substring() function.

[@mfreihaendig]

Oh yeah, good call! Things changed a bit with the new formulas, glad you were able to figure it out 😇

[@NotionNationUS]

Can confirm! I was struggling to find the new property to change. Huge help! Thanks boss.

[@mathildesarton4148]

Thank you very much!

[@Hypomanicpanic]

Thank you!

[@renatodosanjos3060]

Thanks man, you‘re an angel

[@mfreihaendig]

Third Update: Notion released a new formula language, so we need to build this slightly differently. I've updated the blog post with the new formulas, so you can easily copy them from there 💪🏻 Template is also updated! You can learn more about Notion's new formulas here: kzbin.info/www/bejne/p4aoc3qdYpx_ac0 Second Update: With Notion Buttons just released, you can now also show a different quote whenever you click the button! I've updated the blog post (link in description) with a section on how to do that 💪🏻 Note that it only works once per minute right now due to the way Notion fills out time stamps, so you can't go crazy with your clicking 😅 First Update: If you want to change the random quote not every time you reload the page, but only once a day, you can do so by modifying the now() timestamp to the timestamp for only the day instead of the exact hour and minute (meaning the timestamp and random number will only change every day). To do so, create two helper properties. For the first one, use this formula to get today's date without the specific hour: formatDate(now(), "MM-DD-YYYY") For the second helper property, use this formula to turn it back into a real date and the corresponding timestamp: timestamp(dateAdd(dateAdd(dateAdd(dateSubtract(dateSubtract(dateSubtract(dateSubtract(dateSubtract(now(), year(now()), "years"), month(now()), "months"), date(now()) - 1, "days"), hour(now()), "hours"), minute(now()), "minutes"), toNumber(slice(prop("Day"), 6, 10)), "years"), toNumber(slice(prop("Day"), 0, 2)) - 1, "months"), toNumber(slice(prop("Day"), 3, 5)) - 1, "days")) Use the second property instead of timestamp(now()) throughout the method 💪🏻

[@kamil3210]

Sorry for my bad english, im not a native speaker. I have problem with a second step, when i create new formula and paste the second step formula i get "Property not found: prop(Day)" error, im new in notion so i dont know what to do. Greetings from Poland!

[@crristox]

@@kamil3210 The "prop(Day) error" means that you have to rename the first property -- the first formula he wrote in his comment -- to Day.

[@crristox]

Could you make a video explaining how to link these changes to the previous formulas? I don't know what to do or where to link it or roll it up with.

[@MossadGanistic]

How can I use this to shuffle only 156 cards using only random numbers 1 through 156? Thank you

[@mfreihaendig]

​@@MossadGanistic if you have only 156 entries in your database, this method should work as well no? I'd have to look into this, but my guess is that if you want to instead assign randomly a number from 1 - 156, it would take a ton of calculations to do so and slow down Notion significantly 😅

[@АнастасијаПетревска]

Wow, that tip on how to rollup a rollup was awesome.

[@mfreihaendig]

😍😇

[@user-qn5fz2lo3e]

Great tutorial! Appreciated there being more in-depth explanations -while still being all to follow along. Exactly what I needed!

[@mfreihaendig]

Oh I am excited to hear that! I‘m sometimes a bit worried whether the whole extensive screen share is too much 😅

[@swextr]

This is a great solution! You have taught me a lot about databases in Notion! Thank you very much!

[@mfreihaendig]

Glad to hear this! ☺️

[@JohnMazz]

Awesome! I was able to do something similar to display only the one latest entry in the database, instead of a random one. Now I'd like to display the most recent two and I'm stumped! I'll have to keep noodling on it.

[@mfreihaendig]

Best of luck with that! 😎

[@manulutine4368]

Thank you so much! I was looking for a way to provide my students with random writing prompts. I was easily able to follow your process step by step. 👍

[@mfreihaendig]

Glad to hear this! Thank you so much ☺️ that’s a great use case, love it!

[@antonfilimonov9131]

Thank you very much, I've implemented this in my second brain. You could post this video in the reddit comments. I have seen many posts from people looking to get random qoute from a database.

[@mfreihaendig]

Thanks for the kind words! Yeah that’s a great idea, I‘m keeping an eye out for it. Otherwise, feel free to share it if you see someone who needs help ☺️

[@Nevervar]

Not all heroes wear capes! Thank you for sharing!

[@mfreihaendig]

Thank you ☺️☺️

[@Nevervar]

@@mfreihaendig And especially I love that it's notion native solution, without widgets (which I find frustrating most of the time.) I wonder what will you think of next!

[@kessahmed647]

Superb tutorial, extremely easy to follow, your way of explaination is amazing

[@mfreihaendig]

Really appreciate your kind words, makes my day! 😇

[@Nookchen82]

Please note that that was converted to . The formula works for me again since I replaced slice with substring

[@allenknight2444]

I replaced slice with substring but Im getting error of expects 2 arguments but only 1 was provided

[@mfreihaendig]

How does your whole formula look?

[@mfreihaendig]

Great catch! Gotta refilm this with the new formulas 😇

[@jillmetcalfe1972]

Love it! I've been waiting for this! Now implemented in my new home page :)

[@mfreihaendig]

Awesome! Using it for quotes or something else? ☺️

[@myanimationchannel]

Thank you so much!! What a great solution for decision fatigue 😊

[@mfreihaendig]

Oh true, That’s another fun application!

[@amazbarcea3211]

Thank you so much for this detailed tutorial. It's one of the few that I've seen which shows the reasoning & functionality behind what is being done. I appreciate the effort you've put into explaining everything. I'm hoping you can also give me some advice. I will use the context of your quotes example to explain what I need. When I create a new page, I want a quote to be randomised for that page. However, once a quote is picked, I don't want it to change on that page again. It should be just a 1-time random picker. Can this be done in Notion?

[@mfreihaendig]

In order to do that, you‘d need a third party tool to power some automations - inside Notion alone it won’t be possible unfortunately

[@amazbarcea3211]

@@mfreihaendig thanks so much for the reply! I'm new to Notion, so I wasn't sure if I was just missing something obvious. Thanks!

[@ashmil7264]

This is exactly what I was looking for. Thank you so much for this!

[@mfreihaendig]

Amazing! What will you use it for? ☺️

[@ashmil7264]

@@mfreihaendig I do a lot of reading and needed to note the words I didn't know the meaning of. So I created a page with a vocab table and entered the words , meanings, synonyms and usage. I will use this to pull out random words and show it on my dashboard page to help me learn them one at a time.

[@lebcRegalona]

This Tutorial was so helpful. Thank you so much!

[@mfreihaendig]

Glad you liked it! 😇

[@eyeohmeday5976]

exactly what I was looking for!! thanks so much

[@mfreihaendig]

Awesome, glad you like it! ☺️

[@mechtxofficial]

Thanks this helped a lot, I just have one desperate question that I need answered: How can I make it so that the rotation happens every 12 hours, instead of rotating whenever the page is loaded or re-opened? This would help with another project I'm currently working on which requires a sort of timer-based shuffle concept to it. I would appreciate it a lot if we could work something out. Thanks again.

[@mfreihaendig]

I have a section on the blog post to change it to once every day - you could modify that solution accordingly 💪🏻 matthiasfrank.de/random-numbers-in-notion/

[@Hypomanicpanic]

Fantastic Tutorial, thank you!

[@mfreihaendig]

Thank you! Glad you liked it 😇

[@BlaisZeroni]

Hi, thank you so much for this tutorial! I've used your formula in combination with a button click to refresh (every minute or so it seems), and am grateful to have this solution. Although I wonder if with the new formula 2.0 and being able to do rollups within formula's and even go into other databases, I wonder if maybe this method could be slimmed all the way down? Right now it is taking a full other database and multiple properties to pull off. While it is nice that it can be done at all, it would be even nicer if it could be as clean as possible by using the new formula's. Would this be possible? And if not, why not? I'm trying to learn abut formula's but it has been difficult, so thanks for sharing your knowledge with us :)

[@mfreihaendig]

You can minimise it, but you still need the other database - that’s because Notion is not a spreadsheet which means you cannot access values from other entries unless you relate them. And relating all to one separate entry is a lot easier than relating all to each other 😅 So yeah, the separate database is just a helper for calculations 😎 Those could be simplified indeed though. I’ll see when I get to that 😇

[@BlaisZeroni]

@@mfreihaendig Thanks so much for the explanation, that makes a lot of sense! Now I can stop trying to make it work, haha. I took a close look at your 2.0 explanation and played around with it myself, and managed to trim it down quite a bit! I set it up with the now and random & property from your tutorial, then the randomizer DB and the relation to both. Then I used the formula in my other comment for the randomizer, and this formula in the DB I want to show topX of: if(prop("Randomizer").map(current.prop("Top_X")).contains(prop("Name")), true, false) That will show checkboxes of the topX set in the randomizer DB. I'm really happy with how it turned out, and how adjustable it is for all sorts of uses. Thank you so much for sharing your knowledge and teaching, could not have figured it out without your resources!

[@ertezsssz]

Hey Mattias, the code to create the random number does not work anymore, there is a disclaimer at the bottom of the Random Property that says "we have recently change the type of language used for formulas" I have this error message: "The text argument does not satisfy the slice function. [24,54] Expected token ")". [40.41]"

[@mfreihaendig]

Yes, they changed everything 😅 here‘s my video on that: kzbin.info/www/bejne/p4aoc3qdYpx_ac0 I‘m in the progress of updating everything, will let you know the new formula later ☺️💪🏻

[@ertezsssz]

@@mfreihaendig thanks for your answer !

[@isaacgreen9495]

good solution! REALLY shocking that notion doesn't have a random() function or a way to get rows from databases by index with a function....

[@mfreihaendig]

Yeah that’s really something that would open up a ton of more advanced use cases 😅

[@Uncle_Gromov]

Hello. Thank you for this great work. I require some help with this template. I duplicated this template to my page, deleted already existing quotes by Douglas Adams and added some of my own. Yet every time I open the page there is still one of Douglas Adams' quotes but never my new quotes. What mistake have I made?

[@mfreihaendig]

Hm that’s hard to tell from a distance - have you gone to the main instance of the database and checked which entries are there?

[@Uncle_Gromov]

@@mfreihaendig Thanks again for your quick response.) I already figured it out and now everything works. I guess I was not attentive first. I copied Random Quote Widget from the template and there I had only quotes by Douglas Adams. I duplicated the table with my quotes, changed it to gallery view, set filter and it worked. This view I moved to my page insted of widget.

[@JekaterinaKovarikova]

Hi, thank you so much for the video! From what I seen it is the best way and the most automated. I like that new values are automatically shuffled into the randomizer, and other's suggest more manual workarounds for this. Also, thank you for giving instructions how to make the frequency daily in the article. FYI I used it for daily affirmations generator and also will make a Word of the day later, like learn a new word today kind of thing. But it can be used for so so many things.

[@mfreihaendig]

Oh I am so glad to hear this! And I agree - random numbers are essential to so many cool builds 😅 can’t wait for a native way to do this ☺️

[@GoldenMoonDesign]

I'm so glad you got this to work. It is still unclear to me on how to make a daily quote generator. I downloaded the template and it has so many other properties than what is in the video. It's hard to tell what to change. Although I may have to just try to build it myself with what I'm understanding from the video. If you or @mfreihaendig have any advice or a template, I would appreciate it soooo much.

[@thekid_]

Now that I have followed this exactly, is there a way to take the singular quote and put it on my homepage? That's my main issue atm, I want one random quote showing up on the homepage :)

[@mfreihaendig]

That depends where your homepage is 😅 what website builder are you using? There would be a lot of different ways to achieve that ;)

[@thekid_]

@@mfreihaendig I'm using Notion!

[@thekid_]

@@mfreihaendig I'm using notion! I have the quotes page made, but I don't know how to make a random one show up on my Notion homepage.

[@fespinozacast]

Is this still working? When I apply the last formula `prop("Selected Number") == prop("Random Number")` I never get a `true` value. When I modify the formula to print values, it does print the right values. I try to go out and go in the page and still doesn't work

[@mfreihaendig]

Hm this should still work - to test it, wrap both sides in a format() statement to see whether that solves the issue 💪🏻

[@fespinozacast]

@@mfreihaendig Thanks, that indeed solved the issue

[@wospisu]

Great tutorial! Thank you for sharing.

[@mfreihaendig]

Thank you! Really appreciate this ☺️

[@MarcinHinz]

Unfortunately this template doesn't work. The synced block takes quotes from some external database (I think, because it doesn't show my quotes, only the original ones). When I tried to do my own linked view of database it just doesn't show randomized quotes :(

[@mfreihaendig]

Hmmm usually works 😅 did you duplicate it into your workspace and then swap out the quotes? 🤔

[@MarcinHinz]

@@mfreihaendig I duplicated it and even tried to just edit those draft quotes. The "random quote" view shows the same old versions of quotes. I don't know why. Any clue?

[@mfreihaendig]

@@MarcinHinz Have you created a new linked view elsewhere to test whether that works? If the old quotes still show, that's probably because the synced block bugged and is still pulling from my DB, not yours You can change that by deleting the synced block as a whole and creating your own display with a new linked view of your database 💪🏻

[@MarcinHinz]

@@mfreihaendig Yes it looks like synced block takes info from your database ;) I just have to figure out how to create me view like that because in my case it shows e.g. 3 quotes instead of one ;) Anyway, thanks for help!!!

[@MarcinHinz]

@@mfreihaendig I''ve added all of my quotes through "browse all your quotes" view. Don't know if this can cause problems...

[@sthxne9341]

This is so amazing! Thank you for this amazing video, i have so many ideas for using this🎉

[@mfreihaendig]

Awesome ☺️

[@rindrarajason6398]

Ty very much!! I have a question tho, Sometimes there are multiple quotes that have the same random number and that causes several quotes to appear in the gallery. Is there a way to make sure there is only one quote showing?

[@mfreihaendig]

How many quotes do you have in the database? Might have to adjust the formula to make the numbers even bigger and the likelihood of two having the same smaller 😅 Unfortunately the only way here rn :-/

[@stormed5062]

@@mfreihaendig​​⁠​​⁠ Hi! I'm trying to figure out exactly how the formula works, so I couldn't answer two questions that unfortunately don't have an answer anywhere( 1. Can you explain why you use these numbers in formulas? I mean, for example - 1.00011979e+8. Why this particular number? Why, for example, not 1.00012000e +8? 2. Why do you use %? I know what it means in the context of a formula, but I don't understand why you use it, and not, for example, another multiplication or division

[@stormed5062]

I faced the same problem, but this is a problem that apparently did not exist 2 years ago Notion sometimes began to make the beginning of the ID the same, for example 10774753....oroeg294, 10774753…jehgoso Trying to solve this problem, I saw that the endings of all such IDs are different, so I slightly changed the formula so that it takes the last 8 digits from the ID, and not the first 8 from the ID This is what the new formula looks like: (((((toNumber(substring(replaceAll(id(), "[^0-9]", ""), -8)) * 100011979) + 500067713) % 900066731) * (((timestamp(now()) * 800067089) + 800068411) % 800053967)) + 900067309) % 900066571 This formula is considered more correct also because the correct regular expression is made here. The video author's formula also works, but it is not immune to possible future Notion changes. For example, if Notion decides to use dashes or any other special characters in the ID, the author formula will stop working, because it removes only letters. My formula removes absolutely everything except numbers. I hope my solution helps you!

[@mrcloud1679]

@@stormed5062 thanks man, this issue made me sad

[@raziel4396]

This is awesome thank you! I have a question though, is it possible to connect a button to this so that every time you hit it it would give you a random quote?

[@mfreihaendig]

Oh yes it is! With the latest update, you could use the Button to fill out a “now” property 😍 thanks for the idea, will update the blog post immediately ☺️

[@raziel4396]

@@mfreihaendig Thank you so much!

[@mfreihaendig]

@@raziel4396 It's updated here: matthiasfrank.de/random-numbers-in-notion/

[@Yodaminnesota]

So helpful, thank you. I am going to use this to create an "album of the day" pop-up in my homepage. One question though-- how do you change the refresh rate of the random number? If I want a random number every day, not every second, what do I do?

[@mfreihaendig]

You would need trim the now() timestamp to only the day part, disregarding numbers and seconds - then the random number will only change each day

[@Yodaminnesota]

@@mfreihaendig Alright, I tried my best to do it but I can't figure it out. I was trying to use datesubtract function for hour(now()) and minute(now()), but because there is no second(now()) or milisecond(now()) it still updates every milisecond. Also, is there a maximum size you recommend for this? I have a 2000+ database of albums and all of the lookups and rollups seem to be crashing my notion every time I open the page

[@mfreihaendig]

@@Yodaminnesota Sorry for the delay - try converting the now() timestamp into today's date and then re-converting it into a timestamp afterwards - that should give you a static day-by-day number 😎

[@enoughahnaf1]

Hey! Great tutorial - do you happen to know what Notion counts as a page refresh? Does the original master database need to be refreshed or can it be linked database views as well?

[@mfreihaendig]

Linked views are sufficient 💪🏻 basically anytime you re-open a view of the database or press refresh in your browser

[@enoughahnaf1]

@@mfreihaendig brilliant! Thanks for the prompt reply

[@wave707]

This is exactly what I needed for my dashboard. Thank you :) Also is there any way to not make it show up like a database?

[@mfreihaendig]

Glad to hear that! If you wanna use only Notion, unfortunately no. You would need either an automation or modify css in the browser to change the look :-/

[@dudod1998]

ty very much pretty complicated for such simple feature but if this is what it takes haha

[@mfreihaendig]

Haha unfortunately yes 😅 though I am sure they will at some point release a rand() function or allow us to limit to 1

[@RenZoneNL]

Is there a way to make the gallery entry wider for when you have longer quotes (so the text doesn't stack vertically as often)? And is there a way to remove the "+ New" button on the right side of the gallery? Perhaps through a table view?

[@mfreihaendig]

You only have the built-in three widths that you can choose from under the layout settings The new button can only be removed by locking the page in the desktop app - if you use it in the browser, you can also inject your own css to hide it 💪🏻

[@RenZoneNL]

Thanks for the quick reply!

[@kevinwestbrook]

@@mfreihaendig If I lock the page, I get multiple items displayed rather than just one. Seems bizarre, but I can't imagine what might cause it. I also often get multiple pages as the highest number in the generator database, and currently I am looking at about 8 fields all with the same random number in them. Sometimes it appears to work, but other times it doesn't.

[@kevinwestbrook]

OK, I did some looking around for other formulas and found that those multiple pages always had the same number. As I see now someone else posted, what I found was that they all had the same first 8 numbers in the ID. So I increased the length to 12, which meant that each one ended up different.

[@TriumphantStranger]

Ok I made it, you're a genius, thank you very much! BUT. I have a problem. I used this for a movie database. In this database I have both watched and unwatched movies, obviously the difference is in the "Watched" property, if it's checked or unchecked, and I have 2 different views to see them separately. I wanted this random picker system to work only for the unwatched movies (my watchlist). is there a way to tell the formula to avoid the checked/watched movies? The other solution is to make 2 different database for watched and unwatched movies but just the idea terrifies my, too much work 😅

[@mfreihaendig]

The easiest way would be to wrap the whole formula in an and() statement with the current formula as one argument and then the „watched“ == false as the second statement 💪🏻

[@TriumphantStranger]

@@mfreihaendig nvm I didn't know which formula I had to edit like that and I messed up something, it's all broken 😅 but thanks anyway, I really appreciated your reply!

[@ilyadark]

@@mfreihaendig I tried this with my list but the checkboxes are now all empty My formula: and((format(prop("Biggest number"))==format(prop("Randomseed")), (format(prop("Watched"))==false))

[@BlaisZeroni]

Additionally I was wondering if it would be at all possible to mark the top 3 highest numbers, to show 3 entries?

[@mfreihaendig]

Yeah, though it would require you to add additional formulas into the mix 💪🏻 Basically need to eliminate the highest and then looking for the next highest

[@Nevervar]

This is a bit silly question, but is it possible to have text of the gallery card justified?

[@mfreihaendig]

Unfortunately not and neither can you really format anything else :-/ hopefully in the future!

[@cairparavel3085]

Hey Matthias! Thank you for making this available to us! I was wondering if you know a way to show the quote in a "prettier" format? The best way I guess is galery mode, where you see the quote inside the box but right next to it you get stuck with the empty "new" box. Do you have any good ideas? Thank you again!!

[@mfreihaendig]

I‘m currently working on a video to help with that ☺️ will take a bit longer but should help take care of that! Otherwise, you would need to build a more complex automation to do something similar :-/

[@cairparavel3085]

Wow! That is awesome!! I'm looking forward to your next tutorial!! You are indeed a Notion Ninja!! :) Big Hug!!!

[@mfreihaendig]

@@cairparavel3085 Thanks, really appreciate it!

[@reneereynosa6368]

I found a bit of a workaround for this. Move your database to a different page (I call mine Backend) and put it into a synced block. Lock the Backend page, then copy the synced block and paste it wherever you want.

[@cairparavel3085]

@@reneereynosa6368 Thank you!!! I'll give it a try! :)

[@finja7052]

amazing. thank you so very much. game changer!

[@mfreihaendig]

Excited to hear you like it ☺️ that’s what I do all of this for 💪🏻🎉

[@bernardocampossizenandosil3399]

Thank you so much! This is extremely helpful

[@mfreihaendig]

Really happy to hear this! ☺️

[@ZuljoTheRed]

Thanks so much for this! I'm having a little trouble getting any added quotes to show though. Anything I add in "Add a new Quote" shows up below in "Browse all your Quotes" but none of them are ever selected in the widget. Should I just copy the quotes in the "Browse all your Quotes" section and change them or is thier another workaround?

[@mfreihaendig]

It should be one and the same database - are you using my template or did you build it yourself?

[@shed185]

looking to set limits on this between 1 and 7 and to only get integers, trying to use the round function to get me an integer but struggling to limit it to numbers between 1 and 7 inlcusive :/

[@mfreihaendig]

I don’t think that’s possible, or at least I don’t know enough about math to do this 😅 if you need 7, then you could replicate this whole thing a few more times but that would be a ton of load on your Notion. How come you need 7 and can’t have the 10 Notion would give you by default?

[@GoldenMoonDesign]

At this point I will pay someone to make me a daily quote generator template using this method. The template has lots of properties that I'm trying to match up to the video to try and alter it but it's not clear. Any help I can get would be really appreciated!!

[@mfreihaendig]

Have you downloaded the free template that comes with it? What seems to be the issue? Works right out of the box for me 🤔

[@GoldenMoonDesign]

Thank you for the reply @@mfreihaendig I'm trying to make one that updates only daily. I did download the template but I'm seeing that it gives you a new quote on reload. I tried to read through your blog post and match up the properties to be able to put in the new formula in the right place for daily but I haven't had success. Do you have an out of the box template for daily?

[@maribethwagganer5672]

I tried to put in the formula but it won't let me because it says "invalid left-hand side of assignment operator = (char 123)". I redid the steps but it says the same thing. what am I doing wrong?

[@mfreihaendig]

Looks like you‘re doing something wrong then typing the formula - have you tried copying it from the blog article? This type of error typically shows if you use only one instead of two equal signs (==)

[@Harmonymony]

Super genius, thank you!!!

[@mfreihaendig]

Your welcome ☺️

[@AutumnBradleyORell]

I'm not sure what I'm doing wrong- everything is going great until the last formula for "chosen item"... none of the check boxes get checked. 😥

[@mfreihaendig]

Hmmm have you given it a moment to refresh? Sometimes it takes a second to calculate. Alternatively, download the template and compare it to your solution ☺️

[@pascaleroche4157]

Hi! I actually have a problem when I create a calendar on notion, the first day of the week is a Sunday... it disturbs me and I would like to change it but I don’t know how... does anyone know how to do it? Thanks

[@mfreihaendig]

Sure just open your settings, click on “language and region” and toggle on “start week on Monday” ☺️

[@pascaleroche4157]

@@mfreihaendig thank you so much !!

[@mfreihaendig]

Always!

[@EvelynnMommy]

""" a is not defined. [43,44] z is not defined. [45,46] Invalid character "“". [41,42] """ can somebody explain?

[@EvelynnMommy]

update... I have found somewhere in the internet other formula and it works as well mod(toNumber(substring(replaceAll(id(), "[a-z]", ""), 0, 4))* mod(timestamp(now())/10000, 123456), 123456)

[@Jonbontabas]

This is awesome. Thank you

[@mfreihaendig]

Happy to hear that!

[@SamanthaRounds]

Is there a way to display this without it looking like a database?

[@mfreihaendig]

Unfortunately not right now unless you want to go into a workaround with automations :-/

[@mfreihaendig]

Will add this as a use case to my upcoming course on automations though 💪🏻

[@agathamelissa2632]

it is so helpful!! thank you

[@mfreihaendig]

That’s great to hear! ☺️

[@aaaaaaaaaaaaa420]

Thank you so much for this video! Is there a way to make the randomizer pick for example the 5 biggest numbers, and that way changing it so instead of it showing me 1 random quote, it shows me 5 random quotes? This is so I don´t have to refresh it every time and I will always want the same amount showing, thank you!

[@mfreihaendig]

You can, but it will be a bit complicated 😅 Notion won’t let you pick the five largest, but you can get the largest and the smallest, so that’s 2. Now you’d need to repeat the process with a separate, second randomised database and new properties. That gives you 4. And then the same again for nr 5 😅

[@jennsih]

Wow! Thank you for this inspiration :D

[@mfreihaendig]

Your welcome! Glad you like it ☺️

[@rungolion]

That's awesome! Thanks for this. Can one also use the same principle with different categories? I am trying to create a generator that would pick one random item in each of four different categories. I don't really get how I could do this, but I might be a little tired :)

[@mfreihaendig]

You can but you’d need to set all of this up four times which might slow down Notion considerably 😅

[@rungolion]

@@mfreihaendig Thanks! I'll try that...

[@adhamahmed-b3b]

CAN YOU MAKE IT IN NEW FORMULA ?

[@mfreihaendig]

Will do 💪🏻 blog post is also already updated for it 😎

[@adhamahmed-b3b]

thaaanks@@mfreihaendig

[@galiona1337]

Thanks. But i not find the template Ps. In use my phone

[@mfreihaendig]

Did you enter your email address and receive the welcome email? ☺️

[@willymerdiansyah]

sick as always! lol

[@mfreihaendig]

Haha glad to hear that! 😇

[@juliandesh4665]

Great Video! :)

[@mfreihaendig]

Thanks!

[@pon2pan3]

ขอบคุณครับ

[@soyjonarlopez]

Thanks man :)

[@mfreihaendig]

With pleasure! ☺️

[@thekid_]

Day 100 of asking for your help :)

[@mfreihaendig]

Wait what did you ask a 100 days ago? 😅

[@thekid_]

@@mfreihaendig I'm being silly, but I do truly need your help!

[@thekid_]

@@mfreihaendig I actually asked for help 180 days ago!

[@mfreihaendig]

@@thekid_ haha I was already confused 😅 what do you need help with? 😎

[@thekid_]

@mfreihaendig I followed the tutorial and did everything right using Notion. My question is: is there a way to show the random quote alone on a different page of your Notion that will refresh with every page refresh?

[@frankieS2727]

🤘🤘💡💡🦾🦾

[@mfreihaendig]

😎🔥