Questions tagged [update]
An UPDATE statement changes the data of one or more records already existing in a table.
383
questions
0
votes
0
answers
15
views
How to Update Records for lightning-datatable that have not been committed yet in a screen flow
I am using a lightning-datatable for flow screen navigation where by a user loops through a screen flow to generate objects that are stored in a collection variable that are actually inserted at the ...
- 1
0
votes
0
answers
34
views
Strange error : INVALID_FIELD, All accounts must have the same current owner and new owner.: [OwnerId]
We have a scenario in which when a custom object owner gets updated we will cascade that to all accounts related to that object via a junction object.
Code is very simple.
if (!studentClassRoomList....
- 6,302
1
vote
1
answer
30
views
Swap 2 "Unique" values in a single transaction
Scenario:
"User" Object has a field "UNEQ" which is setup as Unique.
Object "ABC" is adjusted in an Enhanced List View, which causes "User" to be adjusted via ...
- 1,235
-1
votes
1
answer
26
views
Trigger getting Coverage on Insert but not Update
Why This Question is Necessary:
It is clear that this question get's asked quite a bit on here, but the examples in other questions are oversimplified (for example the post had a "redundancy"...
- 1,268
0
votes
1
answer
34
views
Trigger - Create new record and update lookup field with the related record
I have two objects which have a lookup relationship.
Object 1 - Task
Object 2 - Bonus__c
When a task is updated to 'Completed', I am creating a Bonus__c record.
How to update the lookup field on Task ...
- 1
0
votes
0
answers
34
views
How LastModifiedby (field) updated for true changes
I have a field named LastmodifiedBy that have a lookup with the objet User and it changes and takes the name of the user without making any changes or modification in my record , I just have to ...
0
votes
0
answers
56
views
Data Loader: csv file with records without ID, instead with External ID
I used the upsert function in Data Loader, but it created new records, not updated records. How can I update these records using an External ID instead of a Salesforce ID?
On the Lead object I have a ...
0
votes
0
answers
42
views
Update boolean value in data extension from false to true with Ampscript?
I have a form on a landing page that uses the UpsertData function to add or update rows in a data extension.
In this data extension I have a checkbox with a boolean value.
I am doing a ...
- 11
0
votes
1
answer
25
views
Need to update over 300 custom objects and disable "enableSearch"
I need to update about 350 custom objects and remove the flag for "enableSearch".
We do not want users to search these objects so they will not get confused with the primary data points.
I ...
0
votes
1
answer
560
views
Update records using lwc
I have created an lwc component to enter the date picklist and text values and when I click save it gets recorded in the opportunity objects related fields.Right now I have created another object ...
0
votes
1
answer
204
views
Write a trigger on Contact and fill its Mailing Address with its Account's Shipping Address
I am trying to write an trigger for when a contact get inserted or updated its mailing address so i want to copy this mailing address to its associated account's shipping address.
I am getting this ...
- 11
0
votes
0
answers
21
views
Why the whole trigger is not running for the 200 records [duplicate]
I have written a trigger In which I created a field Sequence Number on Contact to maintain its state in the update case but after after inserting more than 200 records for two accounts contacts then ...
1
vote
1
answer
45
views
How to update records which also are updated by by batch process
We currently have a batchprocess running from a managed package which runs every day for almost the whole day to update records of an object. When a user tries to do an update on this object we have a ...
- 2,068
0
votes
1
answer
64
views
After update Trigger to avoid hitting governor limits
We have a custom object(Request__c) with lookup to PersonAccount(AssigneeAccount__c) and Account(BusinessAccount__c) similar to AccountContactRelation(ACR) standard object. There is a requirement ...
- 169
1
vote
0
answers
43
views
update sobject class
I'm trying to update sobject from one to another sf org.
I import my custom wsdl sobjectEnterpriseSoapSforceCom and sobjectEnterpriseSoapSforceCom, i pass login but i cannot able to update an sobject.
...
- 11
0
votes
0
answers
44
views
BillingState Issue
i am trying to get BillingState value from apex trigger before insert, before update. I have troubles when change the value it got the last one and not the actual value
I do a debug and get the last ...
1
vote
0
answers
25
views
RDKit not working on Heroku
I want to deploy a Flask app on Heroku that uses the RDKit package. I installed it with the requirements.txt and it worked fine, but since the new version rdkit-pypi==2021.9.2 it doesn't work anymore. ...
0
votes
1
answer
194
views
Error: Compiled formula is too big to execute (5,254 characters). Maximum size is 5,000 characters Description Help Text
I Have 20 formula fields that calculate a number value based on picklist value selected multiplied by a value in custom metadata. I want to sum all these 20 fields based on changes of the picklist ...
- 2,068
0
votes
0
answers
27
views
Mass re-rerun / re-evaluation of related records
I have an object called Journey. Each record of this object is made of several Steps(object) and Sub-Steps(object).
To create a Journey record, I use a Template (Journey Template object).
When adding ...
- 59
0
votes
1
answer
105
views
Difference between Upsert and Update database methods
Good morning.
Database.update (fields , allOrNothing)
Database.upsert (fields, externalId, allOrNothing)
I need help to understand why the second parameter "externalId" is not necessary on ...
- 27
0
votes
0
answers
71
views
How to update a counter on Parent Record considering all records in the transaction with a Record Triggered Flow?
I need to update a counter on the Account object everytime an Asset change its Status.
Let's suppose I have 2 Status 'Active' and 'Not active'.
The record triggered flow on the Asset (after-save) will ...
- 121
0
votes
1
answer
125
views
Rows.update data extension function
What is the error in this code:
<script runat="server" language="JavaScript" executioncontexttype="get">
Platform.Load("Core", "1.1");
...
- 13
0
votes
0
answers
348
views
Updating the column and data of lightning-datatable on change of a combobox value in LWC
I have created a lightning datatable and have populated contact data in it.I am trying to update the column and data in datatable on change of a combobox.
The combobox has three options Lead, Contact, ...
- 25
1
vote
1
answer
337
views
How to test trigger that compares Trigger.new with Trigger.old [duplicate]
I have a simple trigger that runs on Account update, and the only logic is a check to whether or now BillingPostalCode changes or not.
This is my code:
trigger ZipCodeUpdated on Account (before update)...
0
votes
1
answer
118
views
Update returning undefined
I'm trying to learn to code in Apex and LWC for fun, but I'm having an issue here that I've been able to understand why:
Apex class
@AuraEnabled(cacheable=true)
public static void sellItem (String ...
0
votes
0
answers
27
views
lightning:recordEditForm does not updating, just inserting
I used lightning:recordEditForm in my aura component file
and save button function is okay but I want update an already existing record..
When I click the 'save' button in edit page,
a new record is ...
-2
votes
1
answer
17
views
Update sibling records from the same object fails
I have a custom object called 'myObject__c'. This object has a lookup with Account. Now I want to get the values of an existing record (e.g. recordA) and update another record (e.g. recordB).
this is ...
- 21
0
votes
0
answers
44
views
Issues Updating a Contact via API
I am new to SalesForce as a whole, let alone needing to use its API. We keep track of and manage Contact information in a Google sheet, so that NON-Sales reps who assist with post sales can reach out ...
0
votes
0
answers
107
views
Getting Error while flow try to update event field
Can anyone please help me out in solving a process builder error?
I have created a Process Builder on the Event object which is updating a description field from a custom field on the event object ...
- 1
0
votes
1
answer
358
views
How to assign values to Schema.sobjectField[]?
I am working on after update trigger and I want to know what fields were updated.
I got a code on StackExchange which would serve my purpose :
But can anyone please help me on how to assign values (...
- 13
0
votes
1
answer
274
views
Marketing Cloud - change subscribers from Held to Active
I have a large list of subscribers I want to change from Held to Active. I've tried the following
For multiple records:
Allsubscriber >> search >> criteria is subscriber status -...
0
votes
1
answer
58
views
How to get the list of value from the metadata when updating picklist values through REST API
I am trying to update a picklist values through REST API, I'am having a problem getting the list of values so I can add new picklist values.
I'am having an error
System.TypeException: Invalid ...
- 113
0
votes
2
answers
545
views
Flow update record multiple times
I have a flow which update one record multiple times and I run into a soql query problem.
I have two objects A and B, the flow should copy the value of object A to B but only if the field is not null, ...
- 431
2
votes
1
answer
548
views
how to find this update will impact my org securely access aura components (update) winter 22? [closed]
https://help.salesforce.com/articleView?id=release-notes.rn_aura_security_ru.htm&type=5&release=232
I was not able to get the context,How it is going to effect my org ?
- 37
0
votes
2
answers
1k
views
Update total amount field on Account using trigger
I have written the following code to update a custom field (Total_Amount__c = Sum of the amount of all opportunities related to the account) on the update of Account. The following code works but ...
- 41
0
votes
2
answers
59
views
System.CalloutException when doing HTTP response [duplicate]
I keep getting System callout error when updating a contact field for multiple contacts.
System.CalloutException: You have uncommitted work pending. Please commit or rollback before calling out
...
1
vote
1
answer
23
views
Allow users to perform a Job only after hours
I am trying to understand or come up with a solution for the issue we currently having in our Org. We have a situation that our Marketing users are adding the existing contacts to the Campaign which ...
- 599
1
vote
0
answers
70
views
Updating a large batch of data in a DE without primary keys
I have an issue with a client, that I would like to know if anyone could help us with some kind of alternative solution. There is a client Data Extension with over 14 million records that we need to ...
0
votes
1
answer
107
views
Prevent deletion and update the records - Trigger
I have a need to kind of customize the deletion of a custom object.
The deletion need to update a checkBox to true instead of really delete the record.
For that I tried many things using trigger ...
- 423
0
votes
2
answers
4k
views
Executing the SFDX Update command to update the CLI to latest version is not working
I'm trying to run the sfdx update command in Windows 10 and every time it gives me the following log:
PS C:\Windows\system32> sfdx update
sfdx-cli: Updating CLI... already on latest version: 7.94....
- 5,596
0
votes
1
answer
191
views
How to add conditions to triggers
I have this Application object that runs through a trigger and trigger handler after DML update. Day-to-day this is fine since most Applications are produced by internal/system admin users but we now ...
0
votes
0
answers
39
views
The trigger is not inserting the field and is not being triggered either [duplicate]
I built a trigger to insert a custom object record (NPSResponse__c) when the SurveyInvitation object is updated. The Developer Consloe did not point out any errors, however when I update a ...
1
vote
0
answers
74
views
REST update fail, REST insert work
I have this strange issue. I have opened up REST requests using a read only user in a sandbox, all work fine. The request can post an insert in cases and send an update to changes status etc. I then ...
0
votes
0
answers
32
views
Why I cannot update the Account ID on this for loop?
for (Account acc : newAcc_lst) {
System.debug('to15format Test 1-> ' + acc.id);
Id to15convertString = acc.id;
System.debug('to15format Test 2-> ' + to15convertString);
String ...
- 157
0
votes
0
answers
294
views
Custom field updating in database but not showing in UI
I have a custom field on the Case object, which is of type Number(18,0).
This field is originally null, but after a trigger call, it gets updated to a certain value fetched from an API.
I have ...
- 23
0
votes
2
answers
222
views
Validation Rule Profile Exemption
I have a validation Rule that I require assistance with , this validation rule should only allow fields to be updated by the two profile ids specified:
NOT(
OR(
$Profile.Id = "...
- 3
0
votes
2
answers
247
views
Update a record in future method with JSON data [closed]
From process builder getting record id and pass that in to apex.
Apex class to update the record:
public class BacktoQuantum
{
@InvocableMethod(label='getdata' description='Get data ...
user96108
1
vote
0
answers
43
views
Trigger with callout not updating a field on Case object
I have a future callout which is triggered after case creation/update.
The callout sends a request to my backend to create a resource there, then, it returns the resource ID, and it should ideally add ...
- 23
1
vote
1
answer
220
views
Invalid Field Mapping in DataLoader
DataLoader is not loading the column correctly.
I'm trying to update Task...But I get the error "Id not specified in an update call"
What i have to do in this case?
- 123
0
votes
2
answers
334
views
Update Salesforce record with where condition from field
We have custom object where we have custom field as status as open, inProgress and close.
We are creating this custom object record using connected app via REST API. We are updating the fields as we ...
