Skip to Content

Wiki source code of ESPO CRM - Foreign Fields

Last modified by Douglas Bower on 2026/05/09 16:25
Show last authors
1 Creating custom field types: [[https:~~/~~/docs.espocrm.com/development/custom-field-type/>>https://docs.espocrm.com/development/custom-field-type/]]
2
3
4 Foreign Field Types:
5
6 We saw a new feature in 4.1.0 called 'Foreign' field ("Provides an ability to view field of a related record and search by this field"). We are not 100% sure what it is but by the description it can be a VERY useful tool. Can you please tell us a basic example (scenario) of a Foreign Field in use?
7
8
9 It's indeed one of the most useful features there is. Example: you would like to see a contact's industry - which naturally stems from the company. By setting up a related field account.industry in contact you can show it...
10 \\Even more useful: Searches. Give me all contacts from companies in Switzerland and industry = watches and revenue > 100 mio. This you can do now easily provided you set up the necessary fields. And do not forget that you may set up a field for query purposes only, you don't have to show it in the layouts.
11