Hi there,
Our EspoCRM is in the same database as another application (we did this by design).
Is it possible to have an espoCRM entity lookup another table in the database for values? We don't want to write to the other tables, just lookup.
For example.
We have the espoCRM entity of contacts
We want to have a select field where a espCRM user can select a contact from our other table
In espoCRM - Entity Manager - Contact - Fields = create a Enum field (lets call it EXTERNAL_CONTACT)
The EXTERNAL_CONTACT field doesn't use a list of options from the Enum field, but shows records from a different table (called oth_contacts)
Is this possible?
The concept here is to be able to have a select field that we can use to link the EspoCRM record with a non-EspoCRM record.
Our EspoCRM is in the same database as another application (we did this by design).
Is it possible to have an espoCRM entity lookup another table in the database for values? We don't want to write to the other tables, just lookup.
For example.
We have the espoCRM entity of contacts
We want to have a select field where a espCRM user can select a contact from our other table
In espoCRM - Entity Manager - Contact - Fields = create a Enum field (lets call it EXTERNAL_CONTACT)
The EXTERNAL_CONTACT field doesn't use a list of options from the Enum field, but shows records from a different table (called oth_contacts)
Is this possible?
The concept here is to be able to have a select field that we can use to link the EspoCRM record with a non-EspoCRM record.
Comment