Flow: Retrieve urls of uploaded files in standard object and update a field in custom object for Platform Salesforce license

Use case: Platform license users have no visibility to view Opportunity and its child object's records (S object) and files. E object is a custom object that has look up fields to Scope and Opportunity.

Object structure:

1Oppt - mScope
1Scope - mE.

The purpose is to get the urls of files in Scope object and update in a field of E object after those files were shared to Platform license user group.

1. Get parent record through input variable (if we use it in process builder)

2. To get ContentDocmentLink in parent object (Oppty or Scope in this case), we check LinkedEntityId equals parent object id.

3. Check if there is any doc is found. If yes, loop and get all urls, otherwise exit the flow or notify user through screen.

4. Loop each element

5. Create a formula for document url and assign values

6. Add each element to a collection

7. Assign url to a field in a child object (E object) and create/update record of E object.

Comments

The flow failed to access the value because it hasn't been set or assigned error

I'm sure that many Salesforce admin already encountered the this Process builder error when building automation referencing a field on a related record (aka lookup field): ' The flow failed to access the value because it hasn't been set or assigned ' and came across this Salesforce document . However, it does not help in case of referencing a User lookup field. ------------------------------- Use case: when a lead's ownership is transferred to another user, respective fields are updated based on their profile. Error element myDecision (FlowDecision). The flow failed to access the value for myVariable_current.Owner:User.ProfileId because it hasn't been set or assigned. --------------------------- Workaround: Have a condition to check if the record is assigned to a user or a queue before checking their profile id for respective actions. Records owned by user: BEGINS([Lead].OwnerId, "005") Records owned by queue: BEGINS([Lead].Owne...

Salesforce campaign model and tracking

Salesforce campaign tracking Check out the great article on Campaign tracking use case: https://www.salesforce.com/blog/track-salesforce-campaign-shadow-wolf-blog/ There are 2 ways to track Campaign ROI . Campaign Influence ( custom model ) Associate multiple Campaigns to multiple Opportunities (and multiple Opportunities to a Campaign) using the Contact Role . To get a broader view of opportunity pipeline, generate the standard report called Campaigns with Influenced Opportunities (Customizable Campaign Influence). This report provides opportunity data, such as amount, stage, and revenue share alongside helpful campaign details. For more control, build custom reports that show relationships such as these examples. • Campaigns with Influenced Opportunities • Contacts with Campaign Influence • Accounts with Campaign Influence If there is only one campaign associated with each opportunity ...

Renewable vs Evergreen Subscription type

Renewal: Renewable products transfer to renewal quotes. Standard renewable contracts have end dates, terms, and an option to renew. Evergreen: don't have any end dates and, therefore, don't need to be renewed. This supports an open-ended term of service that allows for customers or providers to cancel or terminate the subscription at any point. Evergreen and Renewable products can’t coexist in a bundle. Guidelines for Evergreen Subscriptions: https://help.salesforce.com/s/articleView?id=sf.cpq_evergreen_limitations.htm&type=5 Quote and Manage Evergreen Subscriptions: https://help.salesforce.com/s/articleView?id=sf.cpq_evergreen_use.htm&type=5

My Salesforce notes

Search This Blog