Skip to main content The last day to register for a Salesforce or Tableau exam is June 30th. Learn more about the new Salesforce certification experience coming July 21st.

Feed

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

Hi, everyone! I am using NPSP and have an Opportunity Flow with several Decision Outcomes that updates a picklist field on the Opportunity (that triggers 1 minute after the Opportunity: Last Modified Date is updated). I keep receiving the following email error re: the Account record:  

 

The flow tried to update these records: null. This error occurred: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 1 records: <Account Id>. 

 

I've checked for other conflicting Opportunity or Account Flows but cannot figure out where the conflict is happening. :( Any help is much appreciated -- thank you!  

 

cc: @Dar Veverka @Judi Sohn @Nonprofit Success Pack @Nonprofit Ask Me Anything (Global) @Nonprofit Hub

 

#NPSP  #Flow  #Flows  #Salesforce Admin  #Nonprofit Success Pack  #Saleforce Administrator

4 answers
0/9000

We have Project Sponsors who retrospectively enter several Opportunity Stage Updates once a month (so we cannot accurately use inbuilt Todays Date, but need then to enter a date manually. 

They also want to enter,  for each stage, CIDs - if the there was a delay initiated by the customer (outside of business control).  

Then they would like to report the stage durations minus any recorded delay (CIDS). 

 

Has anyone had a similar requirement and can share a solution they had considered? 

 

#Salesforce Developer

 

#Sales Cloud

 

 

#Reports & Dashboards  #Salesforce Admin  #Salesforce

2 answers
  1. Today, 3:04 AM

    Thank you Abhishek, 

    the problem i have is...  we are not using the 'system date (TODAYS Date)' when a stage is  changed. 

    Because our Opp.  stage changes are done retrospectively, sometimes weeks later, the Business user needs to enter a date in a custom field to accurately log when the stage was actually changed.  

    That date is then used for accurate reporting of KPI's.

0/9000

For updating record do i need to update the value of record modifield field? 

If  I am trying to update the record without updating the record modifield field value. Data is not updating in data cloud. 

Can anyone explain the use of record modifield field.  

or is there any way by which i can remove this field.  

#Data Cloud

3 answers
  1. Today, 3:04 AM

    When you send a record to a Data Stream, Data Cloud checks if the value of the PK field is an existing value in the Data Stream. If the value of the PK field doesn't exist, Data Cloud creates the record. If the value of the PK field already exists in the Data Stream, Data Cloud evaluates whether the value of the field used as the Record Modified Field is more current than the value stored in the Data Stream. 

    If the value is more current, Data Cloud updates the record in the Data Stream. Otherwise Data Cloud does not update the record because it assumes that the record stored in the Data Stream is a newer version.

    The documentation says

    the following: 

    The record modified field acts as a reference point when the system is deciding whether to update the record in the event data is received out of order. 

0/9000
3 answers
0/9000

8.[Filter Records (レコードを絞り込む)] セクションの [Field (項目)] で [SourceRecordId__c]

 を選択します。 

これは、1 つ目のテーブルのソース ID 列の実際の名前です。

 

についてですがFieldの選択肢の中に該当する 

[SourceRecordId__c]

が出てきません。対処方法につき教えてください。 

Agentforce を強化して会話の言葉でデータを操作する

 また同じ画面の左側に3つエラー表示が出ております。このエラーを解決しないと選択肢が出てこないのでしょうか?その場合の対処方法についてもご教示いただきたいです。 

 

スクリーンショット 2025-06-24 11.38.33.jpg

 

 

 

#Trailhead Challenges

2 answers
0/9000

I have a simple prompt with an input field called 'FinalPrompt'.   The prompt is simple as well:   summarize the visit reports using {!$Input:FinalPrompt}.   I have a simple LWC that allows the user to enter their own question that I will pass to the prompt. 

 

In my apex, i have pulled my data that I want to pass to the LLM, I have the user entered question.   I created my inputValueMap with the string 'FinalPrompt' and all the user question and data in a string. 

 

I keep getting the error "required input is missing for parameter Input:FinalPrompt".   I have verified by doing a preview the input field is called 'FinalPrompt' 

 

Has anyone had success collecting data in apex and building the prompt and passing it back to the LLM to process and get a response? 

 

Any insight or hints would be appreciated. 

 

thanks 

Mike 

 

#Salesforce Developer  #Developer Forums

2 answers
  1. Sushil Kumar (UKG) Forum Ambassador
    Jun 23, 10:06 PM
    See if this helps - https://medium.com/@sfdcsushil/invoking-einstein-prompt-from-lwc-apex-941d56b7829e. I had done this few months ago, there maybe small syntax change, you can try this and see if it helps.
0/9000

The object is Request TRacker. We do work requested by others within the org. We have a field Actual Completed Date.  Manager wants years down the side (so I'm thinking Actual Completed Date sorted by year in Group Rows. Then somehow, like with the same field grouped columns by Month. How to do? 

 

#Reports & Dashboards

1 answer
  1. Today, 2:40 AM

    Hi Patricia,

    Simple suggestion is to have a formula field which stores the same value as that of Actual Completed Date.

    You can rename that by Actual Completed Month.

    Then you can add both fields into grouping one by month, one by year.

    Thanks

0/9000

 I did set the permission set along with permission provided to object and field level but getting an error stating unable to find that permission set grants read access and edit access to all Job Application fields, except edit access for Position and Candidate. 

 

#Trailhead Challenges

8 answers
0/9000

I have created a flow that will set all cases associated to a parent record along with the associated case tasks to a certain status based on the parent object stage. There are multiple cases on these records and within those, multiple tasks.  

 

I have a get records element on Cases where I'm storing all related case records, then a decision and if it finds records, a loop and an assignment to set the status on all records. Later it will update. 

 

Next, I have a second get records element for Tasks, also getting all records. But I am unable to use the Get case record collection variable as the Related to ID.  

 

So, I selected Choose fields and assign variables (advanced) and created a record collection variable on case to use to get the case Ids in my get tasks element, which it does allow me to do, but I keep getting the message "the sObjectInputReference field can reference only values with data type SObject. Replace the value "Cases_Loop" related to the loop.  

 

How can I accomplish this? Thanks! 

 

#Flow

1 answer
  1. Today, 2:32 AM

    Hi SK

    In get records itself there is an option to get related records which is in piloted version.

    Have you tried using that?

    Thanks

0/9000

While testing ai assistants in a Dev Sandbox, I stumbled on this bug, the event "assistant_thread_started", only delivers this object without channel_id in the context when the user opens the assistant view: 

{    type: 'assistant_thread_started',    assistant_thread: {      user_id: 'U090E8G7ZMX',      context: { force_search: false },      channel_id: 'D090EGK6TMX',      thread_ts: '1750380742.239779'    },    event_ts: '1750380742.269130'  }

But if I change the channel, the other "assistant_thread_context_changed" event does deliver the expected data: 

{

    type: 'assistant_thread_context_changed',

    assistant_thread: {

        user_id: 'U090E8G7ZMX',

        context: {

        channel_id: 'C08V9QFMMSS',

        team_id: 'T08V1DQ67UP',

        enterprise_id: 'E090E8G6GJD'

        },

        channel_id: 'D090EGK6TMX',

        thread_ts: '1750378672.425729'

    },

    event_ts: '1750378676.652923'

    }

 

*Just to be clear, the bot/ai app does have access to the channel, I also double checked using the suggested 

https://slack.com/api/conversations.info?channel=C08V9QFMMSS&pretty=1

1 answer
  1. Today, 2:31 AM

    👋 This seems unexpected to me since the `force_search` argument isn't included in documentation but for now we're keeping track of this issue on GitHub.

0/9000