Auto populating fields

(0) Share

Report

Posted on by Ladga

218

Hello,

I have the following scenario:

I have a custom entity ‘Estate Agent’ it has a lookup field to the Account entity to display the estate agents ‘Company name’.

From the Estate Agent entity there is a sub grid with a relationship to the lead entity, new leads can be created directly from the sub grid.

When a new lead is created, there is a field on the lead which displays the related Estate agents name . There is also an Account lookup field on the lead form, what I want to is for this field to be automatically populated with the company name of the related Estate Agent. So e.g. if the estate agent is called Joe Bloggs and he works at ABC Ltd, I want both these fields automatically populated (pulled from the Estate Agent form) onto the lead.

I’m having problems trying to get the estate agents related COMPANY to appear on the lead form, any direction would be useful, preferably not using code if possible.

Thank you

Ladga

All responses (2)

Answers (0)

Ladga 218 on at

Like (0)

Report

RE: Auto populating fields

Hi Abhishek,

Thank you for your in depth response, I went with approach 2 in the end which worked well.

Ladga
Suggested answer

abhi_dhoriya on at

Like (2)

Report
RE: Auto populating fields

Hi Ladga,

I am presenting couple of alternatives for this situations for general audience to brainstorm. For your case , i belive that approach one is more suitable if no Data Import are involved .

Always feel free to Add/Update any point if missing

Approach 1) Use Data Mapping for 1:N Relationship between your Custom Entity 1(Estate Agent) and Lead.

Pros

No Code Solution, works even when creating the Leads and Updating values for Custom Entity 1 Lookup so vice versa.

Cons

Solution Does not work for Data Import or Created from Code.

Approach 2) Use Business Rules on Lead Form's Custom Entity Lookup Change 1 to Fetch data from Account and update the Values in customer Field.

Pros

Not much Code Solution apart from Business Rule needed

Cons.

Business Rules mostly works for the Client side, unless specified to run on Server side.

If some one Accidentally Deactivate the Business Rule , solution doesn't work.

Solution Does not work for Data Import or Created from Code.

Approach 3) Use JavaScript on Lead Form's Custom Entity Lookup Change 1 to Fetch data from Account and update the Values in customer Field.

Pros

Less chances of accidental changes once registered .

Cons.

JavaScript works only for the Client side.

Fair amount of Coding Involved.

Solution Does not work for Data Import or Created from Code.

Approach 4) Use Workflow on Lead Create/Update and Fetch data from Custom Entity's Account and update the Values in customer Field.

Pros

No Coding Involved

Solution works for Data Import or Created from Code

Cons.

Extensive Coding and Deployment activities are Involved.

If some one Accidentally Deactivate the Workflow , solution doesn't work.

Approach 5) Use Plugins on Lead Create/Update and Fetch data from Custom Entity's Account and update the Values in customer Field.

Pros

Less chances of accidental changes once registered .

Works everywhere, for Data Import, Data Created from Code or any other way.

Cons.

Extensive Coding and Deployment activities are Involved.

Have a great day ahead !!!

Thanks,

Abhishek

Community site session details

Auto populating fields

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Auto populating fields

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Adis Hodzic – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates