I am trying to do a concatenate merging two text fields.  Occasioanlly the concatenated field may contain a duplicate value. I am looking for a way to delete the duplicate value so only the value only appears once. 

IE: Field 1: 123567,88595

      Field 2: 987987,88595

Concatenate Field Result: 123567,88595, 987987,88595

Desired Result: 123567,987987,88595

Can anyone suggest a way to do this? 

Hi, 

I recently created a workflow with an outbound message, there was an error on the receiving end and the messages got delayed.  Due to the error I deleted the outbound message in an attempt to delete the Queued messages, however they did not get removed from the queue.  I have tried to click "Del" and "Retry" in an attempt to get them cleared out, and neither of those buttons have any effect on the queue.  I have confirmed there are no longer any Outbound Messages in my account, does anyone know any other way to remove these, or remedy the situation?  

Thanks!

I am trying to use an external id that as a comma in the value, IE: 1,234.

I want to use the value 1234 in a link.  I was going to do a substitute but that can only be done with a text field and not a number field.  Any suggestions?

Thanks!

Is anyone aware of a way, or a solution that would scan an address on an order and identify if the address is a Residential, or Business address?  We ship many products, however when an order is placed it is done online and our customers don't identify if they are using a Residential or Commercial addresses.

Hi I am trying to create a formula that will take the first 60 characters from a field and add ... to the end of the formula, however if the field is blank it would remain blank.

I've figured out the trim, I just can't figure out the "..." part. 

TRIM(LEFT(ECS__Shipping_Detail__r.ECS__Shipping_Instructions__c,60))

I appreciate the help.

Thanks!

Hi I am trying to create a formula that would have several Zip Codes, and if the zipcode is in the formula it would be indicated in the field. 

IE: If Zip Code Field contains 01234,12345,34561,08043,66236,52432 display Extended area, or if zip contains 55555,78948,66589,88896 Display Local Area.

The End Result would be for the field to display "Extended Area" or "Local Area" depending on the zip code.  If the zipcode doesn't match either return "null".

Any thoughts?

Thanks

Hi I am trying to create a formula to click one url and have it open two windows with different URL's.  The only way I've come up with to do this is with a Java Script code.  Like this.

Header of page:

<SCRIPTLANGUAGE="Javascript"> 

functionDoubleOpen(site1, site2){ 
window.open(site1); 
window.location = site2; 
} 
</script>

<ahref="javascript&colon;DoubleOpen('site1', 'site2');">Click Here</a>

Hello everyone need some help with a Hyperlink formula.  I've created a hyperlink and when I "Copy Link" and paste the link works fine.  However when I click on the link in my account it opens a new page but only puts part of the URL.  If I try to paste the URL that I copied it works as well, just not when I click the hyperlink in my account.  Any suggestions?

Here is the URL (Note the *'s are numbers removed for security purposes):

https://cp52-3.fonality.com/call.cgi?server_id=1****7&extension=*****&number=423***505&username=lsdwareh&password=wt1&calleridname=johns&success_redir=https://na12.salesforce.com/002/e?parent_id=a0DU000000A0WBg&retURL=2fa0DU000000A0WBg

When the new page opens this is the url it opens to:

https://cp52-3.fonality.com/call.cgi?server_id=1****7&extension=*****&number=423***505&username=lsdwareh&password=wt1&calleridname=johns&success_redir=https://na12.salesforce.com/002/e?parent_id=a0DU000000A0WBg

Note it is cutting off the https://cp52-3.fonality.com/call.cgi?server_id=1****7&extension=*****&number=423***505&username=lsdwareh&password=wt1&calleridname=johns&success_redir=https://na12.salesforce.com/002/e?parent_id=a0DU000000A0WBg&retURL=2fa0DU000000A0WBg

Thanks!

Hi I am creating an email template with visual force.  When using the Apex:repeat is there any way to have it not display a value?

Here is what I have and it is showing everything related to that object.  However if the ECS__Product__r.Name = "Shipping" I want it to skip that line and not display it.

<apex:repeat value="{!relatedto.ECS__Order_Lines__r}" var="ol">
<tr>
<td>
  {!ol.ECS__Product__r.Name}<br/>
</td>
<td>
{!ol.ECS__Quantity__c}
</td>
<td>{!ol.body_end__c}</td>
<td>{!ol.Shaft_End__c}</td>

</tr>
 </apex:repeat>

Any thoughts?

Thanks!

Hi I am a newbie and need some help with a workflow.  Hopefully I will explain it well enought.  I have an Object (order line) that has several lines (products) listed in it.
I setup a workflow for to check for a false value in a field (Ship) Obect:(Order Line).  If false make update object:(order) field (DS2) = true.  The rule works well as long as all the lines (products)  have the same data, but if one of the products is true and one is false then it marks the (Order)(DS2)true.  Is there anyway in a workflow to tell it that everything in the Object (Order Line) must equal true for it to update Order DS2.
Please let me know if this isn't clear. Thanks for any help.

Hi I am trying to setup a workflow that will look at a custom object which is incoming orders.  If the Name is the same in both orders and the status is unshipped I want to set a flag. How would I create the workflow to say if the two orders have the same name to flag them?

Hi I have my email setup to forward into SF.  I would like to have the email connected to the associated order number, which is in the Subject of the email. 

For Example the subject may be "Return 12345-65-2"  I have a Lookup Field that I want that information to go into, which corresponds with an order in SF. 

Can this be done with a workflow?  How can I achieve this? I am very New At SF so I am not sure about Apex Coding, and Visual Force.

Any suggestions would be greatly appreciated.

Hi we have an object that has all of our products, in that object the product has characteristics... IE: Extended Length, Compressed Length, and weight.

When we get calls we search through our products for the proper paramaters the customer needs.  IE: 48 Extenderd. 12 Compressed and 15 pounds... Is there any way to create a spot for me to enter the values I am looking for and have all my other products filtered that do not fit the characteristics needed?

Any suggestions as to how to acheive this?

Thanks

I am trying to create a hyperlink with several different fields populating to build it. 

For Example:
HYPERLINK(http://cp.fonality.com/call.cgi?Server_id=12345&extension=$User.Extension&username=johndoe&password=12345&number="&Phone, Call)

Both User Extension and Phone are fields set in Salesforce. 

The Bold text indicates the two fields we want to use for the hyperlink.  

Thanks for any advice

I am trying to do a concatenate merging two text fields.  Occasioanlly the concatenated field may contain a duplicate value. I am looking for a way to delete the duplicate value so only the value only appears once. 

IE: Field 1: 123567,88595

      Field 2: 987987,88595

Concatenate Field Result: 123567,88595, 987987,88595

Desired Result: 123567,987987,88595

Can anyone suggest a way to do this? 

Hi, 

I recently created a workflow with an outbound message, there was an error on the receiving end and the messages got delayed.  Due to the error I deleted the outbound message in an attempt to delete the Queued messages, however they did not get removed from the queue.  I have tried to click "Del" and "Retry" in an attempt to get them cleared out, and neither of those buttons have any effect on the queue.  I have confirmed there are no longer any Outbound Messages in my account, does anyone know any other way to remove these, or remedy the situation?  

Thanks!

Hi I am trying to create a formula that would have several Zip Codes, and if the zipcode is in the formula it would be indicated in the field. 

IE: If Zip Code Field contains 01234,12345,34561,08043,66236,52432 display Extended area, or if zip contains 55555,78948,66589,88896 Display Local Area.

The End Result would be for the field to display "Extended Area" or "Local Area" depending on the zip code.  If the zipcode doesn't match either return "null".

Any thoughts?

Thanks

Hi I am trying to create a formula to click one url and have it open two windows with different URL's.  The only way I've come up with to do this is with a Java Script code.  Like this.

Header of page:

<SCRIPTLANGUAGE="Javascript"> 

functionDoubleOpen(site1, site2){ 
window.open(site1); 
window.location = site2; 
} 
</script>

<ahref="javascript&colon;DoubleOpen('site1', 'site2');">Click Here</a>

Hello everyone need some help with a Hyperlink formula.  I've created a hyperlink and when I "Copy Link" and paste the link works fine.  However when I click on the link in my account it opens a new page but only puts part of the URL.  If I try to paste the URL that I copied it works as well, just not when I click the hyperlink in my account.  Any suggestions?

Here is the URL (Note the *'s are numbers removed for security purposes):

https://cp52-3.fonality.com/call.cgi?server_id=1****7&extension=*****&number=423***505&username=lsdwareh&password=wt1&calleridname=johns&success_redir=https://na12.salesforce.com/002/e?parent_id=a0DU000000A0WBg&retURL=2fa0DU000000A0WBg

When the new page opens this is the url it opens to:

https://cp52-3.fonality.com/call.cgi?server_id=1****7&extension=*****&number=423***505&username=lsdwareh&password=wt1&calleridname=johns&success_redir=https://na12.salesforce.com/002/e?parent_id=a0DU000000A0WBg

Note it is cutting off the https://cp52-3.fonality.com/call.cgi?server_id=1****7&extension=*****&number=423***505&username=lsdwareh&password=wt1&calleridname=johns&success_redir=https://na12.salesforce.com/002/e?parent_id=a0DU000000A0WBg&retURL=2fa0DU000000A0WBg

Thanks!

Hi I am creating an email template with visual force.  When using the Apex:repeat is there any way to have it not display a value?

Here is what I have and it is showing everything related to that object.  However if the ECS__Product__r.Name = "Shipping" I want it to skip that line and not display it.

<apex:repeat value="{!relatedto.ECS__Order_Lines__r}" var="ol">
<tr>
<td>
  {!ol.ECS__Product__r.Name}<br/>
</td>
<td>
{!ol.ECS__Quantity__c}
</td>
<td>{!ol.body_end__c}</td>
<td>{!ol.Shaft_End__c}</td>

</tr>
 </apex:repeat>

Any thoughts?

Thanks!

I am trying to create a hyperlink with several different fields populating to build it. 

For Example:
HYPERLINK(http://cp.fonality.com/call.cgi?Server_id=12345&extension=$User.Extension&username=johndoe&password=12345&number="&Phone, Call)

Both User Extension and Phone are fields set in Salesforce. 

The Bold text indicates the two fields we want to use for the hyperlink.  

Thanks for any advice