You need to sign in to do that
Don't have an account?
Rabbani sayyed 8
I have two objects, Account (Std) 2. Airports (Cstm) There is a field in Accounts called 'Airport Supplied' Question: i would to like retrieve multiple name of airports in the above field E.g.:Airport Supplied = Delhi, Goa, London, Paris? Any suggestions
I have two objects, Account (Std) 2. Airports (Cstm) There is a field in Accounts called 'Airport Supplied' Question: i would to like retrieve multiple name of airports in the above field E.g.:Airport Supplied = Delhi, Goa, London, Paris Please provide the best advise
I am assuming airports has a lookup of account .
Now,Use this below code and make the necessary changes in the API names.
trigger updateAccountField on Aircraft__c (after insert,after update,after delete) {
set<String> updatedAccountRecordIDs = new set<String>();
list<Account> updateAccounts = new list<Account>();
if(trigger.isInsert || trigger.isUpdate){
for(Aircraft__c aircraft : trigger.new){
if(trigger.old == null || trigger.oldMap.get(aircraft.Id).Account__c != aircraft.Account__c){
updatedAccountRecordIDs.add(aircraft.Account__c);
}
}
}
if(trigger.isDelete){
for(Aircraft__c aircraft : trigger.old){
updatedAccountRecordIDs.add(aircraft.Account__c);
}
}
for(Account acc : [select Id,Airport_Supplied__c,(Select Id,Name from Aircrafts__r) from Account Where Id In :updatedAccountRecordIDs]){
string airports = '';
for(Aircraft__c aircraft : acc.Aircrafts__r){
if(airports == '')
airports = aircraft.Name;
else
airports += ','+aircraft.Name;
}
acc.Airport_Supplied__c = airports;
updateAccounts.add(acc);
}
update updateAccounts;
}
Thanks
Nitin
Use multipicklist field for "Airport Supplied" that is the best data type you can use.
Thanks,
Mudasir