Notion offers a variety of tools and properties that help in the management of daily tasks. These tools make the work easier and more organized. One such property in Notion is that of formula. The formula property in Notion helps to generate clickable links that can be clicked once and redirected to the required page.
Today, we will discuss:
- Database in Notion
- Formula in Notion
- Setting up Formula in Notion
- Formula for Google Search
- Formula for Wikipedia
- Formula for Amazon
- Formula for Good Reads
- Conclusion
1. Database in Notion
Database in Notion keeps your work organized and easy to acquire when needed. Therefore, Notion offers a simple way to create a user database. The steps depicted below show how to create a database in Notion.
Step 1: Create a Page
Type /page in the space anywhere in the editor then select the page:
Step 2: Create a Table
In the next step, the Table created is considered the default view of the database:
Step 3: Select a Database
If the database exists select that otherwise select a New database as shown below:
Step 4: Insert the Data into the Database
Finally, it is time to insert the data into your database:
2. Formula in Notion
One of the best properties of Notion is the formula property that allows the user to automate multiple functionality in the database. These formulas ease the tasks make the database more organized and easy to retrieve data when needed.
3. Setting Up Formula in Notion
To set up a formula in Notion there are two main requirements, especially in the case of the website where you want to search.
These two main points are:
- Search item: The item you want to search and its property type is text.
- URL field: The property type for the URL field is the formula.
Now you can create a Notion database with the required fields along with the URL field that is set to the formula as shown below.
Step 1: Go to Edit Property
Fill in the name for the column then click on Edit as shown below:
Step 2: Select Formula
Now select the property type as depicted below:
And finally, select the type as Formula:
In the next part, we will further see specific formulas.
4. Formula for Google Search
If you want to search from the Google Search engine just type the formula depicted below:
if(not empty(Name), "https://www.google.com/search?q=" + replaceAll(replaceAll(Name, "[,]", ""), " ", "+"), "")
Now, you may type anything under the column declared as Name and the Google URL column will automatically create a link.
5. Formula for Wikipedia
The method to create a clickable Wikipedia link is similar to Google Search except for a difference in the formula. You can edit the formula using the method described in the heading no 1as:
if(not empty(Name), "https://en.wikipedia.org/w/index.php?fulltext=1&search=" + replaceAll(replaceAll(Name, "[,]", ""), " ", "+"), "")
Then, click Done:
As soon as you type something in the Name column a Wikipedia link is generated automatically in the Wikipedia URL column as shown below:
6. Formula for Amazon
The formula for Amazon search is depicted below:
if(not empty(Name), "https://www.amazon.com/s?k=" + replaceAll(replaceAll(Name, "[,]", ""), " ", "+"), "")
Type the formula and click Done:
The database will appear as:
7. Formula for Good Reads
Good Reads is a website for book lovers and contains the largest collection of books available online. If you type the name of the book in the Name column, the book or the author’s name opens through the URL from the Good Reads URL column.
The formula for Good Reads is:
if(not empty(prop("Name")), "https://www.goodreads.com/search?q=" + replaceAll(replaceAll(prop("Name"), "[,]", ""), " ", "+"), "")
Click Done once the above-mentioned formula is entered:
The database appears to be:
This concludes the working of the formula to generate clickable links in Notion.
Conclusion
To generate clickable links in Notion, create a database then enter the name for the stuff you want to search and select the formula property in the next column for the URL. In this article, we have gone through a detailed analysis of how a database is created along with the clickable links in Google Search, Amazon, Wikipedia, and Good Reads.
