Feed

Hi  

I'm having trouble trying to mass delete vendor service to vendor service dependencies using DataLoader. I can't seem to find the right ID field as neither of these work: 

•  Vendor Service Vendor Service Dep. ID (e.g. a2yDS000009yWct). 
  • I get a this error: "invalid cross reference id"
•  Vendor Service Vendor Service Dep. Name (e.g. VSVSD-0010). 
  • I get this error: "bad id VSVSD-0010"

I feel like I must be missing the wrong ID field to match on but I don't know what it could be.  

Does anyone know how to do this? 

Thanks 

Hi All,   How is it even possible that I'm getting a syntax error in the Flow Transform element? The only thing the error message says is "Syntax error: Found 'NameOfCollection'". All it does is sum a currency field from a collection of "GetRecords" where it's set to get all records and automatically store all fields.   what could possibly be causing this error?   

Hello,    We have Omni Supervisor enabled and we've added the tab called "Team Schedule". Can the Supervisor change/edit the team schedule for an agent? If, how can this be accomplished?    Thanks   

Hello.. I'm struggling with the datatable element trying to put something other than '{records}'. 

I have a JSON that has two nodes (rough example below), one with returned permissions (for controlling actions on the flexcard called "perms") and a second node that has the list of records I want to display in the table, "recordList".. What is the syntax/value I need to put in the 'Records' field on the datatable properties to select "recordList" to display in the table? I've tried things like {records.recordList}  

{record.recordList} 

[record][recordList] 

[recordList]...

{ "perms":{   "perm1":true,   "perm2":false  }, "recordList":[  {   "field1":"value",   "field2":"value"  },  {   "field1":"value",   "field2":"value"  } ]}

Hi,  New omni channel. Not sure what permissions to tweak in order to load Omni Channel Wallboard for particualr profile users. At the moment on loading it throws error saying "  We can’t load your metrics. Wait a few minutes, then reload the wallboard" 

We are a nonprofit that implements clean water projects in Asia and Africa. We have been using google sheets to keep track of our projects for years and are moving towards housing our Project Master List in Salesforce. I am 90% to where I need to be but I need help setting up one last piece to our puzzle.    With google sheets, we have been using numbers to indicate the order in which the projects need to be completed. We never sort the sheets, so it's easy to keep them in the correct order. But with Salesforce, we need to lock in the completion number with a field. I have done this, but what we are lacking is the ability to easily reorder or reprioritize. With google sheets, it's as easy as inserting a new line above and cutting and pasting the numbers to change the order (see Loom 2 below for visual on this).    I have created two Loom videos to further explain visually.  Loom 1: https://www.loom.com/share/e640a792d94f4f418c76452fa182574d?sid=39675cd1-e0fc-43a2-8a12-e871710b56d2    Loom 2: https://www.loom.com/share/ec5f34685efc4cc496dcc87414538370?sid=b3e03cd4-ab68-4587-b47d-e300778c69be    

Hi everyone,

I'm working on a workflow where I have two queries, r and q, and I need to add the value improd from query r as a new column to all rows of query q.

Here is a simplified version of my code:

-- Query r: compute improdr = load "DataImprod";r = filter r by 'Date__c' in ["current year".."current year"];r = group r by all;r = foreach r generate         sum(r.'JoursHorsMission__c') as 'A',         sum(r.'JoursMission__c') as 'B',         sum(r.'Jours_Gratuit__c') as 'E';r = foreach r generate         A/(A+B+E) as ‘improd’;

q = load "DataTimesheets";q = filter q by 'Date__c' in {{cell(static_100.selection, 0, "Date").asString()}};q = group q by rollup('LeaderBusiness.Name',                       'ProprietaireOpport.Name',                       'Account.Name',                       'Mission.Name',                       'RelCommNew.Name',                       'Opportunite.MissionEnDispositif__c',                       'Mission.Localisation__c',                       'Opportunite.NewOrigineOpportunite__c_formula',                       quarter('Date__c'));q = foreach q generate q.'LeaderBusiness.Name' as 'Leader Business',                        q.'ProprietaireOpport.Name' as 'Propriétaire',                        q.'Account.Name' as 'Account.Name',                        q.'Mission.Name' as 'Mission.Name',                        q.'RelCommNew.Name' as 'Relation Commerciale',                       q.'Opportunite.MissionEnDispositif__c' as 'Opportunite.MissionEnDispositif__c',                        q.'Mission.Localisation__c' as 'Mission.Localisation__c',                        q.'Opportunite.NewOrigineOpportunite__c_formula' as 'Origine Opportunité',                        quarter(q.'Date__c') as 'Trimestre',                        sum(q.'CAnew') as 'CA',                        sum(q.'CoutNew') as 'Coût',                        grouping(q.'LeaderBusiness.Name') as 'grouping_LeaderBusiness.Name',                        grouping(q.'ProprietaireOpport.Name') as 'grouping_ProprietaireOpport.Name',                        grouping(q.'Account.Name') as 'grouping_Account.Name',                        grouping(q.'Mission.Name') as 'grouping_Mission.Name',                        grouping(q.'RelCommNew.Name') as 'grouping_RelCommNew.Name',                        grouping(q.'Opportunite.MissionEnDispositif__c') as 'grouping_Opportunite.MissionEnDispositif__c',                        grouping(q.'Mission.Localisation__c') as 'grouping_Mission.Localisation__c',                        grouping(q.'Opportunite.NewOrigineOpportunite__c_formula') as 'grouping_Opportunite.NewOrigineOpportunite__c_formula',                        grouping(quarter(q.'Date__c')) as 'grouping_quarter_Date__c';s = filter q by 'grouping_LeaderBusiness.Name' == 1;q = filter q by 'grouping_LeaderBusiness.Name' == 0 and                 'grouping_ProprietaireOpport.Name' == 0 and                 'grouping_Account.Name' == 0 and                 'grouping_Mission.Name' == 0 and                 'grouping_RelCommNew.Name' == 0 and                 'grouping_Opportunite.MissionEnDispositif__c' == 0 and                 'grouping_Mission.Localisation__c' == 0 and                 'grouping_Opportunite.NewOrigineOpportunite__c_formula' == 0 and                 'grouping_quarter_Date__c' == 0;q = limit q 2000;q = union q, s;q = limit q 2001;

I tried join, cogroup, union but nothing seems to fit my need.  

Does anyone know the right way to do this ?

Thanks in advance for any help! 🙏 

@* CRM Analytics (fka Tableau CRM) *

Current code is: 

 <table width="100%" font-family="'Montserrat', Light" font-size="10px" color="

#504F5B

"> 

                <table-column column-width="72%" /> 

                <table-column column-width="14%" /> 

                <table-column column-width="14%" /> 

                <table-body> 

                    <apex:outputText rendered="{!NOT(ISBLANK(line.Additional_Notes__c))}"> 

                     <table-row> 

                            <table-cell> 

                                <block> 

                                    {!line.Additional_Notes__c} 

                                </block> 

                            </table-cell> 

                            <table-cell> 

                                <block></block> 

                            </table-cell> 

                            <table-cell> 

                                <block></block> 

                            </table-cell> 

                        </table-row> 

                    </apex:outputText> 

The output shows as:  

Lead Time: 12 - 14 weeks# 

# 

Specification:# 

I need to remove the # please?

@* Salesforce Developers * 

Hi all. I've taken and failed the Advanced Field Service Accredited Professional exam, and was wanting to see if anybody had any recommendations for what specifically to study to better prepare for it, and what resources to use. I've been through the course in the Partner Learning Camp, so I'm hoping to find other resources. 

Thanks in advance for any help/advice.