Tables - Duplicate domains are created for slightly distinct domain formats

[StephanieJoly4]

trafficstars

Bug Description

domain.com, www.domain.com (that is saved as https://www.domain.com) and https://domain.com can be used to create distinct companies. I would expect Twenty to prevent from creating one of those accounts because this is the same domain. (from a user's perspective). We cannot expect that users will all respect the same domain format when creating a company: it's sometimes created manually, sometimes with the email or calendar sync, sometimes with csv upload

Example: see screenshots

Expected behavior

domain.com domain.com/ http://domain.com https://domain.com www.domain.com https://www.domain.com are all the same company. A new company should not be created, trying to enter any of the domains above, if a company already has one of those domains.

Other example (can be discussed but seems the most logic from a business perspective)

• axa.fr and recrutement.axa.fr should create 2 distinct companies
• bnp.com/uk bnp.com/jp should create 2 distinct companies

thanks!

Urgency: this is not blocking any customer but we're accumulating debt as users will have to clean up their Twenty

Not in the scope: there is no need to create something to clean up existing workspaces as users will have to decide which company to delete / keep depending on the existing data attached to each company. The goal is to fix this moving forward.