Skip to main content
Topics#ApexAndreas Englund の質問
Andreas Englund (DevCore AB) が「#Apex」で質問
2019年3月13日 11:52

Autopopulate/suggest record based on Contact address

We have nonprofit asssociations that are responsible for different areas in Sweden. When I create a new contact in lightning I want the association field to be autofilled or suggested for the user with the corresponding association based on the Contact's postalcode.

We will have a table with each association and their respective postalcodes. So based on the postalcodes in this table I want to suggest a association for the contact that has a corresponding postalcode.

Is this possible? I'm not sure how to implement this requirement and would be grateful for some assistance.
3 件の回答
  1. Sujeet Patel (Midis Group)
    2019年3月14日 16:02
    Hiii Andegosu

    You can also use after trigger.

    to getting the data about 16000 Postal code we should go for the batch class which help us to get records easily.

    and According to me map will help full for us

    because of below line

    "***.get(c.PostalCode)" 

    will return name of association according to postal code.

    As i say above to get the data about postal we use batch apex class and a method which return data of postal codes.

    And

    i have another method which also help full for you

    trigger ContactBI on Contact(before insert){
    	String str;
    	for(Contact c:trigger.new){
    			str=c.PostalCode;
    	}
    	Association as=[select id,name,PostalCode from Association where PostalCode=:str limit 1];
    	for(Contact c:trigger.new){
    			str=ac.Name;
    	}
    }

    I think this code is help for you

    and my this code is not exact as you think this is only demo 

     
回答を記入...
0/9000