Questions tagged [data]

All Data related Queries

Filter by
Sorted by
Tagged with
-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 ...
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 ...
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 ...
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 ...
-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 ...
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 ...
-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!
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 ...
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 ...
-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 ...
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'. ...
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?
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

1
2 3 4 5
10