Questions tagged [data]
All Data related Queries
499
questions
-1
votes
1
answer
31
views
Manually delete GroupMember Record
Would I be shooting myself in the foot if I manually deleted a single record from the GroupMember object that links an inactive user to a queue? Is there something that happens when you do it via the ...
- 97
0
votes
0
answers
78
views
How to conditionally disable the LWC lightning-datatable inline edit-panel?
I want to conditionally control the inline editing property of the Quantity column.How do i make it disable because i make validation in quantity field but when i check select all validation is not ...
- 59
0
votes
0
answers
34
views
Translation of formula field code into SQL
I am building a DWH and am currently working on our Salesforce data extractions. In order to improve data quality I would like to extract the formulas from custom fields and translate them into SQL ...
0
votes
0
answers
20
views
Get Geocodes using Address field Beta
I was wondering if salesforce's 'new' Beta custom fields can get geo coding?
After enabling the Custom Fields on the user interface we can get the Same functionality as the address fields on account ...
- 76
0
votes
1
answer
38
views
Running Apex in parallel
I have an Apex REST webservice that creates a contact and a community user when being called with some input data (username, email etc.).
I need to import about 20k users. I want to save processing ...
- 482
0
votes
0
answers
55
views
Unexpected token 'Boolean'
Hey guys I'm new to Apex and even pretty new to Java, It's probably a stupid mistake but I can't figure it out. I am getting "Unexpected token 'boolean'." error , tried with both Boolean and ...
- 3
1
vote
1
answer
133
views
Special Characters breaking Apex Loop
I have code that is being uploaded as a CSV that is breaking if special characters are present i.e:
comma ,
Apostrophe '
à
I have built docs that has them remove these but the one I am not sure how ...
0
votes
2
answers
59
views
Marketing Cloud - Create a Data Extension by filtering out Subscribers
big Marketing Cloud Noob here!
I have inherited the admin Role in the Company in Marketing Cloud and I cannot make ends meet.
My Company regularly sends emails to their subscribers and professionals ...
0
votes
0
answers
57
views
Inspector Update Data Unexpected Token
I am trying to insert the data from an excel sheet which I previously exported. I just merged two fields together. I keep getting the error message unexpected token. So I tried to not insert the whole ...
- 5
0
votes
0
answers
46
views
Data Extension masking in marketing cloud
I am trying to mask Data Extension records followed by PERSONAL INFORMATION PROTECTION ACT (Korea regulations). In this case, I need to mask as below;
For example,
Customer Name: John -> J**n
...
- 1
0
votes
1
answer
22
views
Turning off Visual Flows through CCI
I would like to load large datasets using Snowfakery and CCI into a testing environment. There are some flows in the org that fail and prevent the data from getting loaded. What I am trying to figure ...
0
votes
1
answer
157
views
To seed the data from production into the developer sandbox using SandboxPostCopy interface
I don't have much experience in the creation of sandboxes. I have a requirement to seed some data from Prod into the sandbox using SandboxPostCopy interface. Is there any way I can do that using SOQL'...
- 37
0
votes
0
answers
93
views
Is it possible to perform validation of data in data extensions in SFMC automatically?
Currently, we have a ton of AdHoc (one-time emails) each month and for each email:
the email creative is different
audience list and DE fields are different
So, every time we get the list imported ...
- 169
0
votes
1
answer
906
views
LWC - Perform Data validation on Table upon entering value on Table column and populate other columns
In one of my requirements I am having a empty table with just one blank row having some 5 columns. I can enter new record/data on the rows.
On one particular column, when the user enters the data on ...
0
votes
0
answers
14
views
Trigger Email from Marketing cloud when a record is added manually to DE [duplicate]
Built a DE and template and configured Trigger Send by selecting both respective DE and template.
I have activated the TSD, when I manually added a record in DE under Contact builder. the TSD did not ...
- 17
0
votes
2
answers
48
views
Is there a way to make this apex more performant?
I have a class I am working on that will export a CSV that includes "Case Number", and "Last Outbound Customer Activity Date". There is some logic included in my Apex that ...
-1
votes
1
answer
300
views
Using the same Data Extension for multiple Journeys Processing Power
I understand that you should not use the same DE for multiple journeys if this automation is run continuously on a daily basis and the journey is constantly recorruring.
BUT can I use 1 de for ...
- 127
-1
votes
1
answer
275
views
Where can I find the field names of individual fields in the Address compound field
I am pretty new to Salesforce. I have just learned that the Address and Name field in the contact object are compound fields consisting of individual fields. Where can I find the field names of the ...
0
votes
1
answer
376
views
“Best Practice” way to get value from child record saved to parent record
I get similar business requirements that ask:
Get the latest child record where field X is not null, and copy field X's value to its parent's field Y
The solution must work with bother master-detail ...
- 2,768
0
votes
0
answers
26
views
Initialise Salesforce sandbox from a static dataset [duplicate]
I have a scenario where a sandbox is used for training purposes and needs the data to be reset and reinitialised from a static dataset for each training session.
What would be the recommended approach ...
- 101
-1
votes
2
answers
58
views
How to update accounts & contacts from public forms without destroying existing data
We have Form Assembly forms publicly available on the internet which are working well. Within these forms, we collect a lot of data about our clients (350+fields). We want to bring that data into ...
- 636
0
votes
1
answer
250
views
Where can I find standard validation rules?
In a developer org, although validation rule lists are empty, checks are performed against data. E.g. trying to create an Entitlement record may lead to an error "The number of Remaining Work ...
- 113
0
votes
1
answer
24
views
Is it possible to change reference code of an object?
I am thinking about storing reference codes (for example storing "C012345" for Contract object with ID a012E00000LAZPIQA5) so I would not need to use SF API when I need those values. Can ...
- 103
0
votes
2
answers
163
views
How to control edit access to Role?
I have a role Sales Manager. The sub roles of Sales Manager are Sales Rep A and Sales Rep B.
The records created by Sales Rep A user and B user are seen by Sales Manager. It is done by Role level ...
0
votes
1
answer
49
views
Search for "Role name" in automation
How do I use Workbench (or another tool) to query for Role Name. I have to update role names and I am trying to determine if any role names are hardcoded in any existing flows, process builder, ...
0
votes
1
answer
794
views
How to display records from a data extension on a cloud page
I am trying to display some records from data extension on a cloud page.
This is what I got so far but cloud page is showing nothing.
Note: "LU" is a field in my data extension with value 1 ...
- 169
0
votes
1
answer
812
views
How to retrieve a record from a data extension field in SFMC using SSJS
In my SSJS, I am using this approach to retrieve the value / record from a data extension field.
Data extension name is Test_QResult
Data extension field name from where i want to retrieve value is ...
- 169
1
vote
1
answer
460
views
How to get table name from another table in select query in SFMC
In my sql in SFMC i am trying to get table name from another table in SELECT query but it seems to be not working, considering declaring variables in not allowed in SFMC SQL
I have tried this but no ...
- 169
0
votes
2
answers
306
views
How to add personalization string _DataSourceName to SendLog in SFMC
We have a sendlog enabled for our account to capture all sends from all BUs.
In the SendLog DE, in past we added the personalization string %%emailname_%% to capture emailname as well (of course ...
- 169
0
votes
1
answer
630
views
How can I dynamically assign the options of a lightning combobox based on the input of a lightning input?
I have a lightning combobox (sizeCode) that I want to display the size codes for a product based on the model number that is input in a separate field.
Apex class is working to return an object filled ...
- 1
-1
votes
1
answer
880
views
Finding the difference between new value and old value for amount
I have a basic opportunity field history report that's filtered so I'm only looking at changes in Amount. I want a column that shows me the difference between the new value and the old value. I tried ...
0
votes
1
answer
251
views
How to extract Field History for a Custom Object
In dataloader, there's no CustomObject__History object when clicking "Show All Objects". Can FH for a custom object be extracted somehow?
My object is on the detail side of an MD ...
- 250
0
votes
1
answer
267
views
LWC - Don't get the Data
With this code, I want to get the last stock value of my record respecting the condition and transfer the value in ‰ and take only the two digits after the decimal point.
The problem I have is that I ...
-1
votes
2
answers
90
views
how I will get all the record from QA to a fresh sandbox? [closed]
I want to get all the records in a fresh sandbox from QA. please guide me thanks
0
votes
4
answers
429
views
Salesforce Data Dictionary Selective Standard + Custom Fields
I was tasked with creating a Data Dictionary to document fields and objects in my Salesforce Org. The dictionary would be a reference point to all teams that would be used to rationalize the existing ...
- 1,272
0
votes
2
answers
4k
views
To display the spinner until all the data is rendered on the UI in LWC
<lightning-button-icon icon-name="utility:chevrondown" variant="bare"
name="add-PickUpWindowSelect"
...
- 37
0
votes
1
answer
250
views
Finding fields for standard data types
I've been trying to complete a challenge on trailhead (link here)
The text says
"Create an Apex trigger that sets an account’s Shipping Postal Code to match the Billing Postal Code if the Match ...
- 13
0
votes
0
answers
59
views
Saving data in cache from Lightning Component in Mobile
i have a custom Lightning component displaying some data from a record, unfortunately on mobile, the data from the component isn't stored in cache like the data from the standard layout, so if the app ...
2
votes
0
answers
161
views
Safely replace a packaged Master-Detail with Lookup
My active 1GP Managed Package app suffers from Account and Data skew (with ROW LOCKING) because we made a custom object AccountItem__c a child in a Master-Detail relation (MDR) ship with Account.
As ...
- 36.4k
1
vote
2
answers
374
views
CPU Timeout Error When Inserting 2000 Records through Apex
I created an apex class that is activated by a button for a 1 time use insert of about 2000 enrollment records. The code works with small amounts of records but when with the full 2000 I get a ...
- 17
-1
votes
1
answer
451
views
Converting CSV to an APEX List [closed]
I have a csv file downloaded with 1 column listing about 3000 names. What is the simplest way to grab all these names and store them in a List to be further manipulated in Apex?
Thanks!
- 17
0
votes
0
answers
77
views
LWC Component datatable
Hi all I am working on an lwc component datatable and I have a object named OpportunityContactRole related to the parent object Opportunity.Also another object named GrantContract is related to the ...
- 20
0
votes
1
answer
525
views
SSJS Lookup All Rows from Data Extension Column as Array
So I have a "Master" Data Extension that has a ton of columns and rows (millions), and one column needs to have some changes made for specific rows based on Customer_ID. I have a ...
- 27
0
votes
1
answer
246
views
SFDMU - Deleting 30 Millions records
I deleted 30M records with SFDMU.
The only issue I faced was that I have to update the Json file for every 900,000 records and re-trigger the job using sfdx sfdmu:run --targetusername Production.
By ...
0
votes
1
answer
272
views
Lookup filters based on values populated from junction object's parents
I have a junction object that connects a Lead to a Schedule object. This junction is called Schedule Registration.
A user creates a Schedule Registration by locating a Schedule they want to register a ...
- 477
-1
votes
1
answer
110
views
Salesforce Shield Encryption - official video showing invalid information
I was looking into Salesforce Shield Encryption.
Apparently Salesforce Shield Encryption does not mask any data, but encrypts the data at rest, which means only at the database level. Anyone who has ...
- 482
2
votes
0
answers
3k
views
A summary formula field in report used to count sum of related lookup records is displaying incorrect value
I believe this question is somewhat related to Formula Field to Count Records in Lookup Relationshp.
I have a 'primary' object called 'Tennis Player' and a 'secondary' object called 'Tennis Reports'. ...
- 3,568
1
vote
1
answer
158
views
Does workbench store or cache data anywhere outside of Salesforce?
If you import a data file into workbench for querying or attempting to load into Salesforce, is it stored anywhere outside of Salesforce that may need to be purged?
- 21
0
votes
1
answer
44
views
Tracking sends event from within app exchange > query studio
I'm trying to access send data from within a sql ui. We have 'QueryStudio' under app exchange which let's me query data extension tables. E.g.
select AccountId
from Contact_Salesforce
Our data ...
- 109
1
vote
1
answer
788
views
Python Simple-Salesforce - Import related records with an external ID
Some time ago I've started to use Python with Pandas and Simple-Salesforce to make data migration to Salesforce orgs.
I want to insert Account records and Contact records that have lookup to Account ...
- 121