Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

Check if text is already mentioned in another column

Hi guys

So im building a database of architecture youtube videoes. This database would be shared between a few of my classmates and i wonder if there is a way to check if the same URL link already has been mentioned in another column and display this with a message.

I imagine the table would look something like this

Name of youtube video, Link, Mentioned?
Architecture is fun, link, good to go
We love architecture, link, good to go
Architecture makes me laugh, link, already linked

Im really not that good at this kind of stuff so idk if its super easy. Please tell me if this needs clarification

Thanks in advance <3

1 Answer

0vote

polle Points90800

You can check if an URL is already used or not with a Notion formula.

Create a new property (column) and set is as a formula using the following:

if(prop("Link") == "https://www.youtube.com/watch?v=gHZiAF0h1wk", "already linked", "good to go")

Just change "Link" for the name of the column where you are adding the links and change the Youtube URL for the one you need to check.

Hope that helps.

1vote

Sejling commented

Hi, thanks for the answer.

Instead of checking for one specific video/URL. I need to check the entire column of links. As a way to make sure there arent any video/URL's being repeated. Is there a way to do this?

Thanks in advance ^^

0vote

polle commented

You can compare column 2 to column 1 in the same row, but not column 2 in row 1 to column 1 in all rows.

Notion formulas work by row, so you can get information or compare from different columns, BUT in the same single row.

You will need to create a different structure for this to work. Maybe having a separate Video URLs database that you can relate and Rollup can do the trick.

Also keep in mind that Youtube URLs are unique, so maybe you can approach this in a different way.

Please explain the complete scenario to understand what you are trying to do and why you need to compare the URLS that way to see if there is a better way to do it.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect