Question

Hi all!

Imagine you are scouting for a new apartment in a new town, and fill a Notion DB with the details of apartments you are interested in: Owner name, Address, etc.

But! Not everyone in this new town is nice - some of them are horrible flat owners and you wish to avoid them. You are lucky enough to have a list of bad owners which you have, conveniently, also kept in Notion.

Could you build into your apartment database some function that will turn on if you fill in a name that exists in the naughty list?

---

Should look something like this:

Evil name list: Bill, Bob, Karen

Notion DB:

Name	Address	IsEvil?
Phil	7 Short st	-
Joe	12 Short st	-
Jane	4th avenue	-
Karen	27 Short st	XXX

Answer 1

You can do a simple check using a Notion formula.

Create a new Notion property as formula and add the following.

if(prop("Name") == "Karen" or prop("Name") == "Joe", "run", "stay")

That will check the names and will show "run" for Karen or Joe and stay for everyone else.

You can extend the or in the formula with all the bad owners.

Hope that helps.