Skip to main content Join us at TDX in San Francisco or on Salesforce+ on March 5-6 for the Developer Conference for the AI Agent Era. Register now.

Feed

Connect with fellow Trailblazers. Ask and answer questions to build your skills and network.

I'm attempting to make a report that shows us when we have more than 7 man crews on a job. I was able to make a summary formula that marks the ticket with a 1 if the crew is 6 or more. That part works great. However, I would like to add all the 1's created so get the sum of large crews. Salesforce just puts a 1 there currently. Clicking the top of the column doesn't give the option to sum it up. Does anyone know if there is a formula to get this sum.  

 

More importantly, I would like this number to be able to shown in a dashboard. Thanks in advance.

Summing a Summary Formula

 

#Reports & Dashboards

5 answers
  1. Today, 10:56 AM

    Hi Kevin,  

     

    A couple of options I can think of, if I understand correctly:  

     

    • Does each "job" have a record? If so, instead of the summary formula, filter the report to only show records that have 6+ crew, then you could add in the record ID and summarise the ID to see the total number of records. 

    OR

    • If this is something you'll want to track across multiple reports, you could create a custom formula field to indicate if a job has a crew of 6+. Then add this field to the report and summarise on that field. For example a custom checkbox called "Large Crew Number Job" which evaluates to TRUE if the number of crew is 6+. 

     

    Then, as you want to add this to a dashboard, you could add the dashboard tile and display a number as the total record count of "Large Crew Number Jobs".  

     

    Hope this helps! 

0/9000

Hello All, I tried adding branch protection rule in GITHUB but i am facing below error while promoting the WI:

remote: error: Changes must be made through a pull request.

To https://github.com/*******/DevOps.git

! [remote rejected]  MERGE -> MERGE (protected branch hook declined)

error: failed to push some refs to 'https://github.com/*******/DevOps.git'

2 answers
  1. Today, 10:52 AM

    Did you find an answer for that? I am also facing same issue, where my feature branch has approved pull request , but there is some kind of commit from target to target which is causing this same error.

0/9000

Hi all, I noticed that the Marzapps multi-picklist frequency app is no longer on the app exchange and you can't contact them directly so I guess they've gone out of business.  This was a free app that allowed us to do charts on multi-picklists.  Does anyone know if there's an alternative app in the appexchange that does something similar? 

 

#Salesforce Admin

 

 

#Reports & Dashboards

0/9000

Hi 

I have created a Chart below 

 

I am having a problem with Charts today - Y Axis - displays all field namesI have hidden the Row count, otherwise it displays on the report, but what I am getting frustrated at is that The Y axis shows Sum of Costing savings, sum of economic development, sum of Income generating whereas I just want it to say countchart properties.png

 

 

 

 

#Reports & Dashboards

0/9000

Have completed the Trailhead AI Associate course. Understanding the subject is one thing and prepping for exam is another. Are there any exam practice tests available? 

Is there anyone with AI Associate cert able to share their experience? Thanks in advance. 

 

#TrailblazerCommunityHelp

3 answers
  1. Manoj Nambirajan (Dell Technologies) Forum Ambassador
    Jan 27, 5:53 AM

    @Bobby S

    you can try below links for exposure to questions 

     

    https://www.saasguru.co/salesforce-certified-ai-associate-exam-practice-questions/?srsltid=AfmBOooETHvvsfp-XtFczYf7528_cHDdMytIe4Iy28CONVYmfvwKyTcL

     

    https://focusonforce.com/salesforce-ai-associate-certification-practice-quiz-and-sample-questions/

     

     

    Based on my experience.. Trailhead content is good enough of the exam as the questions would relate to the Trailhead content. 

     

    Good luck for the preparation and exam

0/9000

hi all,  

is it possible somehow to add to the custom formula selections from other lenses?  

 

Use selection from lens in custom formula

 

 

2 answers
  1. Today, 10:45 AM

    thank you a lot @Roman Michalik

     

    -

    Apply any additional calculations as required

    - where can I add it? 

    - I added this formula in advanced editor: 

      "formula": "Amount_Outstanding__c/{{coalesce(cell(lens_2.selection, 0, \"Unimpaired_Capital__c\"), 1).asString()}})" 

    but I have this error as a result: 

     

    thank you a lot - Apply any additional calculations as required - where can I add it? - I added this formula in advanced editor:

     

     

     

0/9000
0/9000

Hi!  In the org I am dealing with, in set up Trusted URL and Browser Policy Violations in All violations there is a list of  untrusted URL, for example : What does it mean and what to check/do? The org has docusign and portal, community and other integrations. 

Violations

 

hank you  

 

#Salesforce Developer  #Data Management  #Salesforce Admin

0/9000

Hi.   I have a strange issue. I have two objects  Object A and Object B.  Object B has a lookup field on Object A.    On Lightning Record page for Object A I have Related List Quick Links component.   I have Sys Admin profile and able to see Related List for Object B on Object A Lightning Record Page and have an access to Object B records.  But users with another Profile, let's say Member Profile, don't see Related list and don't have an access to Object B records.    Setup    Object A  - one Page Layout with Object B Related List  - this Page Layout is assigned to both Record Types for all Profiles  - on Member Profile  I have  such a permissions for Object A:  Read, Create, Edit, Delete, View All Records, Modify All Records    Object B  - object has one Page Layout  - object has only Master Record Type. I mean I didn't create any additional Record Types  - no Restriction Rules  - Sharing settings set to   Default Internal Access  -  | Public Read/Write  - Lookup field on Object A has Visible = true for Member Profile  - on Member Profile  I have  such a permissions for Object B:       Read, Create, Edit, Delete, View All Records, Modify All Records, View All Fields       All fields have Read Access    When user with Member Profile trying open Object B record by direct reference he sees such a message:  "This page isn't available in Salesforce Lightning Experience or mobile app."    What is the issue? Any thought..            

1 answer
  1. Today, 10:42 AM

    @Anton Korolkov It looks like you've covered most of the obvious permission-related settings, but here are a few things to check:

    1. Lightning Page Visibility & Related List Component
      • Go to the Lightning Record Page for Object A and check the component visibility settings for the "Related List Quick Links" component. Ensure it's not restricted to Sys Admins only.
      • Also, confirm that the Related List component for Object B is properly included in the layout and not hidden by any filters.
    2. Object B’s Tab Visibility
      • Go to Profiles > Member Profile > Object Settings > Object B and make sure the Tab Visibility is set to “Default On” instead of “Hidden.”
    3. Record-Level Access & Field-Level Security
      1. Even though you’ve granted “View All Records” and “Modify All Records,” confirm that all fields on Object B are visible to the profile.
    4. Lightning Access Issues
      • The error message: "This page isn't available in Salesforce Lightning Experience or mobile app." could indicate that the Member Profile does not have access to Lightning pages for Object B.
      • Go to Setup > Object Manager > Object B > Lightning Record Pages and check if the correct Lightning page is assigned for the Member Profile.
    5. Permission Sets or Profile Restrictions
      • If the profile permissions look correct, check if any Permission Sets or Login Restrictions are limiting Object B’s access.
      • Go to Setup > Users > Member Profile > Permission Sets and see if there are any conflicting permissions.
    6. Try Classic UI
      • Ask a Member Profile user to switch to Classic and try accessing Object B. If they can see the records there but not in Lightning, the issue is likely Lightning Experience-specific visibility settings.

    If none of these resolve the issue, try cloning the Sys Admin profile, assign it to a test user, and see if they can access Object B. If they can, the issue is somewhere in the profile settings. Let me know what you find! 

0/9000

like i am a fullstack developer in nodejs or react many other technology , and to be honest i where i should start from admin or developer like apex developer .

2 answers
  1. Feb 24, 3:28 PM

    Hi @Rajat kumar Jena

     

    Welcome to the Salesforce Ohana! 

    You can take a look at the career paths: 

      

    For admin you can start with: 

     

    For developer certifications available: 

     

    Once you click on a specific certification, you can find the trailhead content (multiple trails) and additional resources to help you get more information and insights about the Salesforce ecosystem.  

     

    Good luck!  

     

    Ana

0/9000