You need to sign in to do that
Don't have an account?
anupam_ghosh
apaex data loader failing to update a field with formula in it
Hi Experts,
I am very new to SFDC and trying to update a field using apex data loader. First of all I can't find in list of fields I am searching to update in field mapping. Then I found the customised field account_site_status has a formula like this CASE( $RecordType.Name , "Site", TEXT(Site_Account_Status__c),TEXT(Type)). I found both fields referred in formula are picklist values. could you please kindly explain what this formula means? Secondly how to update these kinds of fields using apex data loader? This is very urgent.
Regards
Anupam
Hi,
You cannot update formula fields using Data loader. A formula field will automatically be updated based on the value in other fields, so you need not explicitly map formula fields when you run data loader.
Thanks,
Aravind
All Answers
Hi,
You cannot update formula fields using Data loader. A formula field will automatically be updated based on the value in other fields, so you need not explicitly map formula fields when you run data loader.
Thanks,
Aravind
Hi Aravind,
Thank you so much for your kind response. I have managed to resolve the issue.
Regards
Anupam