Questions tagged [convert]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
14 views

SQL - Could not convert date and/or time from string data type

What I have: A source data extension with slightly over 14000 records Two attributes in the DE: GlobalID (Text 10) BirthDay (Text 8, YEARMONTHDAY, no dashes) The target data extension has ...
5
votes
1answer
522 views

Unusual error when I try to sfdx force:source:convert

I'm using the exact same methodology and commands I've used dozens of times, and now I'm getting an error. VS Code, latest version; sfdx extensions, latest versions. I want to convert my source to ...
0
votes
1answer
16 views

I can't convert my Master-Detail field to a Lookup field because the Change Field Type button is not visible

I have deleted all Roll-up Summary fields in the Master object including those in the Deleted Fields but the Change Field Type button is still not showing. Do you have any idea what I can do?
0
votes
1answer
79 views

Lightning Lead Convert Modal

Prior to the Summer 19 Release the 'Convert' button on Leads would open in the a modal popup as shown below: However now when our users click the convert button the screen opens in a sub tab and does ...
0
votes
0answers
40 views

sfdx force source convert not allowing spaces in names

I'm using SFDX on a Windows machine. The following command is giving me errors when running from a bash terminal: sfdx force:source:convert -d mdapi -n 'My Alias' It keeps returning this error: 'D:...
1
vote
1answer
399 views

Convert Lead button working in Lightning and Sandbox but not Classic

The Convert Lead button has suddenly stopped working in Classic. The button is on the lead page but when clicked nothing happens. No changes have been made to permissions and I've rechecked them all. ...
3
votes
2answers
158 views

Convert different Date Formats into Date based on User locale

I am getting different formats of date formats in date field from Json as a string. I should be able to convert any Date format into Date based on user locale.below are the example of formats. Ex: "...
2
votes
1answer
217 views

Magic Mover Conversion Tool

I installed the Magic Mover conversion tool. We're looking to convert in sandboxes first then convert our production environment. I tested 1 record in our partial sandbox. Magic mover worked just fine....
0
votes
0answers
52 views

Convert project to DX - community page

So I followed the instruction to converting an existing project to DX. Created a unmanaged package. Retrieved and converted the zip file. All good so far. When I pushed my code to a scratch org, ...
0
votes
1answer
301 views

Wrong date when converting datetime value to date field

I am using the REST API for creating a new Task record, including an Activity Date in the format YYYY-MM-DDThh:mm:ssZ. My current timezone is UTC+1. When submitting a date in the first hour of the ...
0
votes
1answer
2k views

Convert JavaScript button for lightning!

I have a JavaScript button which works fine in classic but doesn't show up in lightning, my guess that JavaScript buttons are not supported in lightning, I couldn't convert it using the converter ...
0
votes
2answers
526 views

Remove time stamp from the date

I want assign a date value into a WHERE clause of query This is my date Date myDate = System.Today().AddDays(Integer.valueOf(Deal_Expiration_Batch_Settings__c.getInstance()....
1
vote
2answers
104 views

Convert a number picklist to date field & send email on that date before

I have a picklist with values from 1 to 31.It corresponds to the date. My requirement is to convert this number selected to a date. Lets say the number selected is 20 then it has to correspond to 20th ...
1
vote
0answers
1k views

Use Reports API to get report results as CSV

Using the Reports and Dashboards API is there a way to convert report results to CSV? Reports.ReportResults results = Reports.ReportManager.runReport(reportId, true); Map<String, Reports....
0
votes
1answer
159 views

Assign queried Decimal to a Decimal variable

question - want to use a number field called Rebate_Amount__c on object called Rebate_schedule__c (child to Opportunity) to cut a rebate on the Amount__c field on a Revenue_schedule_Summary_Amount__c ...
1
vote
1answer
503 views

Convert to DateTime, without also converting to GMT?

We have incoming JSON from one of our client using REST API. The JSON they send has a timestamp value as a String like this "timestamp": "2017-01-11 19:23:27 CST". CST here being China Standard Time ...
4
votes
1answer
615 views

Autopopulate Custom field when Lead is converting

When I am converting Lead I wants to auto populate field before lead is converting screen. In Lead I am have custom field named "Campaign name" and In task section I have created custom field named "...
7
votes
2answers
745 views

Convert a binary value to an decimal value

I would like to know if there is a method to convert a binary value to a decimal value? For example, I need to convert the binary 10000101111010 and get the result 8570.
0
votes
1answer
182 views

Populate custom Leads fields to Assets fields on 'convert'

My company wants to gather the client's assets at the lead stage and automatically populate the assets page of the account once the lead gets converted. The same assets fields currently exist as ...
4
votes
2answers
948 views

Is there a way to hide/disable standard Salesforce button clicked

Is there a way to stop standard Salesforce button being clicked? in the Lead page I have a standard button called "Convert" I want the user to stop clicking until the Lead is in certain stage, I'm ...
1
vote
0answers
141 views

Cannot convert unconverted lead

When trying to convert a lead which hasn't been converted I get one of the two following errors: Error: System.DmlException: Update failed. First exception on row 0 with id 00QN0000005zrQtMAI; ...
0
votes
1answer
2k views

Convert String array to Set of string in apex class

Can someone please help me to convert String array values to Set of string? I have below code where it says Set is not getting populated from string array. Criteria=[SELECT Franchise__c FROM ...
3
votes
1answer
446 views

Lead Conversion- sometimes merges with existing contact and sometimes doesn't..why?

Sometimes when my users are converting leads, after they click "Convert", it will bring up another screen asking if we want to merge the lead with an existing contact. This is not consistent and ...
2
votes
1answer
269 views

Custom button to open opportunity after lead is converted

I have a global class that creates an Opp from a custom lead conversion button. The problem is that the button works to convert the lead to an Opp but it does not open the Opp. I get an error message ...
0
votes
1answer
638 views

Lead Source Gone after converting “Lead” to “Contact”

I am having some trouble keeping the lead source. For some odd reason when I am converting a lead into a Contact/Account the lead source that originally came with the lead seems to disappear. Then I ...
0
votes
1answer
1k views

Convert date in Marketing Cloud

I need a help to change the format of a date MM/dd /yyyy to dd/mm/yyyy I tried this: Works! Now: %%=Format(Now(),"MM/dd/yyyy")=%% Does not work! Date of Vestibular: %%=Format(%%Date Vestibular%%, ...
2
votes
1answer
651 views

Excel to UTF-8 encoded CSV [closed]

How can one convert an Excel file into a UTF-8 encoded CSV?
1
vote
1answer
642 views

How to find the original lead after it has been converted into an opportunity?

I've asked a similar question recently and got the answer I was looking for but still have a bit of a predicament. In the call centre, agents take calls from technicians who sell new business to ...
5
votes
3answers
31k views

Function to convert String to Decimal value?

I need to convert String into Decimal. the isNumeric() method is retuning false if value is Decimal. Another alternate: try { Integer x = Integer.valueOf(myString); } catch (exception e) { // ...
1
vote
0answers
46 views

Map Url field via Object Converter

Could you please advise how to make a map between two fields by using the Object Converter. Here is what I need to achieve http://postimg.org/image/kzhf2h28p/ Unfortunately the Applicants Website(s) ...
1
vote
0answers
36 views

Adding a time to datetime

I need some help correcting the time when doing a datetime convert. Currently when running the script below I get a time of 12:00AM - I need it to state 8:03AM SELECT [custcode],[customername],[...
3
votes
1answer
175 views

How to stop converting Lead to Account in trigger without addError() method

I would like to know how to stop converting Lead to Account in before insert trigger without addError() method? To be more precise I try to achieve the following: 1. Stop the process of converting ...
1
vote
1answer
1k views

Trigger for Converting Amount(Currency/Number) to Words

Has anyone else come up with a solution by Trigger for this? I have been trying to figure this out for a few weeks now but to no avail. for e.g Amount - 200$ Amount in words - Two hundred ...
0
votes
1answer
299 views

How can i convert an opportunity to a custom object using process builder

I'm looking to convert opp product lines to a custom object 'assigned products' using the process builder with the opportunity closing being the trigger to create the new record is this possible via ...
0
votes
1answer
189 views

Convert Leads Trigger Strange OwnerId Behavior

I have some code that automatically converts leads when certain conditions are met using the convertLead() method. This process is fairly well-documented in threads such as this: Convert Lead on ...
0
votes
1answer
1k views

Add an String value to a Integer SelectOption list - convert String to Integer

I got the following list of integer SelectOptions, and I want to add a String value to the SelectOption list. How can I convert String to Integer to add the String value? 'recordLimit' is an integer ...
3
votes
1answer
1k views

How to get the account Id thanks to the lead's Id after the lead conversion?

After a lead conversion, I have to redirect the user to a Visualforce page (saveUrl on the URL) to examine some fields of the account to redirect the user then (depend of the values of the account ...
5
votes
2answers
2k views

Convert Lead on Update trigger

anybody know how to convert a lead on update? It is for if the lead Email matches an existing Contact's email. I can get it to work on after insert, but when I try on update(before update or after ...
0
votes
3answers
2k views

Convert json string of datetime to a date

I have the following value coming through from a json payload, I need to convert it to a date value in Salesforce. The json body contains this: "ExpiryDate":"/Date(1617145200000+0100)/" When I ...