• Aceldama
  • NEWBIE
  • 25 Points
  • Member since 2012

  • Chatter
    Feed
  • 1
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 14
    Questions
  • 10
    Replies
I'm volunteering as an SFDC admin for a non-profit.  We are using the "Volunteers for Salesforce" package and I've been building out some of the web sign-up pages.  

I had the JobCalendar page set up, but they want to show more job listing details when someone clicks on a job in the calendar.  When I follow the instructions on how to add more fields, it assumes I am linking directly to the 
VolunteerJobListing page, NOT the JobCalendar page.  

Does anyone know how to add more job listing fields from the JobCalendar page?  Is it even possible?

Per the instructions (https://powerofus.force.com/servlet/fileField?retURL=%2Farticles%2FResource%2FVolunteers-for-Salesforce-Setup-and-Configuration-Guide&entityId=ka0800000000Nt6AAE&field=File__Body__s):

Use one or more of these optional URL parameters in your IFRAME tag to further customize how Jobs and Shifts are displayed in the job listing, regardless of whether you’re using VolunteersJobListing or VolunteersJobListingFS. Add parameter names and values to the end of the URL in your IFRAME tag. Remember to: • Use a ? character to separate the first parameter from the rest of the URL. • Use an & character to separate each parameter.
 
Hi all!  Having trouble with a formula field that is being calculated from the values in two other fields.  I've only gotten through one half of this request and already up to 3k characters, so no way I can get this to work.

Field 3 is calculated from the values present in Field 1 and 2.  Fields 1 and 2 are picklists.  The requirement is that we calculate the value for Field 3 as follows:

If Field 1 = 1,2,3,4,5 and Field 2 =1,2,3,4,5  then Field 3 = Value 1
If Field 1 = 1,2,3,4,5 and Field 2 =6,7,8,9,10 then Field 3 = Value 1
If Field 1 = 6,7,8,9, or 10 and Field 2 =1,2,3,4 5 then Field 3 = Value 1
If Field 1 = 6,7,8,9, or 10 and Field 2 =6,7,8,9,10 then Field 3 = Value 1

Here is what I was doing:
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"5")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"5")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"5")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"5")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"5")),"Value 1", 
"Not Defined" 
)))))))))))))))))))))))))
We have implemented a Case process between system teams and want to ensure that certain Case types have a corresponding Related Case.  I need to build out a report to identify Cases that do NOT have a related Case.  Easy enough to report on Cases WITH Related Case information, but the opposite is causing a bit of a problem.

Anyone tackled this issue before? 
Hi all.  Was wondering if any of you are using Territory Management software?  Need something to help with modeling different scenarios using Lead, Opp, and a Custom object (for green-field) accounts we are not prospecting to currently.  Need something where I can dump production data, then model state, industry, territory changes and present them side by side.
We need to begin controlling Knowledge Articles by Data Category. Anyone have experience on using Roles vs. Profiles? Our idea is to strip access from Roles and provide access via the Profile settings. Any pitfalls?

Hi everyone.  Wanted to know if anyone has moved Content from a Library to the Chatter feed of an object.  Need to move several hundred pieces of content without downloading, then re-loading as a Chatter feed item in the host object (Account).

Hello!  I have two WF that trigger the same Email Alert notifying our support team when a new Critical case is created during the weekend and after hours.   I now have a 3rd requirement and don't want to increase the noise be introducing a 3rd WF email alert.  I'm trying to combine these into a single formula WF:

 

First WF:  Rule Criteria = (Case: Hour CreatedEQUALS0,1,2,3,4,5,17,18,19,20,21,22,23,24) AND (Case: PriorityEQUALSCritical)

2nd WF:  Rule Criteria = (Case: Case Creation DayEQUALSSaturday,Sunday) AND (Case: PriorityEQUALSCritical)

3rd WF (new):  This new WF will need fire off when a Critical case is created during a Company Holiday:

 

Here is the formula that I worked up, but it keeps telling me I'm missing a ")" somewhere:

 

IF(AND(ISPICKVAL(Priority,"Critical"),
OR (Hour_Created__c,"0",
Hour_Created__c,"1",
Hour_Created__c,"2",
Hour_Created__c,"3",
Hour_Created__c,"4",
Hour_Created__c,"5",
Hour_Created__c,"17",
Hour_Created__c,"18",
Hour_Created__c,"19",
Hour_Created__c,"20",
Hour_Created__c,"21",
Hour_Created__c,"22",
Hour_Created__c,"23",
Hour_Created__c,"24"))),True,

 

IF(AND(ISPICKVAL(Priority,"Critical"),
OR (Case_Creation_Day__c,"Saturday",
Case_Creation_Day__c,"Sunday"))), True,

 

IF(AND(ISPICKVAL(Priority,"Critical"),
OR (CreatedDate ,"2013,09,2",
CreatedDate ,"2013,11,28",
CreatedDate ,"2013,11,29",
CreatedDate ,"2013,12,24",
CreatedDate ,"2013,12,25",
CreatedDate ,"2014,01,01"))),True,False))

 

Hello all.  I have formula I am trying to work out.  We want to display a section in a VF template only during certain dates so that we don't need to log in and alter the VF email template over the weekend.

 

I've got it to work with the help of a colleague, but not exactly optimal:

{!IF(TODAY()<DATE(2013,07,06),true,false)}">"My Message"</apex:outputtext>

 

What I'd really like to do is this, but keep getting errors with extra ",":

{!IF((OR(TODAY()=DATE(2013,07,03)),(TODAY()=DATE(2013,07,04)),(TODAY()=DATE(2013,07,05))),true,false)}</apex:outputtext>

 

Any help?

Hi!  I am trying to get me org ready for a server change and am trying to make my buttons domain independent.  For instance, I have a button that references a URL:

 

Button URL:  https://mkto-si.na0.visual.force.com/apex/mkto_si__Send_Marketo_Email?contactType=Lead&amp;contactIds={!Lead.Id}

 

I will no longer be on server na0.  How do I make this button work regardless of the domail?  I tried the following to no avail:

.../apex/mkto_si__Send_Marketo_Email?contactType=Lead&amp;contactIds={!Lead.Id}

apex/mkto_si__Send_Marketo_Email?contactType=Lead&amp;contactIds={!Lead.Id}

 

Nothing seems to work.

Hi.  Our Salesforce.com org is on NA0 and we've had some issues with special characters appearing on our text fields.  Salesforce's solution is an offer to move us to a new server.  Anyone gone through this?  I'd love to hear about your experience.  I know we have to change any referenced links to the NA0 URL, but anything else we should be looking into?

 

Aceldama

Having issues getting a VR to work.  I'm trying to force that all entries start with http:// or https:// in both lower and upper case:

 

OR (
NOT(BEGINS(Course_Information__c,"http")),
NOT(BEGINS(Course_Information__c,"https")),
NOT(BEGINS(Course_Information__c,"HTTP")),
NOT(BEGINS(Course_Information__c,"HTTPS"))
)

 

Only thing that works is using it a single time:

NOT(BEGINS(Course_Information__c,"http"))

We have a few new Windows 8 machines at our company and we are running into issues installing Salesforce for Outlook (2007).  The software installs, and items can sync, but the add-ins do not launch.    

 

They do not appear under Help > Disabled Items....  

 

They are listed as disabled under Tools > Trust Center > Add-ins > Manage COM Add-ins, but get the following message:  "This add-in is installed for all users on this computer, and can only be connected or disconnect by an administrator".  If I log in as an admin, I can activate these add-ins, but they keep reverting back to disabled and the message when try to activate this is not:  "Not Loaded.  The Managed Add-in Loader failed to initialize."

 

Not sure if this is related, but after installing and starting the application, if I right click and hit settings, I received two script errors:

https://ssl.salesforce.com/jslibrary/1360895802000/sfdc/Security.js

and then

https://ssl.salesforce.com/secur/frontdoor.jsp?sid=ORGIDGOESHERE%21ARMAQIT9SNoFN9q8wcqtr1sKaBYXQz.JTEDaCZrbznF9sb

We have a visual force page that is showing odd characters like "Ã?Â" and "Â" in a rich text area field and also in the Chatter feed. 

 

Anyone encounter this issue in their org?

 

Jose

I'm mass adding user to several Chatter groups, but management doesn't want an email going out to the end users notifying them.  They want to send a personal invite from our VP.  

 

How do you shut this off?

 

Jose

We need to begin controlling Knowledge Articles by Data Category. Anyone have experience on using Roles vs. Profiles? Our idea is to strip access from Roles and provide access via the Profile settings. Any pitfalls?
I'm volunteering as an SFDC admin for a non-profit.  We are using the "Volunteers for Salesforce" package and I've been building out some of the web sign-up pages.  

I had the JobCalendar page set up, but they want to show more job listing details when someone clicks on a job in the calendar.  When I follow the instructions on how to add more fields, it assumes I am linking directly to the 
VolunteerJobListing page, NOT the JobCalendar page.  

Does anyone know how to add more job listing fields from the JobCalendar page?  Is it even possible?

Per the instructions (https://powerofus.force.com/servlet/fileField?retURL=%2Farticles%2FResource%2FVolunteers-for-Salesforce-Setup-and-Configuration-Guide&entityId=ka0800000000Nt6AAE&field=File__Body__s):

Use one or more of these optional URL parameters in your IFRAME tag to further customize how Jobs and Shifts are displayed in the job listing, regardless of whether you’re using VolunteersJobListing or VolunteersJobListingFS. Add parameter names and values to the end of the URL in your IFRAME tag. Remember to: • Use a ? character to separate the first parameter from the rest of the URL. • Use an & character to separate each parameter.
 
Hi all!  Having trouble with a formula field that is being calculated from the values in two other fields.  I've only gotten through one half of this request and already up to 3k characters, so no way I can get this to work.

Field 3 is calculated from the values present in Field 1 and 2.  Fields 1 and 2 are picklists.  The requirement is that we calculate the value for Field 3 as follows:

If Field 1 = 1,2,3,4,5 and Field 2 =1,2,3,4,5  then Field 3 = Value 1
If Field 1 = 1,2,3,4,5 and Field 2 =6,7,8,9,10 then Field 3 = Value 1
If Field 1 = 6,7,8,9, or 10 and Field 2 =1,2,3,4 5 then Field 3 = Value 1
If Field 1 = 6,7,8,9, or 10 and Field 2 =6,7,8,9,10 then Field 3 = Value 1

Here is what I was doing:
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"1"),ISPICKVAL(Field 2,"5")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"2"),ISPICKVAL(Field 2,"5")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"3"),ISPICKVAL(Field 2,"5")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"4"),ISPICKVAL(Field 2,"5")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"1")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"2")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"3")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"4")),"Value 1", 
IF(AND(ISPICKVAL(Field 1,"5"),ISPICKVAL(Field 2,"5")),"Value 1", 
"Not Defined" 
)))))))))))))))))))))))))

Hi!  I am trying to get me org ready for a server change and am trying to make my buttons domain independent.  For instance, I have a button that references a URL:

 

Button URL:  https://mkto-si.na0.visual.force.com/apex/mkto_si__Send_Marketo_Email?contactType=Lead&amp;contactIds={!Lead.Id}

 

I will no longer be on server na0.  How do I make this button work regardless of the domail?  I tried the following to no avail:

.../apex/mkto_si__Send_Marketo_Email?contactType=Lead&amp;contactIds={!Lead.Id}

apex/mkto_si__Send_Marketo_Email?contactType=Lead&amp;contactIds={!Lead.Id}

 

Nothing seems to work.

Having issues getting a VR to work.  I'm trying to force that all entries start with http:// or https:// in both lower and upper case:

 

OR (
NOT(BEGINS(Course_Information__c,"http")),
NOT(BEGINS(Course_Information__c,"https")),
NOT(BEGINS(Course_Information__c,"HTTP")),
NOT(BEGINS(Course_Information__c,"HTTPS"))
)

 

Only thing that works is using it a single time:

NOT(BEGINS(Course_Information__c,"http"))

We have a few new Windows 8 machines at our company and we are running into issues installing Salesforce for Outlook (2007).  The software installs, and items can sync, but the add-ins do not launch.    

 

They do not appear under Help > Disabled Items....  

 

They are listed as disabled under Tools > Trust Center > Add-ins > Manage COM Add-ins, but get the following message:  "This add-in is installed for all users on this computer, and can only be connected or disconnect by an administrator".  If I log in as an admin, I can activate these add-ins, but they keep reverting back to disabled and the message when try to activate this is not:  "Not Loaded.  The Managed Add-in Loader failed to initialize."

 

Not sure if this is related, but after installing and starting the application, if I right click and hit settings, I received two script errors:

https://ssl.salesforce.com/jslibrary/1360895802000/sfdc/Security.js

and then

https://ssl.salesforce.com/secur/frontdoor.jsp?sid=ORGIDGOESHERE%21ARMAQIT9SNoFN9q8wcqtr1sKaBYXQz.JTEDaCZrbznF9sb

We have a visual force page that is showing odd characters like "Ã?Â" and "Â" in a rich text area field and also in the Chatter feed. 

 

Anyone encounter this issue in their org?

 

Jose

I'm mass adding user to several Chatter groups, but management doesn't want an email going out to the end users notifying them.  They want to send a personal invite from our VP.  

 

How do you shut this off?

 

Jose