Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Best Answer chosen by Nazia Syed
Kapil BatraKapil Batra
Please try this
SuppliedEmail = 'Email Address1,Email Address2'
Emily ScothernEmily Scothern 
i have a lightning page layout and in my sandbox i was able to add the 'new' action when clicking on the arrow in the image, however now when trying to make this change in live i cannot remember how it was done.
This is on the Dispute Case page layout - i need the user to be able to make a new dispute from the arrow 
User-added image
Best Answer chosen by Emily Scothern
Ouassim KACI MAHAMMEDOuassim KACI MAHAMMED

Hi Emily,

I gave you a solution yesterday, did it work ?

Solution link https://trailblazers.salesforce.com/answers?id=9064S000000DMw0QAG

 

Pranil SarodePranil Sarode 
Hi,
I'm getting below error in query,

        tc = [SELECT id,Name,CurrencyIsoCode,X2nd_Bkg_No__c,X2nd_Do__c,Date__c,Delivery_Note_Date__c,Delivery_Note_No__c,Expected_Date_of_Return__c,Final_Status__c,GRV_No__c,If_Renewed_Bkg_Date__c,If_Renewed_Bkg_No__c,Name__c,New_Date_for_Return__c,Plant__c,Purpose_of_Use__c,Reason_for_Retention__c,Renewal_Requested_on__c,SLOC__c,Staff_No__c,(SELECT id,Model__c,CurrencyIsoCode,Quantity__c,Return_Date__c,SAP_Booking_No__c,name FROM Sample_Goods_Order_and_Return_Line_Item__r ) FROM Sample_Goods__c  where ID =: id];


ERROR - 
Didn't understand relationship 'Sample_Goods_Order_and_Return_Line_Item__r' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names..


User-added image
User-added image

Please help.
Thanks in advance
Best Answer chosen by Pranil Sarode
Karan KeharKaran Kehar
Hi Pranil,

The issue here is with the child relationship name for Sample Goods Order and Return Line Item. Can you open the Sample Goods parent field on the Sample Goods Order and Return Line Item  object and see what is the child relationship name. Use that and append it with __r.
Ragavendiran GRagavendiran G 
Hi Team,

I have a requirement to autopopulate 2 object local below are the requirement.

There are 3 objects below are the detail.
1.) Advertiser__c
2.) Account
3.) Brand__c

When Advertiser__c record create we have 2 lookup field one is Account and another is Brand__c both object have local picklist field, we need to populate the Account and Brand local in Advertiser__c object.

The formula field should look up to Local__c on Account (If Account__r.Local__c is not NULL) ELSE fetch Local__c on Brand [Brand__r.Local__c].

Can anyone suggest the syntax format?

Thanks,
Best Answer chosen by Ragavendiran G
Amnon KruviAmnon Kruvi
Try:
BLANKVALUE(TEXT(Account__r.Local__c), TEXT(Brand__r.Local__c))
Alistair ArkwrightAlistair Arkwright 
I have a section on our Opportunity that creates a Text formula based on if a box in column A is ticked and the same box in column B is not. 

For example, if we request Item 1, we tick the first box, and we don't tick the second box until we receive Item 1. This formula field creates an easy to read list of items that are outstanding, so that I can pull it into email notifications.

The formula has a load of code, but this one is creating a line break when I want it to be NULL. 
 
IF( NOT(ISBLANK(TEXT( Requested_Proof_of_ID__c))) &&  Received_Proof_of_ID__c = true , "", TEXT(Requested_Proof_of_ID__c) + BR()) &
Does anyone have any idea to make it so that when the IF statement equals TRUE, the formula just create a null and not a line break? I only want the line break if the formula equals FALSE and puts the TEXT() in. 
Best Answer chosen by Alistair Arkwright
Alistair ArkwrightAlistair Arkwright
OMG thank you Kapil! You made me realise that, yes, my code was ALWAYS false, even when it met true. I rewrote the code to the below, and it works now. I think my brain just turned off for a minute there!
 
IF((NOT(ISPICKVAL( Requested_Proof_of_ID__c , "" )) && Received_Proof_of_ID__c = false) , TEXT(Requested_Proof_of_ID__c)+ BR(), NULL) &

 
Jessica EaganJessica Eagan 
Hello!  I have a formula I am trying to create that counts all the numbers in these fields (numbers range from 0-2) and display them in this new field.

Lead_Grading_Company__c +  Lead_Grading_Country__c +  Lead_Grading_Email__c +  Lead_Grading_Employee_Count__c +  Lead_Grading_Industry__c +  Lead_Grading_Name__c +  Lead_Grading_Title__c +  Lead_Grading_Zoominfo_ID__c

However I am getting this error which makes no sense to me in this case.  Any ideas??

Error: Compiled formula is too big to execute (8,193 characters). Maximum size is 5,000 characters
Best Answer chosen by Jessica Eagan
Ankush AgarwalAnkush Agarwal
Hi,

Fields used in this formula could be formula fields and having big formula. All the formulas are getting accumulated in this formula and crossing the limit of 5000 characters. You may refer below article to reduce the fomrula size:

https://developer.salesforce.com/docs/atlas.en-us.216.0.salesforce_formula_size_tipsheet.meta/salesforce_formula_size_tipsheet/formula_size_tipsheet_intro.htm
Magaly CanoMagaly Cano 
Hi!

I am creating a report to show new donors the past three years. The formula field "First Pledge Date or First Payment Date" is being used to determine the contacts. The formula is written as
IF( First_Payment_Date__c < First_Pledge_Date__c , First_Payment_Date__c,First_Pledge_Date__c).
I noticed that when the field "First Pledge Date" is empty the formula is not populating the First Payment Date instead. All of this is being done in the object Account. How can I make sure the formula is populating the first payment date if the first pledge date is empty?
Best Answer chosen by Magaly Cano
Ankush AgarwalAnkush Agarwal
minor update:

Please use below formula:

IF(OR(ISBLANK(First_Pledge_Date__c ), First_Payment_Date__c < First_Pledge_Date__c),  
First_Payment_Date__c,
First_Pledge_Date__c
)
Joe SpiwakJoe Spiwak 
Hey All,

I am trying to complete the last section on the "AppExchange Basics" badge. In the third section "Install AppExchange Packages (Also Like a Superhero)" it asks you to install a package from AppExchange called "Adoption Dashboards app," and despite following all the instructions I get the same error every time I  attempt the instal;:

Package Not Found   The requested package doesn't yet exist or has been deleted. If this is a recently created package version, please try again in a few minutes or contact the package publisher.

Am I doing something wrong, or is there a backend issue thats beyond my control?
Best Answer chosen by Joe Spiwak
Jonathan FoxJonathan Fox
Hey!

This is a known issue and the Trailhead team are dealing with it, however feel free to raise a case with them to track what is happenign with it.
Katherine WestKatherine West 
I just installed the Flow Datagrid Pack from Salesforce Labs to use in some custom flows. I'm using the datatable screen element. I've gotten it all set up to show the records I want it to show. However, I don't seem to be able to get the selected IDs to use later in the flow.

As mentioned in the setup article, I've added a text collection variable to the Selected Ids (Output) field in the screen setup. It just never gets updated. I can see in the flow debug output that the selected ids are stored in a variable for that screen, but I can't access that variable and my variable that I set up to receive them is always null.

Does anyone have any ideas on how to fix this?
Best Answer chosen by Katherine West
Katherine WestKatherine West
Well, after further exploration it looks like you can reference the output information by assigning it manually to a record collection variable (in the assigment action, you look for the screen name of the screen that has the datatable and inside the screen is a variable "lstSelectedIds" that stores the selected ids). You can then use that record collection variable to perform actions on the selected contact. However, the option to assign to a record collection variable from the Flow Datagrid Pack action itself doesn't seem to work at all (event though the instructions say it does).
Abbie RashidAbbie Rashid 
Hi, The planned_implementation_date__c needs to be at least 3 working days after the request_date__c

Please can anyone help me with the validation rule? It seems to be more complicated than I thought it would be.

Thanks
Best Answer chosen by Abbie Rashid
Steve MolisSteve Molis
Are you looking for something like this?
 
planned_implementation_date__c < 
( 
request_date__c + 
CASE(WEEKDAY(request_date__c),
1,3,
2,3,
3,3,
4,5,
5,5,
6,5,
7,4,
0)
)

​​​​​​​