I need to know what Timezone all of my Contacts are in for when my reps call them.  Is there any code that can take the area code from the phone number or the zipcode from the address and then process it and push back what Timezone the Contact is onto the page in a field I create?

I am trying to do an image formula that opens a report.  This will be on the Accounts tab,  when you click on the image it will open up a report page to a report that will be generated just for that Account.  The problem is that the merge field for Account Name is Name,  it is placing into the report crieteria the word Name not the merge value of the Account Name.

Formula Code:

HYPERLINK("https://na1.salesforce.com/00O30000001FJ9W—pv0=Name&pv1=0",IMAGE("https://na3.salesforce.com/servlet/servlet.ImageServer–oid=00D300000006F9s&id=01550000000K1DO", "Click Here to go"))

 results:

I have created a Validation rule on the User record to make the Company field required.  I have noticed that with Managed Packages a User is created.  Will this validation rule stop my from downloading these Applications?

I need to know what Timezone all of my Contacts are in for when my reps call them.  Is there any code that can take the area code from the phone number or the zipcode from the address and then process it and push back what Timezone the Contact is onto the page in a field I create?

Does anyone know if it's possible to recreate the Opportunity Stages picklist?

What I'd like to do is based upon a users choice from a picklist, populate another field with a percentage. Exactly how the Opportunity Stages picklist works, but with my own custom names and percentage values.

I really appreciate any insight or guidance anyone can provide.

Thanks!

In case you haven't heard, we've added some cool new functions in the Spring '08 release to help you write more powerful validation rules.

• VLOOKUP Function: Similar to its Excel counterpart, the VLOOKUP function lets you use data in another object as a basis for validation.  For example, to validate the zip code in a contact address, you could use the VLOOKUP function in a contact validation rule to search for a match in a custom object containing a list of valid zip codes.
• ISNUMBER Function: The ISNUMBER function provides a simple way to tell if data entered in a text field only contains numbers, which is required for many types of identification numbers like credit cards and account numbers. 
• REGEX Function: Regular expressions are a powerful tool used by programmers to find patterns within bodies of text.  The REGEX function gives you access to regular expressions in your validation rules.  This may be useful to validate complex number formats, like IP addresses, country-specific postal codes or phone numbers, tax IDs, and so on.
  

Check out the Advanced Validation Rules page on successforce for more information.
 
For your reference, here are links to the function documentation in the online help.
VLOOKUP function
ISNUMBER function
REGEX function

Cheers,
Eric Bezar
Force.com product management

When trying to creat a formula which, adds the totals of 2 other fromulas I get the following error message
"Error: Compiled formula is too big to execute (7,760 characters). Maximum size is 5,000 characters". Which I find confusing since the formula it's self is  "TA1__c + TA2__c". the formula format is number with 3 decimal places. So I guess the crux of my problem is how the systems counts characters when compiling a formula?  Any one have any ideas/clues/suggestions?

I'm trying to implement an "upcoming birthdays" report as described here:

http://blogs.salesforce.com/analytics/2007/12/if-youre-like-m.html

except that

1. the images in that blog post are broken, and
2. i don't want to install the entire appexchange package (9 components) when all I really need to see is the formula field definition for "Next Birthday."

Anyone have this package installed already and willing to share the formula? Thanks!

Aaron

Hi all

         I want to create a custom object " Order " , but getting an eror " Error: The custom object name you specified matches a Salesforce name. You must specify a unique name ". There is no bject in my salesforce instance with this ( Order ) name. Is this name is any reserved keyword. If anyone have any idea then please reply. Thanks in advance.

AP

Hi,

I need some help regarding creating and hiding username and password fields on an account without creating new profiles.

Our solution already has >20 profiles and if I would create a new profile for each user that should have access to these new fields, I need to create at least 10 more.

I thought about hiding the username and password for all users except the sysadmin and then create a Formula field (text) which shows the information based on a checkbox in the userrecord.

IF( $User.Password_active__c = true, Password_c , ""), i.e. shows the content of the field "Password" if the checkbox is marked, otherwise it shows nothing.

Is there another way of doing this, and are there any security implications of this approach that I should know of?

Thanks,
Joakim

Hi,

Can anybody help me get the formula for putting the date at the top of mail merge letters automatically.

i.e.

November 2nd 2007

Tom Smith
Attorney
Anywhere Street

I was given this formulat which is not working:

{ DATE \ @ ‘’ dd MMMM yyyy ‘’ \ * MERGEFORMAT }

thanks

I'm trying to embed a graph from compete.com as an image formula for an account.  The URL is always displayed at a unique URL like this:

http://grapher.compete.com.edgesuite.net/google.com_uv.png

where you see google.com should be replaced with "& Website", but I think the _uv.png at the end of the URL is causing me problems.  This looks like it should be very simple, yet I keep getting syntax errors. 

If anyone can provide me with the correct formula I'd appreciate it.

-Chris

My organisation is a consultancy, and we have a number of different "rate sheets" which we use to price jobs. 

We record in Salesforce which rate sheet applies to each Opportunity.

We also record in Salesforce the projected margin which we expect to make on the Opportunity if we win it.

For each different rate sheet, we have estimated what a typical/average margin would be.

What I'd like to do is this.  When an Opportunity is created, the margin will be set automatically within Salesforce as a function of the rate sheet which has been selected.  But then the user can over-write the margin - typically, when the bid is submitted - with a number that has been calculated specifdically relating to that Opportunity.

I know I can use the CASE statement in a Custom Formula field, but I don't think that can be made editable.

I know I can create default values for Custom Fields, and I know that the default value can be calculated using a formula, but I don't think the formula can refer to other Opportunity fields.

Have I overlooked something?
Thanks in advance for your help.

I am new to salesforce (using for 4 months now) and I need to add my first validation code.  I have not done this as of yet and I do not understand the coding language. 

I am looking for a code which will require an entry into another field on the same object when a different field is checked (it's a checkbox field).  I have two of these instances and would like the code rather simple.  For example:

If the Returned to Manufacturer (Field: Returnmfg; API name: Returnmfg_c) field is check, then I want to require the entry of a Return Authorization number in the additional custom field provided (Field: RMA; API name: RMA_c).  Also, when the Received back from Manufacturer field is checked, then I want to require a date entered into the custom field provided.

I've already created the fields.

Thank you!

I am trying to do an image formula that opens a report.  This will be on the Accounts tab,  when you click on the image it will open up a report page to a report that will be generated just for that Account.  The problem is that the merge field for Account Name is Name,  it is placing into the report crieteria the word Name not the merge value of the Account Name.

Formula Code:

HYPERLINK("https://na1.salesforce.com/00O30000001FJ9W—pv0=Name&pv1=0",IMAGE("https://na3.salesforce.com/servlet/servlet.ImageServer–oid=00D300000006F9s&id=01550000000K1DO", "Click Here to go"))

 results:

I have created a Validation rule on the User record to make the Company field required.  I have noticed that with Managed Packages a User is created.  Will this validation rule stop my from downloading these Applications?

03-13-200701:01 PM