I have created a report with the following criteria:

(Last Funding Date OR Date of Last Activity) AND Contact Prefrence Email

When i try to reproduce this as a formula field to tick a checkbox i receive different results.

IF(Last_Funding_Date__c >= DATE( 2018, 9, 1 )||Date_of_Last_Activity__c >= DATE( 2018, 9, 1 ) && Contact_preference_Email__c = TRUE,TRUE,

FALSE
)

How i written the formula correct?

Trying to find a way to block abusive chats other than IP address as customers can easily change this.

 

Hi trying to figure out what is the best way to either copy/move attachments from the case object to the account object?

Can this be achived either by a trigger or using the process builder or visual flow?

I have a chat button that works. What I would like to do is to show another chat button if the first option is offline. I know this can be done however I am having trouble replicating this.

Sample:

        <br/>
        <a id="liveagent_button_online_573D0000000L1Fl_573D0000000CcTn" href="javascript://Chat" style="display: none;" onclick="liveagent.startChat('573D0000000L1Fl_573D0000000CcTn')">
            <!-- Online Chat Content -->
            <img style="-webkit-user-select: none;background-position: 0px 0px, 10px 10px;background-size: 20px 20px;background-image:linear-gradient(45deg, #eee 25%, transparent 25%, transparent 75%, #eee 75%, #eee 100%),linear-gradient(45deg, #eee 25%, white 25%, white 75%, #eee 75%, #eee 100%);" src="http://via.placeholder.com/350x150?text=online">  
        </a>
        <div id="liveagent_button_offline_573D0000000L1Fl_573D0000000CcTn" style="display: none;">
            <!-- Offline Chat Content --><img style="-webkit-user-select: none;background-position: 0px 0px, 10px 10px;background-size: 20px 20px;background-image:linear-gradient(45deg, #eee 25%, transparent 25%, transparent 75%, #eee 75%, #eee 100%),linear-gradient(45deg, #eee 25%, white 25%, white 75%, #eee 75%, #eee 100%);" src="http://via.placeholder.com/350x150?text=offline">
        </div>
        
        <script type="text/javascript">
            if (!window._laq) { window._laq = []; }
            window._laq.push(function(){liveagent.showWhenOnline('573D0000000L1Fl_573D0000000CcTn', document.getElementById('liveagent_button_online_573D0000000L1Fl_573D0000000CcTn'));
            liveagent.showWhenOffline('573D0000000L1Fl_573D0000000CcTn', document.getElementById('liveagent_button_offline_573D0000000L1Fl_573D0000000CcTn'));
            });</script>
 

Hi I have following piece of code , where I am trying to link an external URL from the visualforce page, but it is always adding the sfdc server instance in front of the url so the url is not opening at all. Please tell me how to avoid the server url in front: https://ktdev-supportchat.cs107.force.com/apex/www.google.com

<div class="faqContainer" style="display: {!IF(custSetting.topFiveFAQ_1__c==null,'none','block')};">
              <image src="https://c.eu1.content.force.com/servlet/servlet.ImageServer?id=015D0000002HmOH&oid=00D200000008VAS" />
              <a class="faqContent" href="http://{!custSetting.topFiveFAQ_1_link__c}" target="_blank">{!custSetting.topFiveFAQ_1__c}</a>
          </div>

The field custsetting.topFiveFAQ_1_link__c has the following value: http://www.google.com

Trying to create a mulitple if Statement however I cannot see where I am going wrong:

current formula which works:

IF(FLOOR(( Priority_Date_Closed__c - Priority_Time__c )*1440) <= 180 ,True , False)

When I try to add another parameter I get an error message:

AND(
IF(
Priority_Level1__c = "P4",
FLOOR(( Priority_Date_Closed__c - Priority_Time__c )*1440) <= 180 ,True , False
)
)

Currently when a customer clicks on a link to start a chat they are directed to a button ID which is then directed to agents listed in the skill group.

Also when a customer signs into a website we capture their user id and pass this information back to salesforce to auto find their account record for the agent to talk with the customer.

What we would like to do is that when a customer signs into the website and starts a live chat they are directed to an agent which is not in the skill group but assigned to their account which is being shown in a custom field.

I know this is not possible through standard development but I would like to know if this can be achived by apex code?

I understand that the Customer Service agent can increase the size of their chat input box but I need the same functionality for the customers? Is that possible?

Do I have access to change: liveagent:clientChatInput
It is not very user friendly at the moment.

Ideally we would like the input box to automatically wrap the text. So if the customer enters information that is more than the first line, it will automatically create a second line as the customer continues to type.

Any guidance would be great (even if you are telling me it is not possible).

Thanks!

I want to add a custom button to the campaign member view 'Edit Members - Search'.

 

Is this possible?

Is it possible to add a new button to the edit campaign members view. The current buttons are 'Remove' and 'Update Status'. I have a lookup field to users on my campaign members.

 

I would like a button so I can group assign campaign members to one user.

 

If this is not possible can you think of a user friendly way to do this? Exporting and then importing the updated campaign members is not an option because I do not want to give users the permissions to perform such tasks.

 

Any help would be greatly appreciated.

 

Thanks!

Hi,

 

I know how to create a standard web to case form but does any know the code that is needed so attachments can be included in the web to case form??

 

Any help would be greatly appreciated! 

 

Thanks!

I want to have a link on campaigns that brings the user to a custom campaign. The correct report opens and the campaign name does populate in the "Select Campaign" field. However, the report does not populate until I click on the look up beside Select Campaign and then click on the campaign name that was already entered in the field?

 

/00OL0000000O3YS?scope=1&scopeid={!Campaign.Name}

 

Any ideas?

I have been working on a formula but I cannot make it without exceeding the compile limit. Shown below if a fraction of the formula. Do you know how I could reduce the compile size? Or do you know if a trigger would be better to use? If so, could you give me an example of how to get that trigger started??

 

I don't believe CASE can be used because the outcome depends on the value in two different fields. Please correct me if I am wrong.

 

IF(
AND( CONTAINS(Domain__c,"DK") , Account_Balance__c < 500),
"Prize Draw",
IF(AND(CONTAINS(Domain__c,"DK"), Account_Balance__c < 2000,Account_Balance__c > 499 ),
"25",
IF(AND(CONTAINS(Domain__c,"DK"), Account_Balance__c < 5000,Account_Balance__c > 1999 ),
"50",
IF(AND(Domain__c = "COM BR", Account_Balance__c < 3000,Account_Balance__c > 599 ),
"Prize Draw",
IF(AND(Domain__c = "COM BR", Account_Balance__c < 15000,Account_Balance__c > 2999 ),
"15",
"No Prize")))))

I have been working on a formula but I cannot make it without exceeding the compile limit. Shown below if a fraction of the formula. Do you know how I could reduce the compile size? Or do you know if a trigger would be better to use? If so, could you give me an example of how to get that trigger started??

 

IF(
AND( CONTAINS(Domain__c,"DK") , Account_Balance__c < 500),
"Prize Draw",
IF(AND(CONTAINS(Domain__c,"DK"), Account_Balance__c < 2000,Account_Balance__c > 499 ),
"25",
IF(AND(CONTAINS(Domain__c,"DK"), Account_Balance__c < 5000,Account_Balance__c > 1999 ),
"50",
IF(AND(Domain__c = "COM BR", Account_Balance__c < 3000,Account_Balance__c > 599 ),
"Prize Draw",
IF(AND(Domain__c = "COM BR", Account_Balance__c < 15000,Account_Balance__c > 2999 ),
"15",
"No Prize")))))

 

 

 

 

Select FieldA__c, Contact__c FROM Account WHERE Contact__c = '+123,+321,+456,+654,+789,+987,+741,+147' 

 

I cannot get any results. Can you please point me in the right direction?

Hi,

 

I did this years ago but cannot remember how. I want to have a tab called "Google" and within this tab the Salesforce user has the google website within Salesforce.

 

Does anyone have any idea how this can be done? Any ideas will be greatly appreciated.

 

Thanks!

Hi,

 

I want to run a query in Salesforce because I cannot get the result I want from reporting.

 

We have a Custom Object A. Object A is the master of Object B.

 

I want to get a list of all the records in object A that have no related records from Object B. Is that possible?

 

Regards,

 

HighPar

Hi,

 

I would like to create Web-to-Case in my Salesforce.com instance, from the web page hosted under my company's website. Is it possible to add an attachment too?

 

Any help would be greatly appreciated.

 

Thanks.

I have been working on a formula but I cannot make it without exceeding the compile limit. Shown below if a fraction of the formula. Do you know how I could reduce the compile size? Or do you know if a trigger would be better to use? If so, could you give me an example of how to get that trigger started??

 

I don't believe CASE can be used because the outcome depends on the value in two different fields. Please correct me if I am wrong.

 

IF(
AND( CONTAINS(Domain__c,"DK") , Account_Balance__c < 500),
"Prize Draw",
IF(AND(CONTAINS(Domain__c,"DK"), Account_Balance__c < 2000,Account_Balance__c > 499 ),
"25",
IF(AND(CONTAINS(Domain__c,"DK"), Account_Balance__c < 5000,Account_Balance__c > 1999 ),
"50",
IF(AND(Domain__c = "COM BR", Account_Balance__c < 3000,Account_Balance__c > 599 ),
"Prize Draw",
IF(AND(Domain__c = "COM BR", Account_Balance__c < 15000,Account_Balance__c > 2999 ),
"15",
"No Prize")))))

I have been working on a formula but I cannot make it without exceeding the compile limit. Shown below if a fraction of the formula. Do you know how I could reduce the compile size? Or do you know if a trigger would be better to use? If so, could you give me an example of how to get that trigger started??

 

IF(
AND( CONTAINS(Domain__c,"DK") , Account_Balance__c < 500),
"Prize Draw",
IF(AND(CONTAINS(Domain__c,"DK"), Account_Balance__c < 2000,Account_Balance__c > 499 ),
"25",
IF(AND(CONTAINS(Domain__c,"DK"), Account_Balance__c < 5000,Account_Balance__c > 1999 ),
"50",
IF(AND(Domain__c = "COM BR", Account_Balance__c < 3000,Account_Balance__c > 599 ),
"Prize Draw",
IF(AND(Domain__c = "COM BR", Account_Balance__c < 15000,Account_Balance__c > 2999 ),
"15",
"No Prize")))))

 

 

 

 

Select FieldA__c, Contact__c FROM Account WHERE Contact__c = '+123,+321,+456,+654,+789,+987,+741,+147' 

 

I cannot get any results. Can you please point me in the right direction?