• Rachel Sommer-Mayer
  • NEWBIE
  • 0 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 0
    Replies
Hi All,

Was wondering if there was a quick way to export all opportunity field names, API names, data types, field values (if available) and more or less all information related to a field into excel.

Any good free apps that anyone has used? Or a way to do that? Basically want to make a data dictionary and would LOVE to avoid having to go through every single field manually!

TIA!

 
Hey All,

I have a bad case of the mondays and I AM STUCK. Need assistance building out a formula field.It would be a percent field 
I want the formula to say:
IF Targeting_Lines_of_Business__c = "Property" (this is a picklist field) then
Case(TEXT( Responsible_OE__c ),
"Austria", 0.541,
"Belgium", 0.89,
"Brazil", 0.87,
"Canada", 0.451,
"China", 1,
"Eastern Europe", 1,
"France", 1,
"Germany", 0.87,
"Hong Kong", 0.891,
"India", 1,
"Ireland", 1,
"Italy",1,
"Japan", 0.983,
"MENA", 1,
"Netherlands", 0.978,
"Nordic", 1,
"Pacific - Australia" , 1,
"Pacific - New Zealand", 1,
"Portugal", 0.988,
"Russia", 1,
"Singapore", 0.964,
"South Africa", 0.918,
"Spain", 0.988,
"Sweden", 1,
"Switzerland",0.511,
"Turkey",1,
"UK", 0.879,
"USA", 0.936,

0

IF Targeting_Lines_of_Business__c ≠ "Property" then all Responsible_OE__c = 1

Does that make sense?! I'm stuck!

THANKS!