• Ajinkya Wankhede
  • 10 Points
  • Member since 2017

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
  • 5
I need to update the Timezone field of Lead object on the basis of State/ZipCode/Telephone Number on every lead creation. I already have list of Zipcodes/State/telephone no. along with their timezone in excel format.
Mapping will need to be created for all of the combinations and which time zone should be used. 
This mapping table will be used to look up lead time zone.
I want to query in Salesforce database for an inactive user to check if he is owning any records or not?
I tried to query in Salesforce data loader but it only queries on one entity at a time. Also, the same behavior is shown for Reports wherein one entity gets queried at a time. 

Please advise further. Thanks