Hi,

I am trying to setup an email alert through workflows when ever owner changes for the account.I am trying to to it using ISCHANGED(OwnerId) in rule criteria (formula evaluats to true)but it throws an syntax error saying Function ISCHANGED may not be used in this type of formula.

I want to know is there any work aroud for this Issue.

Any help is gr8ly appreciated.

I want to show the Contact Mailing City field on my Case Page Layout, but it is not an option to select.

Does anyone know a way to get this field to show on the Case Page Layout?

I ultimately want to add that field to the Cases Views so I can have a few cities use the same queue and this way they will be able to easily see which cases are for their city.

Thanks

I have three fields Field A Field B and Field C

If Field  A is True then Field B is Required otherwise if Field A is False then Field C is Required. Can someone please tell me how to correctly write the formula, thanks.

I would like a URL to be visible on the Account, if the standard field "Rating" is set to "Customer". If any other value i.e. Prospect I do not want the URL to be visible. 

The URL is always the same and links (https address) to a common folder on  MS Sharepoint where we keep Customer information.

Even better - the URL could actually be different according to a logical value - Account Name. So if it possible to create a dynamic URL depending on Account name, that would be even better.

OR - is it even possible to create a link to our internal servers ? (Not URL link).

Why ?

When an account has become a "Customer", we store some information on it in folders on Sharepoint. It works to link to a folder (https-address), but I only want this link to be active on Accounts rated as "Customer" for many reasons.

Any idea ?

Hello,

  I am trying to create a field update for 2 fields in an object. One field is called status and is a picklist and the other field is called probability which is simply a percent field. I am trying to create a field update that says when status is changed to "completed", then make the probability equal to 100. Here is the formula I created below:

IF (ISPICKVAL( Status__c ,"Completed") , Probability__c = 100)

I am getting this error message: Error: Incorrect number of parameters for function IF(). Expected 3, received 2

Can somebody help me?

I have a picklist on a parent field with dropdown options from 1 through 50.

I want to have a formula on the child account which copies the same selection from the parent.

I have tried combinations of CASE, ISPICKLIST, OR and evrey other option to no avail.

Any suggestions? 

I'd like to create a workflow rule that automatically notifies certain people when an account owner is changed. I would also like to do this for the billing address. I can't figure out a way to base a workflow rule on a value in a field being modified. Has anyone been able to do this?

Thanks in advance!!

We operate with 5 currencies. These are available in a picklist for each account - Account Currency (CurrencyIsoCode), as well as when creating opportunities.

We would like to use the same Account Currency on all accounts (and not allow anything else than Euro). For the opportunities, we still want to keep the possibility to chose from the picklist and to keep them in local currencies.

The reason for this is that today, people mess up when creating accounts. They might choose GBP, and still enter Account Revenue in EUR - hence we can not classify our prospects from their revenue. We simply cannot trust the figures.

I´ve tried with ISPICKVAL(picklist_field, text_literal)   but this only allows me to return an errormessage on one false value. We need to omit 4 from the list.

Any idea ?

hi there,

does anyone know what the rule would be for something like this?  i'm struggling with the code:(

• if this checkbox is checked, make these fields required
• if this checkbox is unchecked, make these same fields NOT required 

or even better -

• if this checkbox is checked, REVEAL these fields and make them required
• if this checkbox is unchecked, HIDE these same fields and make them NOT required

Thanks so much!!

I am not a developer but we had a developer create some Classes, Components and Pages for us in late 2008 that we put into but never used in production and do not plan to use anytime soon or ever.  We would like to export these out of our production org.  We see where we can download Classes to our file system and then we could delete the classes, but see nothing similar for Pages and Components.  How can we export the Pages and Component so we can also delete them from out production Org? 

Where can we look to get or how can we find a better description of the reason for an Outbound Messaging Delivery Failure? Below is what we get from Outbound Messaging Delivery Status page.  It truncates the specifics making for a lot of guess work/ trial and error.

System.Web.Services.Protocols.SoapException: Server did not recognize the value of HTTP Header SOAPAction: . at System.Web.Se

Any ideas how to make the compile size smaller or otherwise accomplishe what I want?

I need to set a text type status formula field based on Effective Date and Expiration Date (Both are Date formats that are formula fields themselves derived from text fields with values like 20090527) .  This is what I have and the error message - I'd like to solve this without needing to wait for Summer 09 if possible.  Any ideas appreciated.

Error: Compiled formula is too big to execute (6,419 characters). Maximum size is 5,000 characters IF( AND( E_O_Policy_Effective_Date_Format__c < TODAY() , E_O_Policy_Expiration__c > TODAY() ), "1", "3")

This is using Mobile Lite.  We have several users using it with no problem.  I have a user that can download the client fine but the device will not Activate. Does anyone have any ideas?

&00N50000001kKSt={!Event.StartDateTime}
&00N50000001kKSy={!Event.EndDateTime}

Appreciate any help with this.

I am not a developer but we had a developer create some Classes, Components and Pages for us in late 2008 that we put into but never used in production and do not plan to use anytime soon or ever.  We would like to export these out of our production org.  We see where we can download Classes to our file system and then we could delete the classes, but see nothing similar for Pages and Components.  How can we export the Pages and Component so we can also delete them from out production Org? 

Where can we look to get or how can we find a better description of the reason for an Outbound Messaging Delivery Failure? Below is what we get from Outbound Messaging Delivery Status page.  It truncates the specifics making for a lot of guess work/ trial and error.

System.Web.Services.Protocols.SoapException: Server did not recognize the value of HTTP Header SOAPAction: . at System.Web.Se

Hi All.

I have the following requirement -

I want a text to be displayed on the page that should be just a label, not to be associated with any field. It is a normal page and not a Visualforce page.

My text is about 200 characters (the character limit for field label is 50 chars and that for section label is 80 chars).

Can anyone suggest me the solution for this?

Any help will be GREAT :)

Thanks

I need to write a Data Validation rule to enforce users to use the Task Subject pick list values when creating tasks or activities.

I've started with this but need some help finishing it:

IF( Subject  <> "Call, Contacted, Conversation, Fax, Handoff, Interview, Left Voicemail, Mailed Collateral, Other, Send Email, Send Letter, Send Quote, Web Meeting , value_if_true, value_if_false)

Thank you,

Hi,

I am trying to setup an email alert through workflows when ever owner changes for the account.I am trying to to it using ISCHANGED(OwnerId) in rule criteria (formula evaluats to true)but it throws an syntax error saying Function ISCHANGED may not be used in this type of formula.

I want to know is there any work aroud for this Issue.

Any help is gr8ly appreciated.

I want to show the Contact Mailing City field on my Case Page Layout, but it is not an option to select.

Does anyone know a way to get this field to show on the Case Page Layout?

I ultimately want to add that field to the Cases Views so I can have a few cities use the same queue and this way they will be able to easily see which cases are for their city.

Thanks

I need to find a way to create an auto-incrementing version number for records created in my custom app.  I've created a product management database where product information is entered and modified over time.  When the record is intially entered, I'd like the version field to show "1".  Then if the record gets edited, I want the record to get saved with a new version number (2,3,4,etc). 

Can I do this using a custom field?

Hey guys, I'm an intern building a database for a real estate company and need some serious help.  I'm trying to create a field (specifically a date field) that when a date is added to the field, it triggers the next set of tasks.

Currently I have selected:

Eviction Scheduled (date field) is 'not equal to' ""

It isn't accepting "" as a null value so first wondering what null is in Salesforce's language.

When that didn't work I tried to create a formula that triggered when any date beyond May 1st, 2009 was entered (and was true).  No luck there either.

This was the formula:

REOHQ__REOHQ_Eviction_Scheduled__c > DATE(2009,5,1)

If anyone has any advice, I would be greatly appreciative of some help.

Thank you,

Ross Johnson 

We use a standard naming protocol when naming records on a standard object, i.e. Account Name - Date

I am trying to create a workflow, so that when a user creates a new custom object record and doesnt put the account name into the custom object Name field then a workflow is triggered. I want the workflow to update the name field to include the account name field + a date field + whatever was saved in the date field.

So the workflow would trigger if the 'Name' field does not contain 'Account' field, but i am struggling to put this into formula terms.

Am i going about this the correct way, or should i be using a trigger for this?

Any help would be great.

Matt

This is using Mobile Lite.  We have several users using it with no problem.  I have a user that can download the client fine but the device will not Activate. Does anyone have any ideas?

Hi, I have this validation rule to prevent sales from overriding the forecast category:

or(
and(
case( StageName , "Requirements Analysis", 1, "Qualification", 1, "Proposal", 1, 2) < 2,
Not(ispickval( ForecastCategoryName , "Pipeline"))),
and(
text( StageName)="Negotiation",
Not(ispickval( ForecastCategoryName , "Best Case"))),
and(
text(StageName)="Closing",
text(ForecastCategoryName)<>"Forecast",
text(ForecastCategoryName)<>"Commit"))

The first two work perfect....

but the 3rd one (closing stage = commit

 and(
text(StageName)="Closing",
text(ForecastCategoryName)<>"Forecast",
text(ForecastCategoryName)<>"Commit"))

cannot work... I tried many ways to rephase the formula, without luck...

What is wrong?