How i can disable the unique parameters for web site field ?
I need import data about companies and some time it's possible to have many companies with similar website.
For exemple, many office in different town or mother companies with subsidiary.
Api send return me error message when i put similar data for this field.
Or in app, when i populate this field with an existing domain in another record that work correctly.
11 Replies
Hello @Sebastien unless I'm mistaken you should now be able to toggle off the field uniqueness in twenty latest version from the field settings page directly
If not I would recommend creating an intermediairy non unique custom field and use this as a fallback
Hi @Prastoin , i have the toggle on my self-hosted version 1.4.1, but it does'nt work !
Hey what does not work exactly ?
The settings toggle or row insertion afterwards that still persist the uniqueness constraint ?
cc @Etienne
Uniqueness on standard field can't be toggled off. On company for example, domain name is used for mail syncing that's why we don't enable update.
You can create an other field on company or create an other object
Here an answer from product. We know it can be annoying, it's not the first time we had this request
Ok @Etienne . I understand why the toggle don't work. Create another field is a way i had thinked.
For the moment i try to search company in API Call who use GET and filter by domainName.primaryLinkUrl. Is it possible to do that ? For the moment that don't work with [eq] comparator. Can you said me if this way is possible ?
curl 'https://api.twenty.com/rest/companies?filter=domainName.primaryLinkUrl%5Beq%5D%3A%22https%3A%2F%2Fairbnb.com%22' domainName.primaryLinkUrl[eq]:"https://airbnb.com"it should work. Can you try with this ⤴️ ?
I can't test with airbnb, because i had delete this domain on my instance.
Below my request, similar than yours :
https://myurltwenty.com/rest/companies?filter=domainName.primaryLinkUrl[eq]:"exemple.com"
This good syntax or there have mistake ?
Hello please replace Airbnb with one of your row primary email
That don't work with airbnb. Domain exist for one company on my crm but api response is empty.
you can try with [ilike]:"%example.com%" if you're not sure of the complete url
Thanks @Etienne , that work with [ilike] operator