Feed

@Salesforce Flow Automation 

I have the following scenario: 

If contract <$1000 then insurance $25 

if contract >$1000 and <$5000 then insurance $35 

if contract >$5001 and <$12500 then insurance $45  

if contract >$125001 and <$20000 then insurance $55    

if contract >$20001 and <$40000 then insurance $95   

if contract >$50001 and <$75000 then insurance $170    

I cannot get the nestled formulas right to save my life. Any and all help is appreciated.  

Hello,

I'm currently working on generating a report utilizing the Asset object for our Community users. However, upon their attempt to access the report, they encounter an error message indicating a lack of permission to view it. Interestingly, these users do possess the necessary access permissions to the Asset object itself.

I initially configured the Asset object's sharing settings as "Public Read Only" in the Organization-Wide Defaults (OWD). However, as a troubleshooting step, I temporarily adjusted it to "Private." Subsequently, the users were able to view the report without encountering any permission issues.

While this resolved the immediate problem, it's imperative to maintain the Asset object with "Public Read Only" settings for broader access. Hence, I'm seeking guidance on enabling users to view the report while retaining the object's public access configuration. Any insights or alternative approaches to achieve this alignment would be greatly appreciated.

Thank you.

#Trailhead Challenges

These are my salesforce connected orgs, even then I'm not able to connect to my appexhange

I have the following script: 

%dw 2.0 

input records application/csv 

output application/apex 

--- 

records map(record) -> { 

 IVP_First_Name__c: record.'First Name*', 

 IVP_Last_Name__c: record.'Last Name*', 

 IVP_Middle_Name__c: record.'Middle Name', 

 IVP_Date_of_Birth__c: record.'DOB*' as Date{format : "M/d/yyyy"}, 

... 

This works fine except when there is no date entered on the CSV. It just throws an obscure error message and I cannot get into the results to make any changes. The response just shows commas for missing data like  JOE,,,,TRUE 

  Is there a way I can define a default value or 'null' for the date in my script above? 

Thanks.

#Trailhead Challenges

Hi everyone – has anyone had success reporting on campaign performance (e.g. open rate, click rate, bounce rate) using Marketing Foundations? I'm having some difficulty on which objects/reports to work with and wondering if others have found effective workarounds or supplementary tools. Thus far I've been working with the Bulk Email Message with Email Engagement report type. I can get a decent report visually but can't find out a way to create a summary formula for open rates etc.   

Would love to hear what’s worked (or hasn’t) for you. Thanks in advance!    

@* Marketing Cloud コミュニティ 日本 * 

I'm currently working on a Flow that counts the number of records created today, in the last 3 days, and in the last 7 days

. 

To start, I created a Flow that retrieves all the Call records logged through the "Log a Call" button and stores the number of calls made today in the "Calls Today"

field. 

I also created two formula resources: one to get the start of today, and another to get the start of tomorrow. In the Flow, I use these to filter records where the CreatedDate is greater than or equal to the today variable and less than the tomorrow

variable. 

My today formula: 

DATETIMEVALUE(TEXT(TODAY())) 

My tomorrow formula: 

DATETIMEVALUE(TEXT(TODAY() + 1) ) 

So i put this conditions: 

However when I test my flow, it is saying that it can't find the value 

Can you guys give me some light of what I'm doing wrong? 

Hi,

I’m currently working on the "Organization-Wide Defaults" challenge in the Salesforce Admin Beginner Trailhead module.

I’ve set the organization-wide default sharing settings as follows:

• Account and Contract: Public Read Only (Grant Access Using Hierarchies checked).
• Opportunity: Private (Grant Access Using Hierarchies checked).

However, I’m getting the error: 

I’ve reviewed my settings multiple times, but I’m still unable to pass the challenge. Could you help me troubleshoot what might be wrong?

Thank you for your time!